Serialize/Deserialize Spreadsheet Control

[Carlos Diaz]

Hi,

I'd like to know if it is possible to serialize/deserialize the spreadsheet control as string, xml, binary, etc. Including;

Formatting

Named Ranges

Formulas

etc,

I'd appreciate your help.

Thanks in advance.

Carlos Diaz.

[Pannir Selvam S]

Hi Carlos,

Thanks for contacting Syncfusion support.

We have analyzed your query and you can serialize and deserialize the spreadsheetcontrol as xml file by using the workbook like in the below code snippet and it should include formatting, formulas, named ranges etc.

Code Snippet[C#]:

private void Serialize_Click(object sender, RoutedEventArgs e)

{

    IWorkbook workbook = this.spreadsheetControl1.ExcelProperties.WorkBook;

    workbook.SaveAsXml('test.xml', ExcelXmlSaveType.MSExcel);

}

private void DeSerialize_Click(object sender, RoutedEventArgs e)

{

    ExcelEngine engine = new ExcelEngine();

    IWorkbook workbook = engine.Excel.Workbooks.OpenFromXml('test.xml', ExcelXmlOpenType.MSExcel);

    this.spreadsheetControl1.ImportFromExcel(workbook);

}

We have prepared a sample based on this and you can download the sample from the below location.

Sample: SpreadsheetDemo_WPF.zip

Regards,

Pannir

[Carlos Diaz]

Hi Pannir,

I have a problem with the solution that you mentioned, and surely you will able to reproduce the problem: ( use the same project that you attached before )

1. Click on Serialize.

2. Click on Deserialize.

3. Click on Serialize again, HERE is raising an exception ( ArgumentOutOfRangeException ).

Could you help me to resolve that?

Thanks in advance.

Carlos Diaz.

[Pannir Selvam S]

Hi Carlos,

 

Sorry for the inconvenience caused.

 

The reported query in this forum has been updated in the incident #111919 and you can follow the incident #111919 for further updates.

 

Please let us know if you have any queries.

 

Thanks,

Pannir

[Andreas Rothmann]

Hi,

i am currently evaluating the spreadsheet control. Now the functionality is essential for my application. I am not sure i am able to follow incident from other users, so my question: Is the serialization and deserialization fixed in the latest update?

Thank you very much!
Andy

[Pannir Selvam S]

Hi Andreas,

 

Yes. Now Serialization and Deserialization works properly in the SpreadsheetControl by using the code snippet provided in the previous update.

 

Please let us know if you need any further assistance.

 

Regards,

Pannir