Transforming XSLT for Excel 2003 to Excel 2010

Question

0.00/5 (No votes)

See more:

Hi all,

Recently I have a task to upgrade the application that export data to Excel 2010, from Excel 2010. Anyone here can help to convert XSLT for 2003 to Office Open XML? Or am I in the right track?

Below is the sample XML content generated. If saved as .xls, it can be opened in Excel 2010. However, if I just rename the extension to xlsx, it can’t be opened. Please help. My task is to export the data to xlsx format. Thanks!

XML

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="header">
<Font x:Family="Swiss" ss:Bold="1"/>
</Style>
</Styles>
<Worksheet ss:Name="Sheet 1"><Table><Row ss:StyleID="header"><Cell ss:StyleID="header"><Data ss:Type="String">Level</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LVL IND</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LVL CODE</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">CLIENT CODE</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">CLIENT DES</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">CLIENT SUMM</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">TREE_ID</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">PERF DATE</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL CURR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL CURR ABBR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">ASSET TYPE</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SEC ID</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SEC DESC</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LS IND</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL BMV</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD BMV</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD BMV</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL BMV (PLCL BMV)</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL EMV</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD EMV</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD EMV</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL EMV (PLCL EMV)</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL PF</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD PF</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD PF</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL PF (PLCL PF)</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL NF</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD NF</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD NF</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL NF (PLCL NF)</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL INJ</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD INJ</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD INJ</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL INJ (PLCL INJ)</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL PL</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD PL</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD PL</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL PL (PLCL PL)</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL PB</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD PB</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD PB</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL PB (PLCL PB)</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL NB</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD NB</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD NB</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL NB (PLCL NB)</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL ROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD ROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD ROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL ROR (PLCL ROR)</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL NBROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD NBROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD NBROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL NBROR (PLCL NBROR)</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL BROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD BROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD BROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL BROR (PLCL BROR)</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL VA</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD VA</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD VA</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">PLCL VA</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">FKEY1</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">FKEY2</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">RKEY1</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">RKEY2</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">FKEY3</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">RKEY3</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL CBROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD CBROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD CBROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">PLCL CBROR</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD $VA</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD $VA</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">LOCAL ST</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">SGD ST</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">USD ST</Data></Cell><Cell ss:StyleID="header"><Data ss:Type="String">PLCL ST</Data></Cell></Row><Row><Cell><Data ss:Type="String">C698 - Portfolio</Data></Cell><Cell><Data ss:Type="String">1</Data></Cell><Cell><Data ss:Type="String">SUMM</Data></Cell><Cell><Data ss:Type="String">C698</Data></Cell><Cell><Data ss:Type="String">CLIENT_DES C698</Data></Cell><Cell><Data ss:Type="String">N</Data></Cell><Cell><Data ss:Type="String">CCORP</Data></Cell><Cell><Data ss:Type="String">11/11/05</Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">2,280,241,396.12</Data></Cell><Cell><Data ss:Type="String">1339545543.061630</Data></Cell><Cell><Data ss:Type="String">2,280,241,396.12</Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">2,283,595,436.46</Data></Cell><Cell><Data ss:Type="String">1340256149.5708</Data></Cell><Cell><Data ss:Type="String">2,281,264,865.95</Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">0.00</Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">0.00</Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">0.00</Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">0.00</Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">0.00</Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">0.00</Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">3,354,040.34</Data></Cell><Cell><Data ss:Type="String">710606.5091708080</Data></Cell><Cell><Data ss:Type="String">1,023,469.84</Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">2,280,241,396.12</Data></Cell><Cell><Data ss:Type="String">1339545543.061630</Data></Cell><Cell><Data ss:Type="String">2,280,241,396.12</Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">0.00</Data></Cell><Cell><Data ss:Type="String">0</Data></Cell><Cell><Data ss:Type="String">0.00</Data></Cell><Cell><Data ss:Type="String">-999999</Data></Cell><Cell><Data ss:Type="String">1.001471</Data></Cell><Cell><Data ss:Type="String">1.000530483277</Data></Cell><Cell><Data ss:Type="String">1.000449</Data></Cell><Cell><Data ss:Type="String">-999990</Data></Cell><Cell><Data ss:Type="String">-999,990.000000</Data></Cell><Cell><Data ss:Type="String">-999990</Data></Cell><Cell><Data ss:Type="String">-999,990.000000</Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String">-999,990.000000</Data></Cell><Cell><Data ss:Type="String">-999990</Data></Cell><Cell><Data ss:Type="String">-999,990.000000</Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String">-999990</Data></Cell><Cell><Data ss:Type="String">-999990</Data></Cell><Cell><Data ss:Type="String">-999990</Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String">C698</Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String">-999990</Data></Cell><Cell><Data ss:Type="String">-999990</Data></Cell><Cell><Data ss:Type="String">-999990</Data></Cell><Cell><Data ss:Type="String">3354040.34268309</Data></Cell><Cell><Data ss:Type="String">710606.5091708080</Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String">-999999</Data></Cell><Cell><Data ss:Type="String">-999999</Data></Cell><Cell><Data ss:Type="String">-999999</Data></Cell></Row></Table></Worksheet></Workbook>

Posted 3-Mar-11 22:02pm

jerox

Updated 4-Mar-11 5:49am

thatraja

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Henry Minute · Answer 1 · 2011-03-04T06:23:00

Solution 1

I would suggest that your best bet would be to use Office.Interop to load your file into Excel and do a SaveAs.

Posted 4-Mar-11 6:23am

Henry Minute