LoadFromXml xml

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

LoadFromXml xml

Postby gmuller@vonet.ch » Tue Dec 13, 2011 1:12 pm

Hello,
I want to load an XML file and save it as xlsx. Can you help me, it does not work!
[list=]
sPath = g_sExport & "\" & Me.Name & ".XML"
sFinal = g_sExport & "\" & Me.Name & ".Xlsx"
Dim workbook As Workbook = New Workbook()
workbook.LoadFromXml(sPath)
workbook.SaveToFile(sFinal, ExcelVersion.Version2007)
[/list]

Thank you in advance,
greetings
Muller Guy
gmuller@vonet.ch
 
Posts: 8
Joined: Wed Mar 23, 2011 10:58 am

Re: LoadFromXml xml

Postby Tina.Lin » Wed Dec 14, 2011 6:54 am

Hello gmuller,

Thank you for your inquiry.

Please try the following code to achieve your functionality.
Code: Select all
           Workbook workbook = new Workbook();

            //Initailize worksheet
            using (FileStream fileStream = File.OpenRead(@"..\..\ReadXMLSample.Xml"))
            {
                workbook.LoadFromXml(fileStream);
            }

            workbook.SaveToFile(@"..\..\Test.xlsx", ExcelVersion.Version2010);
            System.Diagnostics.Process.Start(@"..\..\Test.xlsx");



If you still have any other questions, please don't hesitate to contact us.
Have a nice day.
Tina
Technical Support/Developer,
e-iceblue Support Team
User avatar
Tina.Lin
 
Posts: 152
Joined: Tue Sep 13, 2011 5:37 am

Re: LoadFromXml xml

Postby lovesha » Thu Feb 01, 2018 2:00 pm

Hi,

I have downloaded free trial version to test LoadFromXml file in Spire.Xls.

It says LoadFromXml doesn't exist in current dll. exe is spire.xls-fe_7.9
lovesha
 
Posts: 1
Joined: Thu Feb 01, 2018 1:50 pm

Re: LoadFromXml xml

Postby Betsy.jiang » Fri Feb 02, 2018 3:27 am

Dear lovesha,

Thanks for your inquiry.
Free Spire.XLS for .NET Version:7.9 has the method LoadFromXml, please make sure you are using correct version, and below is dlls information for checking.
Spire.Common.dll V1.2.366.55040
Spire.License.dll V1.3.5.40
Spire.XLS.dll V7.9.0.5504
Spire.Pdf.dll V3.6.230.55040

Sincerely,
Betsy
E-iceblue support team
User avatar
Betsy.jiang
 
Posts: 1694
Joined: Tue Sep 06, 2016 8:30 am

Re: LoadFromXml xml

Postby Betsy.jiang » Mon Feb 05, 2018 8:49 am

Dear lovesha,

Greetings from E-iceblue.
Has your issue been resolved ? Could you please give us some feedback at your convenience ?

Sincerely,
Betsy
E-iceblue support team
User avatar
Betsy.jiang
 
Posts: 1694
Joined: Tue Sep 06, 2016 8:30 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests