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.

Saving in 2007 .xlsx format

Thread ID:

Created:

Updated:

Platform:

Replies:

68689 Sep 27,2007 07:40 AM Oct 1,2007 06:52 AM Windows Forms 1
loading
Tags: XlsIO
Robert Pickering-LEFT COMPANY
Asked On September 27, 2007 07:40 AM

I can't work out how to save a work book as the 2007 xml format. I've tried the following code:

book.SaveAsXml("book.xlsx", ExcelXmlSaveType.MSExcel)

When I try and open the resulting document in excel 2007 I get a message saying "Excel can't open the file 'book.xlsx' because the format or extension is not valid".

When I look at the document in a text editor I see that it is an xml document, but I believe that an open office xml document is actually a zip containing a collection of xml documents.

Do I have to call another method to get it to export correctly? I cannot see any likely looking candidates

Administrator [Syncfusion]
Replied On October 1, 2007 06:52 AM


Hi Robert,

Thank you for your interest in Syncfusion products.

To save an .xlsx file in xml format, select the version to 'Excel2007'.

To open that xml file in xls format, select the version to 'Excel97to2003'.

Please refer the attached sample and let me know if you still face any issues.

http://websamples.syncfusion.com/samples/XlsIO.Windows/F68689/main.htm

Regards,
Jaya

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.

;