Excel file upload and download in asp.net

Question

0.00/5 (No votes)

See more:

I am uploading an excel file (xls or xlsx format) and converting it into bytestream and storing it in oracle in BLOB field.

Upload code:

VB

If Path.GetExtension(fupDocuments.FileName) = ".xls" Then
                            contentType = "application/vnd.ms-excel"
                        ElseIf Path.GetExtension(fupDocuments.FileName) = ".xlsx" Then
                            contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
                        End If

At the time of download, download completed successfully. But file gets corrupted. Following is the download code:

VB

Response.ContentType = "Application/ms-excel"
                    Response.AddHeader("content-disposition", "attachment; filename=WYCFIS_Excel_Template.xls")

Please suggest. I do not want to add a column for content type in database.

Posted 20-May-13 0:49am

meenalkk

Add a Solution

Comments

navin ks 20-May-13 6:52am

instead addheader use appendheader

Mahesh Bailwal 20-May-13 7:19am

are you using Response.BinaryWrite for downloading?
Can you also share whole code for downloading.

meenalkk 20-May-13 7:20am

Yes. I am using Response.BinaryWrite. Sorry, I cannot share the whole code. It is under NDA.

Mahesh Bailwal 20-May-13 7:32am

can you please save this file instead downloading to your local machine and than open it,just make sure that file is uploaded correct.

meenalkk 20-May-13 7:38am

It gives Open/Save options to the user.

Mahesh Bailwal 20-May-13 7:46am

before writing any code for download please do Response.Clear() and once done with your Response.BinaryWrite do Response.End(). Please let me know if you are already doing so.

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)