SfSpreadsheet provides support to serialize and deserialize the workbook using XlsIO.
Serialization: For serialization, you can use SaveAsXml() method of IWorkbook.
C# // Serialize MemoryStream serializedBinary = new MemoryStream(); this.Spreadsheet.Workbook.SaveAsXml(serializedBinary, ExcelXmlSaveType.MSExcel);
Deserialization: For Deserialization, you can use OpenFromXml() method of IWorkbook .
C# // Deserialize serializedBinary.Seek(0, SeekOrigin.Begin); ExcelEngine engine = new ExcelEngine(); IWorkbook workbook = engine.Excel.Workbooks.OpenFromXml(serializedBinary, ExcelXmlOpenType.MSExcel); this.Spreadsheet.Open(workbook);
Sample link:
|
2X faster development
The ultimate WPF UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.
