Hi
I have a problem when saving a workbook to a stream in this case using
Workbook.save(memorstream, fileformattype.csv)
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 4.1.2.1 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
With mstream
workbooktemp.Save(mstream, FileFormatType.CSV)
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)
fs.Flush()
fs.Close()
End With