Upload Excel file to web server

Question

I was trying to upload a file to a web server through UWP c# using filestream but it always gives me an error i.e 405 method not allowed when I try to upload on http://example.com/httpdocs/content. Even for testing purpose I tried uploading on my localhost but still no luck. Any Help?

Code :

 public async Task<bool> Upload(StorageFile fileName)
    {
        HttpMultipartFormDataContent form = new HttpMultipartFormDataContent();
        cts = new CancellationTokenSource();

        using (IInputStream fileStream = await fileName.OpenSequentialReadAsync())
        {
            HttpStreamContent content = new HttpStreamContent(fileStream);               
            form.Add(content, "premier", fileName.Name);

            using (HttpClient client = new HttpClient())
            {
                using (HttpRequestMessage request = new HttpRequestMessage(HttpMethod.Post, new Uri("http://example.com/httpdocs/content")))
                {
                    request.Content = form;
                    request.Headers.TryAppendWithoutValidation("Content-Type", "application/x-www-form-urlencoded");                       
                    HttpResponseMessage response = await client.SendRequestAsync(request).AsTask(cts.Token);
                    var result = response.Content.ReadAsStringAsync().GetResults();
                }                   
            }
        }

        return true;
    }

Can we see how were you trying to upload a file using `FileStream`? — Alex, Jul 06 '17 at 05:57
Well, first of all why are you trying to upload to that ulr? method not allow is because you cannot make `POST` requests to it — Alex, Jul 06 '17 at 06:07
Because its required actually to save a Excel file to the web server. Cant we upload a file like this? — Rinkesh, Jul 06 '17 at 06:12
we usually use upload controls or add services in web server to upload files. — Lei Yang, Jul 06 '17 at 06:14
@LeiYang upload controls like HttpClient or BackgroundUpload or something ? — Rinkesh, Jul 06 '17 at 06:16
It seems the `http://example.com/httpdocs/content` accepts only `GET` requests. Get a valid route and try uploading to it — Alex, Jul 06 '17 at 06:19
I even tried on localhost. I think that's a valid route. Isn't it? — Rinkesh, Jul 06 '17 at 06:28
[Uploading files to file server using webclient class](https://stackoverflow.com/questions/263518/uploading-files-to-file-server-using-webclient-class) — Lei Yang, Jul 06 '17 at 06:35
@LeiYang, unfortunately your reference din't work for me. But I found this code it worked perfectly for me. Have a look in the answers. — Rinkesh, Jul 12 '17 at 06:54
you're not tring for me, it's for yourself. because i doubt your solution really fits all situations — Lei Yang, Jul 12 '17 at 10:39
Yup It can send up to 5mb Excel file data. I think as per requirement that's enough for me. — Rinkesh, Jul 13 '17 at 12:10

Rinkesh · Accepted Answer · 2017-07-15T06:42:07.443

Hye, after trying much I found this code and it works perfectly. With a little correction that the request will be now sent to an aspx page i.e. http://example.com/abc.aspx. If you wanna send high mb's of excel file data then just change 4096 in Math.Min(4096, (int)fileStream.Length) accordingly

Client Side Code-

   public static async Task<string> UploadFileEx(string uploadfile, string 
   url, string fileFormName, string contenttype, NameValueCollection 
   querystring, CookieContainer cookies)
    {
        try
        {
            if ((fileFormName == null) ||
                (fileFormName.Length == 0))
            {
                fileFormName = "file";
            }

            if ((contenttype == null) ||
                (contenttype.Length == 0))
            {
                contenttype = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            }
            string postdata;
            postdata = "?";
            if (querystring != null)
            {
                foreach (string key in querystring.Keys)
                {
                    postdata += key + "=" + querystring.Get(key) + "&";
                }
            }
            Uri uri = new Uri(url + postdata);


            string boundary = "----------" + DateTime.Now.Ticks.ToString("x");
            HttpWebRequest webrequest = (HttpWebRequest)WebRequest.Create(uri);
            webrequest.CookieContainer = cookies;
            webrequest.ContentType = "multipart/form-data; boundary=" + boundary;
            webrequest.Method = "POST";

            // Build up the post message header
            StringBuilder sb = new StringBuilder();
            sb.Append("--");
            sb.Append(boundary);
            sb.Append("\r\n");
            sb.Append("Content-Disposition: form-data; name=\"");
            sb.Append(fileFormName);
            sb.Append("\"; filename=\"");
            var sd = sb.Append(Path.GetFileName(uploadfile));
            sb.Append("\"");
            sb.Append("\r\n");
            sb.Append("Content-Type: ");
            sb.Append(contenttype);
            sb.Append("\r\n");
            sb.Append("\r\n");

            string postHeader = sb.ToString();
            byte[] postHeaderBytes = Encoding.UTF8.GetBytes(postHeader);

            // Build the trailing boundary string as a byte array
            // ensuring the boundary appears on a line by itself
            byte[] boundaryBytes = Encoding.ASCII.GetBytes("\r\n--" + boundary + "\r\n");

            FileStream fileStream = new FileStream(uploadfile, FileMode.Open, FileAccess.Read);
            long length = postHeaderBytes.Length + fileStream.Length + boundaryBytes.Length;
            //  webrequest.ContentLength = length;
            webrequest.Headers[HttpRequestHeader.ContentLength] = length.ToString();

            //Stream requestStream = webrequest.GetRequestStream();
            Stream requestStream = await webrequest.GetRequestStreamAsync();

            // Write out our post header
            requestStream.Write(postHeaderBytes, 0, postHeaderBytes.Length);

            // Write out the file contents
            byte[] buffer = new Byte[checked((uint)Math.Min(4096, (int)fileStream.Length))];
            int bytesRead = 0;
             while ((bytesRead = fileStream.Read(buffer, 0, buffer.Length)) != 0)
                requestStream.Write(buffer, 0, bytesRead);

            // Write out the trailing boundary
            requestStream.Write(boundaryBytes, 0, boundaryBytes.Length);
            WebResponse response = await webrequest.GetResponseAsync();
            Stream s = response.GetResponseStream();
            StreamReader sr = new StreamReader(s);

            return sr.ReadToEnd();
        }

        catch (Exception e)
        {
            e.ToString();
        }
        return null;
    }

Upload Excel file to web server

1 Answers1