Iv created a web application using vb.net 2005. Its working fine and running fine on the server (Microsoft Server 2003). The problem i have is to dowload a file from the same server using vb.net. I tried using this code but it gives me a : "is not a virtual path" error.
I'm working on some code that generates an Excel spreadsheet server-side and then downloads it to the user. I'm using ExcelPackage to generate the file.
The generation is working just fine. I can open the generated files using Excel 2007 with no issues. But, I'm having trouble downloading the file with Response.TransmitFile().
Right now, I have the following code:
//Generate the file using ExcelPackage string fileName = generateExcelFile(dataList, "MyReportData"); Response.AddHeader("content-disposition", "attachment;filename=FileName.xls"); Response.ContentType = "application/vnd.xls" Response.Charset = ""; Response.TransmitFile(fileName);
When Excel 2007 opens the file downloaded as above, it gives the "file format doesn't match extension" warning. After clicking past the warning, Excel displays the raw xml contents of the file. If I change the file extension, like so Response.AddHeader("content-disposition", "attachment;filename=FileName.xlsx"); Excel 2007 gives an "Excel found unreadable content in the file" error, followed by a dialog that offers to locate a converter on the web. If I click "no" on this dialog, Excel is able to load the data.
I've also experimented with different MIME types, like application/vnd.ms-excel and application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, combined with file extensions of .xls and .xlsx. All combinations result in one of the two behaviors mentioned above. What is the correct combination of file extension and MIME type to use in this scenario? What else could cause this failure, other than an improper MIME type or extension? FYI, this is occurring with Visual Studio's built-in development web server. I haven't yet tried this with IIS.
I have a link http://Test/Folder/file1.xls which is working fine But if I typehttp://Test/Folder/file1.xlsx it is not working. It is giving me a file not found error.So when I read online every one is suggesting me to add the correct MIME type at tyhe IIS level. I don't know if that's the correct thing to do.I opened IIS and navigated to folder FOLDER right clicked and selected properties -> HTTP Headers -> MIME Types->New -> Extension -> .Xlsx-> What should i be entering for MIME type?
While exporting the html to Excel using Response.Write() in ASP.NET and when I try to save as the exported file I'm getting the default save as file type 'Web Page *.html, *.htm in excel application. Is there an any fix to get the default save as file type as xls or xlsx?
I am having an issue downloading files that I have store in SQL Server. I have no problem in a WinForm. What am I doing wrong in my code?
I have a window open from another page because I was having an issue doing this while the page was ajaxified. The FileData part of the code is a structure that holds a memorystream and 2 strings and they are returning proper values. The window opens up and then closes almost immediately when the page loads.
I am creating Excel file from code. This code is working fine in my local server. because it is local iis and local VS. When I deployed in the server. I am not able to see (download) excel to client browser. How can we give access to see excel in client browser?
I am trying to download doc file from server and it show download same aspx file instead of document file.my code is working with .net framework 2.0 and IIS 6.0 but its not working with .net 3.5 framework and IIS6.0
I am using asp.net 3.5 with C#. I can able to upload the .doc file in the server but i now want to download the .doc file from the server and show it in a text file.I can able to download the file but it show with a save/open window. I just want to show the contents of the .doc file in a text box..
I am using the code below to enable clients to download a .csv file from my server.
The problem I am having is that when the file is saved to the client computer the file name is prefixed and suffixed with an underscore which leads to a file type of .csv_ which is obviously not a recognised file type.
How can I strip the underscores from the file name at the transmit stage?
Dim FileName As String = LstBox1.SelectedItem.ToString Dim FilePath As String = "~/temp" & FileName Response.Clear() Response.ContentType = "text/csv" Response.AddHeader("Content-Disposition", "attachment; filename=" & FileName & "") Response.TransmitFile(FilePath) Response.End()