Export to excel from vb.net 2008

Question

2.00/5 (2 votes)

See more:

When i am exporting to excel file and saving it with xlsx format, it saves the file. But when i am opening the file it gives me the error as follows.

"Excel cannot open the file 'filename.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

but when i change the extension to .xls it opens the file. but the problem is if my rows are going beyond 65536 rows gets truncated after that. So that is the reason i amd saving it as .xlsx.

Is there any difference between exporting a file to excel 2003 and excel 2007 from vb.net 2008?

Posted 5-Jul-12 4:07am

mistryshailesh

Add a Solution

Comments

bbirajdar 5-Jul-12 10:38am

There are thousands of ways of exporting the data to excel....How can we guess the problem unless we know what code/logic you have written?

ZurdoDev 5-Jul-12 11:08am

Yes, there is a huge difference. The file format for xlsx is very different which is why you can't just name it that way and have it work. If you shared the code someone could possibly offer a better solution.

3 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)

Prasad_Kulkarni · Answer 1 · 2012-07-05T21:40:00

Solution 3

Refer: Export to Excel using VB.Net[^]

and Google too[^]

Posted 5-Jul-12 21:40pm

Prasad_Kulkarni

Chasfer · Answer 2 · 2012-07-05T21:39:00

Solution 2

You may have a research on this artilce: Exporting Data to Excel[^]

Posted 5-Jul-12 21:39pm

Chasfer

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 3 · 2012-07-05T21:34:00

Solution 1

Refer this MSDN link[^].
It has accepted answer.

Posted 5-Jul-12 21:34pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)