How can i export MVC to Excel by using excel Reference ( COM)?

Question

0.00/5 (No votes)

See more:

hi all experts,
I created MVC application to make one report and i want to export all data from my datatable to excel. I try to use 2 ways already to export.
1. using Javascript
2. using Respone.write(....)
but both ways are incorrect because of my item structure is started from 0 ( ex: 00000189361 ).
when i used those way, in item code col in excel will remove all 0 in front of my item (ex 00000189361 will go to 189361 in excel).
I think that if i use Excel Reference, maybe i can format it to Text.

Does anybody know how to export to excel using COM or Excel Reference?

Thanks

TONY

Posted 27-Oct-13 5:06am

soeun tony

Add a Solution

Comments

Pheonyx 27-Oct-13 12:13pm

From what I've been told in the past, using the Excel Interop is bad practice for a web server as it requires excel to be installed on it. There are various tools out there that might help you, try looking at NPOI or EPPlus, they are pretty good at producing formatted Excel documents either XLS or XLSX (depending on the one you choose). If you are exporting values such as 0000000154534 it is advised to wrap quotes around them so that Excel treats them as text rather than numbers.

soeun tony 27-Oct-13 21:26pm

Hi Pheonyx,
As you said "it is advised to wrap quotes around them". I tried to input ' in front of item code and when export, it display '00000189361.
Thanks
TONY

thatraja 28-Oct-13 9:58am

So the issue solved?

soeun tony 28-Oct-13 22:06pm

The issue not yet solved because the item code remove 0 and if i use ', the item code will display this sign ' in front of item code.

thanks

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)