Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Apr 01, 2020 3:23 pm

Hello,

I am trying to convert xlsx workbooks to XML format. The original xlsx file has some columns containing dates. These are in this format: dd/mm/yyyy.
When I run the conversion using:

Workbook workbook = new Workbook();
workbook.LoadFromFile(filename);
workbook.SaveAsXml(newFilename);

The dates are no longer saved as dates, they are saved as numbers, below is a snippet from the XML: The row in red was a date in the xlsx document.

<Row ss:Height="12.75" ss:AutoFitHeight="0">
<Cell ss:StyleID="s49"><Data ss:Type="String">2</Data></Cell>
<Cell ss:StyleID="s49"><Data ss:Type="String">0</Data></Cell>
<Cell ss:StyleID="s49"><Data ss:Type="String">02</Data></Cell>
<Cell ss:StyleID="s49"><Data ss:Type="String">Test String</Data></Cell>
<Cell ss:Index="6" ss:StyleID="s51"><Data ss:Type="Number">43070</Data></Cell>
<Cell ss:Index="8"><Data ss:Type="String">Test data</Data></Cell>
<Cell ss:Index="10" ss:StyleID="s45"><Data ss:Type="String">0002</Data></Cell>
<Cell ss:StyleID="s45"><Data ss:Type="String">2</Data></Cell>
</Row>

If I 'SaveAs' xml spreadsheet in Excel, the same row appears as below.

<Row>
<Cell><Data ss:Type="String">2</Data></Cell>
<Cell><Data ss:Type="String">0</Data></Cell>
<Cell><Data ss:Type="String">02</Data></Cell>
<Cell><Data ss:Type="String">Test String</Data></Cell>
<Cell ss:Index="6" ss:StyleID="s65"><Data ss:Type="DateTime">2017-12-01T00:00:00.000</Data></Cell>
<Cell ss:Index="8"><Data ss:Type="String">Test data</Data></Cell>
<Cell ss:Index="10" ss:StyleID="s59"><Data ss:Type="String">0002</Data></Cell>
<Cell ss:StyleID="s59"><Data ss:Type="String">2</Data></Cell>
</Row>

Have you any idea why this may be please?

b.womersley23@gmail.com
 
Posts: 2
Joined: Mon Jul 08, 2019 12:24 pm

Thu Apr 02, 2020 2:33 am

Hello,

Thanks for your inquiry.
I did an initial test and indeed noticed this issue. I have posted it to our Dev team with the ticket SPIREXLS-2240 for further investigation. We will let you know if there is any update. Sorry for the inconvenience caused.
Besides, to help us better record your issue, please tell us your region setting information (E.g. China, Chinese). Looking forward to your response.

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Thu Apr 02, 2020 9:36 am

Hello Rachel,

Thank you for looking into this for me. My region settings are 'United Kingdom, en-GB'. Are you able to tell me how long this is likely to take to get a fix please?

Kind regards,
Ben

b.womersley23@gmail.com
 
Posts: 2
Joined: Mon Jul 08, 2019 12:24 pm

Thu Apr 02, 2020 9:46 am

Hello,

Thanks for your prompt response.
Sorry I can't tell you an estimated time about your issue at this moment. Our Dev team will investigate it and find the solution to resolve it. Anyway, I have requested our Dev team to share any possible ETA at their earliest time. We will inform you as soon as there is any update.
Thanks for your understanding.

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Thu Apr 23, 2020 11:20 am

Hello,

Thanks for your patient waiting.
Glad to inform you that your issue has been fixed. Welcome to download and test Spire.XLS Pack(Hotfix) Version:10.4.9 from the following links.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS/10.4.9

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Mon Apr 27, 2020 5:44 am

Hello,

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

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Return to Spire.XLS