I have a problem when saving a workbook to a stream in this case using
When converting the memory stream to bytes and writing this to file I get a single line file which can not be read by Excel or even in notepad. I am using version 184.108.40.206 In my case I am doing the conversion on server sending the bytes back over webservice and then converting the bytes to file. Even if I remove the webservice as in the example bellow I get the same problem.
Here is a simple example of what I am doing.
Dim mstream As New System.io.MemoryStream
Dim oBytes(CInt(mstream.Length)) As Byte
mstream.Read(oBytes, 0, oBytes.Length)
Dim fs As New System.IO.FileStream("c:\testcsv", IO.FileMode.CreateNew)
fs.Write(oBytes, 0, oBytes.Length)