2X faster development
The ultimate Xamarin UI toolkit to boost your development speed.
Syncfusion Essential XlsIO is a .NET Excel library used to create, read, and edit Excel documents. Using this library, you can start creating an Excel document in Xamarin.
Steps to create Excel file programmatically:
Note: If .NET Standard is not available in the code sharing strategy, the Portable Class Library (PCL) can be selected.
By executing the program, you will get the Excel file as follows.
A complete working example of how to create Excel File in Xamarin can be downloaded from Create-Excel-file.zip.
Take a moment to peruse the documentation, where you can find basic worksheet data manipulation options along with features like Conditional Formatting, worksheet calculations through Formulas, adding Charts in worksheet or workbook, organizing and analyzing data through Tables and Pivot Tables, appending multiple records to worksheet using Template Markers, and most importantly PDF and Image conversions etc. with code examples.
Refer here to explore the rich set of Syncfusion Essential XlsIO features.
An online sample link to generate Excel file.
See Also:
Create a Excel file in ASP.NET MVC Create a Excel file in ASP.NET Core Create a Excel file in Windows Forms
Note: Starting with v16.2.0.x, if you reference Syncfusion assemblies from trial setup or from the NuGet feed, include a license key in your projects. Refer to link to learn about generating and registering Syncfusion license key in your application to use the components without trail message.
|
2X faster development
The ultimate Xamarin UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.
Hi All, I am new to Xamarin and stuck with something. Please get me an idea how to solve this...
Details:
My main objective: I have a standalone application which allows user to upload an excel file. Once a file is choosen by user, the application successfully reads the data and shows in a form. Then user performs editing the data and after all edit is done, then I want the user to save the data back in somewhere. The only way I did was to send an email by converting my latest data into a csv file and attach that file in email and allow user to send that email. I have attached my gmail account to do so and everything works. But I want to extend my solution by playing with excel. I can successfully read the excel file and load data from 3 sheets. Then user edits the data and my final data is in my observable collection. Then while creating a excel file dynamically and attaching as an attachment, I FAILED. I just want to save the data back to my storage somehow or send a copy in an email attachment.
Any help will be much appreciated pleaseeee. Kind regards
Hi Bhabani,
Greetings from Syncfusion.
XlsIO doesn’t have support to attach files as an email attachment. Kindly try Xamarin.Essentials to do so. https://docs.microsoft.com/en-us/xamarin/essentials/email?tabs=android#file-attachments
You can save the edited Excel file to your storage successfully with the help XlsIO, which is shown in the following UG link. The saved Excel file can be sent as an attachment in a mail using Xamarin.Essentials.
https://help.syncfusion.com/file-formats/xlsio/loading-and-saving-workbook?cs-save-lang=1&cs-lang=xamarin#saving-a-excel-workbook-to-file-system
Please let us know if this helps.
Regards, Shamini