Problem of downloading excel file

[Stefan_Lam88]

Guys, I have a problem here.

String FileName = "FileName.xlsx";
                 String FilePath = input.PostedFile.FileName;
                 System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
                 //response.ClearContent();
                 //response.Clear();
                 response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                 response.AddHeader("Content-Disposition", "attachment; filename=" + FileName );
                 //response.Flush();
                 response.End();

I want to download an excel file which is converted from csv plain text file. But everytime I download, I m unable to download excel and open although the download dialogbox is .xlsx. Any suggestion?

[jfarrugia]

what is the error?

[jfarrugia]

try change content type to:

Response.ContentType = "application/vnd.ms-excel";

however I'd still want to know the error its giving you

[Stefan_Lam88]

Thanks for reply guys. An error is occured while I try to open .xlsx file. It stated unable to Excel cannot open the filename.xlsx because the file format is invalid or extension....

While I try to open explicitly using notepad...I found that the content is html code..
Logically the .xlsx content should be some kind of words are unreadable...but it seems I download the html page code rather than excel file itself...any opinions?

[jfarrugia]

hm... change the content type as i explained. Also, if you open the original file you are meant to download, does it work?

take a look at this method (in case you are exporting from database to excel to download)

export to excel - asp.net

[Stefan_Lam88]

Hi, jfarrugia.

The method u gv me are works..but not the result I wanted.Becoz my excel file now is contain those html button and design on my page rather than excel file data.

My data it seems cant be loaded. When I try my logic in window form. it works as I desire...any extra info?

[mono_jit23]

what is the version of Dot Net Framework you are working with ?????
framework 2.0 doesn't support .xlsx format

[Stefan_Lam88]

hi mono_jit23,

I m using 4.0 dot net framework..

[jfarrugia]

Have you tried changing the content type as i explained? change to application/vnd.ms-excel

And also, have you tried opening FileName.xlsx directly on the server?

[Stefan_Lam88]

Hi jfarrugia,

thanks for your reply. I did follow your method. and my excel downloaded is showing all render html code..like screen shot of my page rather than my uploaded 1.

server?I m using localhost now...not yet deploy

[jfarrugia]

ok but when you double click on the file, does it open alright?

also, im using a similar app with the below:

Response.ContentType = "application/ms-excel"
Response.AddHeader("Content-Disposition", "inline;filename=" & PageName & ".xlsx")

and it seems to work OK.

[Stefan_Lam88]

Yea I did double click. I can open but the content is not what I uploaded..

The content is like screen shot of my page..
content that I have uploaded in csv format is unable to display successfully

[jfarrugia]

oh so its an upload you need not a download.. correct?

[jfarrugia]

I thought you need a download function.. if its an upload.. try:

http://msdn.microsoft.com/en-us/library/aa479405.aspx

[Stefan_Lam88]

I need download.sorry if i m misunderstanding..

I browse a file from computer and download it

[Stefan_Lam88]

String FilePath = input.PostedFile.FileName;

Hi I notice something. I seems not didnt use any code I have declared in this line.
Do you where I should put?

[Stefan_Lam88]

Sorry Typo. I didnt use*

[jfarrugia]

Thats just a property of the file name.. can you follow the link i sent you:

http://msdn.microsoft.com/en-us/library/aa479405.aspx

It seems pretty straightforward using the fileupload control

[jfarrugia]

Very few code required:

Control in html:
<asp:FileUpload ID="FileUpload1" runat="server" /><br />
<br />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click"
Text="Upload File" />&nbsp;<br />
<br />

Codebehind:

FileUpload1.SaveAs("C:\\Uploads\\" +
FileUpload1.FileName);

[Stefan_Lam88]

I have tried your method...with some code changing..but still unable to get .xlsx...only save in .csv..as my originally filetype is .csv

input.SaveAs("C:\\" + excelApp.ActiveWorkbook+".xlsx");

[Stefan_Lam88]

But i m able to open it successfully...just the extension filetype is csv..
I wish to get .xlsx..is that possible?

[jfarrugia]

hm.. then you need a conversion and not just a simple upload.. try

http://www.codeproject.com/KB/aspnet/ExportClassLibrary.aspx

[jfarrugia]

when uploading, you need to maintain the original file type, you can not simply change file type and expect the result to be as you expected, unless its a text based file type.

[Stefan_Lam88]

if my upload file type is csv and download file type wish to be .xlsx or .xls..so it is considered simple or advance?

[jfarrugia]

its not a matter of being simple or complicated.. but you cannot just change content type and expect the conversion to happen automatically. The latest link i sent covers the conversion from excel to csv... im sure you can manage to change some of that code to change conversion from csv to excel.

[Stefan_Lam88]

Hi jfarrugia,

I still have the problem of downloading..in fact. I m downloading the webpage not the attachment...I google search a lot..but still the same thing happen..aiks

[Stefan_Lam88]

Guys, is there any opinion with my case?i m stucked for a few days d..hope some 1 could guide me..

My downloaded file still is html page...
I wish to get my data in excel but not html code..

thanks in advance