hello - can you help me - i'm using aspose cells to open an existing workbook and then stream it to a browser all works fine except when the file opens in excel, the fonts and text are corrupted
HELP
(i'm using version 4.1.2.0 but i have downloaded the latest 4.4 and tied it in that and I get the same problem)
Hi,
Thanks for the template file.
We will check and figure it out soon.
Thank you.
Warren
October 7, 2007, 11:01pm
3
Hi,
Could you post the protected password of the workbook? It will help us to check the problem.
Attached is the protected workbook - the password to unprotect it is 'astra'
Ive tried opening and saving both the protected and unprotected versions and I still get the garbage text when the file is streamed to the browser
Warren
October 8, 2007, 4:02am
5
Hi,
Could you post unprotected file? If i unprotected the file and save the file with Excel ,then open with Aspose.Cells, it will works fine.
This is the code for opening and streaming the file I'm using - It doesnt matter whether I use the protected or unprotected file - i corrupts the file
Dim fstream As FileStream = Nothing
try
primarySheet = path + "/Docs/secondary.xls"
InitLicense() ' checks the license
Dim workbook As New Aspose.Cells.Workbook()
Dim sheet As Aspose.Cells.Worksheet
fstream = New FileStream(primarySheet, FileMode.Open)
workbook.Open(fstream)
sheet = workbook.Worksheets(0)
workbook.Save("secondary.XLS", Aspose.Cells.FileFormatType.Default, Aspose.Cells.SaveType.OpenInExcel, response)
Catch ex As Exception
Throw ex
Finally
If Not fstream Is Nothing Then fstream.Close()
End Try
End Sub
Attached is a screensht of what I get from Excel when it streams
(image file is zipped)