We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Excel XML ?

Thread ID:

Created:

Updated:

Platform:

Replies:

75612 Aug 1,2008 03:47 AM Aug 13,2008 03:22 AM ASP.NET Web Forms (Classic) 4
loading
Tags: XlsIO
Administrator [Syncfusion]
Asked On August 1, 2008 03:47 AM

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 [Syncfusion]
Replied On August 7, 2008 05:09 AM

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 [Syncfusion]
Replied On August 7, 2008 06:43 AM

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 [Syncfusion]
Replied On August 12, 2008 08:27 AM

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 [Syncfusion]
Replied On August 13, 2008 03:22 AM

Hi Greg,

Thank you for your update.

Please let me know if you have any other concerns.

Regards,
G.Yavana


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

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.

;