Download .xls file from a url

Question

I'm trying to download an xls file from a url: http://www.site.com/ff/excel/file.aspx?deven=0

I'm using this code but when the download is complete the file is not properly downloaded. How can I download this file correctly?

string remoteFilename="http://www.site.com/ff/excel/file.aspx?deven=0";
string localFilename = "D:\\1\\1.xls";
Stream remoteStream = null;
Stream localStream = null;
WebResponse response = null;

try
{
    // Create a request for the specified remote file name
    WebRequest request = WebRequest.Create(remoteFilename);
    if (request != null)
    {
        // Send the request to the server and retrieve the
        // WebResponse object 
        response = request.GetResponse();
        response.ContentType = "application/vnd.ms-excel";

        if (response != null)
        {
            // Once the WebResponse object has been retrieved,
            // get the stream object associated with the response's data
            remoteStream = response.GetResponseStream();

            // Create the local file
            localStream = File.Create(localFilename);

            // Allocate a 1k buffer
            byte[] buffer = new byte[1024];
            int bytesRead;

            // Simple do/while loop to read from stream until
            // no bytes are returned
            do
            {
                // Read data (up to 1k) from the stream
                bytesRead = remoteStream.Read(buffer, 0, buffer.Length);

                // Write the data to the local file
                localStream.Write(buffer, 0, bytesRead);

                // Increment total bytes processed

            } while (bytesRead > 0);
        }
    }
}
catch (Exception e)
{
    MessageBox.Show(e.Message);
}
finally
{
    // Close the response and streams objects here 
    // to make sure they're closed even if an exception
    // is thrown at some point
    if (response != null) response.Close();
    if (remoteStream != null) remoteStream.Close();
    if (localStream != null) localStream.Close();
}
MessageBox.Show("file downl");

@agentnega thanks but I posted it without knowing the problem of the OP. It is just how I would do it, not an answer. — L.B, Feb 14 '14 at 22:50

Sam Leach · Answer 1 · 2014-02-14T22:48:48.677

6

Use WebClient, it's much simpler:

using (WebClient webClient = new WebClient())
{
    webClient.DownloadFile(remoteFileName, localFilename);
}

if(File.Exists(localFilename))
    MessageBox.Show("File Downloaded");

edited Feb 14 '14 at 22:48

answered Feb 14 '14 at 22:43

Sam Leach

12,746
9
45
73

score 0 · Answer 2 · answered Feb 14 '14 at 22:42

Try flushing with localStream.Flush() AFTER your do {} while(), you might also want to wrap with a using statement.

For example:

// Create the local file
using (localStream = File.Create(localFilename)) {
    // Allocate a 1k buffer
   byte[] buffer = new byte[1024];
   int bytesRead;

   // Simple do/while loop to read from stream until
   // no bytes are returned
   do {
       // Read data (up to 1k) from the stream
       bytesRead = remoteStream.Read(buffer, 0, buffer.Length);

        // Write the data to the local file
        localStream.Write(buffer, 0, bytesRead);

        // Increment total bytes processed
    } while (bytesRead > 0);

    localStream.Flush();
}

score 0 · Answer 3 · answered Feb 14 '14 at 23:26

This is how I download Excel files using a FilePathResult.

public FilePathResult DownloadFile(int ID)
{
    var log = _db.Logs.FirstOrDefault(x => x.LogID == ID);

    //Download the spreadsheet
    string fileName = string.Format("{0}.xlsx", ID);
    string path = _directory + "\\" + fileName;
    return File(path, "application/vnd.ms-excel", string.Format("{0}.xlsx", log.ReportTitle));
}

Download .xls file from a url

3 Answers3