Confused about XML Export

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Confused about XML Export

Postby msouphy » Tue Sep 03, 2013 2:14 pm

Hello,

Trying out your product because I have the need to be able to programatically export Excel to XML withhout Excel being installed on the server.

My Excel (2010) file has an XSD schema associated, using the standard Excel XML Map features.

Now I want to export this XML Map.

I followed your example entitled "Export Excel to XML and Import XML to Excel" with following code:

Code: Select all
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"..\..\test.xls");
workbook.SaveAsXml("sample.xml");


but what I get is a OpenXML XML document, instead of an XML document that is compatible with my custom XSD schema.

Am I missing something ? Please help me out.

Thank you.

Mathieu
msouphy
 
Posts: 1
Joined: Tue Sep 03, 2013 1:28 pm

Re: Confused about XML Export

Postby Gary.zhang » Wed Sep 04, 2013 9:57 am

Hello,

Thanks for your inquiry.
Sorry that at present our Spire.Xls product only supports the feature that export/import the OpenXML format XML document. And you could use the xsl to transform the OpenXML format XML document to a new XML document that is compatible with you custom XSD schema.

If there are any questions, welcome to get it back to us.

Thanks,
Gary
E-iceblue support team
User avatar
Gary.zhang
 
Posts: 1390
Joined: Thu Apr 04, 2013 1:30 am

Re: Confused about XML Export

Postby Gary.zhang » Mon Sep 09, 2013 9:53 am

Hello,

Has the issue been resolved? Can the method we metioned worked fine for you? Could you please give us some feedback if convenience?

If there are any questions, welcome to get it back to us.

Thanks,
Gary
E-iceblue support team
User avatar
Gary.zhang
 
Posts: 1390
Joined: Thu Apr 04, 2013 1:30 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests

cron