How to transform xmldocument to XLS using XSLT in C#

Question

0.00/5 (No votes)

See more:

C#

I am trying to Transform the XSLT,XSL file into .xsl . So i tried below coding

C#

Below Coding is working fine. But when i open the created Excel sheet it is opening in XML SPREAD SHEET 2003. But it should be open in Excel 97-2003 Workbook. How can i achieve ?

What I have tried:

string MyXmlPath = ReportPath + @"\XML\chennai.xml";
dataset.WriteXml(MyXmlPath);
string MyExcelPath = ReportPath + @"\Report\chennai.xls";

XPathDocument xmlDoc = new XPathDocument(MyXmlPath);
XslCompiledTransform XSLTransform = new XslCompiledTransform();
XSLTransform.Load(AppBasePath + @"\Master\XSLT\chennai.xslt");
XSLTransform.Transform(MyXmlPath, MyExcelPath);

Posted 8-Aug-16 21:54pm

Vicky Siddharth

Updated 9-Aug-16 1:17am

v2

Add a Solution

Comments

Kornfeld Eliyahu Peter 9-Aug-16 4:02am

Not clear...
XLS is a binary! format for older Excel files, so how do you expect to create one using XML transformation?

Vicky Siddharth 9-Aug-16 4:11am

Ok. Have any other methods to create .xls by combine xslt and xml ?

Kornfeld Eliyahu Peter 9-Aug-16 4:14am

No. There is no way to create any binary (including old Excel) file using XML and transformation at all...
Actually (as the format is proprietary) the only way is using Microsoft's tools...

Vicky Siddharth 9-Aug-16 4:17am

What do you mean by Microsoft Tool's? refer any dll's or what?

Kornfeld Eliyahu Peter 9-Aug-16 4:21am

Exactly. Referring the Office Interop DLLs and write some ugly code...
However, consider that Microsoft itself does not support old Excel, so you probably can focus on the new, XML based, format...

Vicky Siddharth 9-Aug-16 6:45am

Any Links to refer ?

2 solutions

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)

Kornfeld Eliyahu Peter · Answer 1 · 2016-08-09T00:52:00

Solution 1

How to: Access Office Interop Objects by Using Visual C# Features (C# Programming Guide)[^]
Microsoft.Office.Interop.Excel namespace ()[^]
How to: Use COM Interop to Create an Excel Spreadsheet (C#)[^]
https://support.microsoft.com/en-us/kb/302084[^]

Posted 9-Aug-16 0:52am

Kornfeld Eliyahu Peter

Patrice T · Answer 2 · 2016-08-09T01:17:00

Solution 2

you can't open an .xlsx (excel xml file) in excel 2003 because the .xlsx format was introduced with Excel 2007.
You need to install a MS extension to excel that allow excel 2003 to read .xlsx (Excel 2007) format.

Posted 9-Aug-16 1:17am

Patrice T