How to copy HTML file content to a XLSX file?

Question

4.00/5 (1 vote)

See more:

.NET3.5

Hi,
I'm able to copy HTML file content to a XLS file using this method[File.Copy()]properly. But while i'm copying HTML file content to a XLSX file, i observed its able to copy all data properly ,but its making this XLSX file curropted. SO its not able open in EXCEL 2007.Getting error as its a curropted file.

But if we manualy change the foramt of the same created XLSX file to XLS , then its able to open in OFFICE 2007(with a formal warning message as its a lower version formated).

I came to know an .xlsx file is opened strictly as a ZIP package used by 2007 office applications.So i don't feel there is any easy way to create a good XLSX file from a HTML file in C#.

So kindly please guide me if any different way to create this XLSX file.

Posted 27-Mar-11 19:54pm

pjhelp

Updated 30-Mar-11 0:56am

v3

Add a Solution

1 solution

Add a Solution

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

Dave Kreskowiak · Answer 1 · 2011-03-28T05:24:00

Solution 1

You can't. An XLSX file is really a .ZIP file with a bunch of files inside. Don't believe me? Take any .XLSX file and rename the file extension to .ZIP. Open it in WinZip or Explorer and peek inside.

Posted 28-Mar-11 5:24am

Dave Kreskowiak

Comments

pjhelp 30-Mar-11 6:03am

Yes Dave, I came to know "an .xlsx file is opened strictly as a Zip package used by 2007 office applications." . I also followed your suggestion and observed the same.
Still i'm hoping there may be any indirect way to create an XLSX file from a HTML file.Kindly please update me if you have any new idea.
And thanks for your response.

How to copy HTML file content to a XLSX file?

1 solution

Solution 1

Add your solution here

Preview 0

How to copy HTML file content to a XLSX file?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us