asp.net mvc convert(encode) excel file to base64 string

Question

i need to pick up an excel file form my asp.net mvc project folder and encode it in base64 string.

mine code right now:

 string base64 = String.Empty;
 var pathName = Server.MapPath("~/App_Data/ImportTemplate.xlsx");`
 byte[] docBytes = null;

using (StreamReader strm = new StreamReader(pathName, System.Text.Encoding.UTF8))
        {
            Stream s = strm.BaseStream;
            BinaryReader r = new BinaryReader(s);
            docBytes = r.ReadBytes(Convert.ToInt32(r.BaseStream.Length));
            base64 = Convert.ToBase64String(docBytes);
            r.Close();
            s.Close();
            strm.Close();
        }

so far this doesn't work properly. Any suggestions?

my webservice rejects/decline it, then i convert that base64 string again to byte[] and pass to method. — mat1c, Jun 11 '13 at 21:06
can you post the error detail? What do you mean by "my webservice rejects/decline it" — Maciej, Jun 11 '13 at 21:08
Look into `File.ReadAllBytes(pathName)`. http://msdn.microsoft.com/en-us/library/system.io.file.readallbytes.aspx — Jim Mischel, Jun 12 '13 at 11:50

score 0 · Accepted Answer · edited May 23 '17 at 11:46

Most likely the problem is that your base64 data contains '+' and '/' characters, which are interpreted specially by HTTP. You need to convert that binary to what they call base64 URL encoding, which uses '-' and '_' for those characters. The examples at http://api.adform.com/Services/Documentation/Samples/MediaPlanServiceSamples.htm#ImportMediaPlan indicate that this is the case.

See https://stackoverflow.com/a/17032614/56778 for information on how to do the conversion.

score 0 · Answer 2 · answered Jun 12 '13 at 12:02

Can u try:

 byte[] docBytes = ReadFile(pathName);


 byte[] ReadFile(string sourcePath)
    {
        byte[] data = null;
        FileInfo fileInfo = new FileInfo(sourcePath);
        long numBytes = fileInfo .Length;
        FileStream fileStream = new FileStream(sourcePath, FileMode.Open, FileAccess.Read);
        BinaryReader br = new BinaryReader(fileStream);
        data = br.ReadBytes((int)numBytes);
        fileStream .Close();
        return data;
    }

asp.net mvc convert(encode) excel file to base64 string

2 Answers2