Excel XML ?

[Administrator]

Hi,

Is it possible to load or save an XML with the XLSIO, like it's possible to do it in Excel ?

Thanks,
Greg

[Administrator]

Hi,

No one knows ?

Regards,

>Hi,

Is it possible to load or save an XML with the XLSIO, like it's possible to do it in Excel ?

Thanks,
Greg

[Yavanaarasi G]

Hi Greg,

Thank you for your interest in Syncfusion products.

Yes. It is possible to load or save an XML with XlsIO. You can save and read the xml file by using the below code snippet:

IWorkbook workbook = excelEngine.Excel.Workbooks.Create(3);
IWorksheet sheet = workbook.Worksheets[0];

//Write data
sheet.Range["C3:O28"].Text = "Hello world";

//Save as SpreadsheetML:

workbook.SaveAsXml("Sample.xml", ExcelXmlSaveType.MSExcel);

//Read spreadsheetML:
IWorkbook workbook = excelEngine.Excel.Workbooks.OpenFromXml("SpreadsheetMLTemplate.xml",ExcelXmlOpenType.MSExcel); 

Also, please refer our shipped browser sample that demonstrates reading and writing XML files.
\\Syncfusion\EssentialStudio\6.3.0.30\Windows\XlsIO.Windows\Samples\2.0\GettingStarted\ReadWriteSpreadsheetML\cs

Please try this and let me know if this helps.

Regrads,
G.Yavana

[Administrator]

Thank you very much !

>Hi Greg,

Thank you for your interest in Syncfusion products.

Yes. It is possible to load or save an XML with XlsIO. You can save and read the xml file by using the below code snippet:

IWorkbook workbook = excelEngine.Excel.Workbooks.Create(3);
IWorksheet sheet = workbook.Worksheets[0];

//Write data
sheet.Range["C3:O28"].Text = "Hello world";

//Save as SpreadsheetML:

workbook.SaveAsXml("Sample.xml", ExcelXmlSaveType.MSExcel);

//Read spreadsheetML:
IWorkbook workbook = excelEngine.Excel.Workbooks.OpenFromXml("SpreadsheetMLTemplate.xml",ExcelXmlOpenType.MSExcel); 

Also, please refer our shipped browser sample that demonstrates reading and writing XML files.
\\Syncfusion\EssentialStudio\6.3.0.30\Windows\XlsIO.Windows\Samples\2.0\GettingStarted\ReadWriteSpreadsheetML\cs

Please try this and let me know if this helps.

Regrads,
G.Yavana

[Yavanaarasi G]

Hi Greg,

Thank you for your update.

Please let me know if you have any other concerns.

Regards,
G.Yavana