Free Support Forum - aspose.com

Garbage text in cells

Garbage text in cells.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I recently installed the latest version of Aspose.Excel v3.2.4.0 to fix this problem and others but garbage text is still inserted in each worksheet.

This morning I found the article http://www.aspose.com/Wiki/default.aspx/Aspose.Excel/GarbageTextInWorksheet.html and proceeded to download my license again but the problem persist.

The original version of Aspose.Excel I was using when we purchased this component last April did not have this problem.

Is this a license issue or else?

Garbage text gets inserted in worksheets after simply opening a workbook and saving it back to disk.

Hi Christian,

Yes. I think this is a license issue. Is there an extra license sheet in your generated file?

Please check http://www.aspose.com/Wiki/default.aspx/Aspose.Excel/LicensingComponent.html for how to license the component.

Laurence,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

There is no extras license sheet created such as the one I had when using the demo.

I just realized my mistake by wanting to create a simple procedure to demonstrate the problem.

The code below will reproduce the problem and insert garbage text

Sub TestAsposeExcel()

Dim Excel1 As Excel = New Excel

Excel1.Open("New Microsoft Excel Worksheet.xls")

Dim license As License = New License

license.SetLicense("Aspose.Excel.lic")

Excel1.Save("New Microsoft Excel Worksheet.xls", FileFormatType.Excel2003)

End Sub

While writing this procedure I realized my error.

Calling the Open method after the SetLicense fixed the problem.

Sub TestAsposeExcel()

Dim Excel1 As Excel = New Excel

Dim license As License = New License

license.SetLicense("Aspose.Excel.lic")

Excel1.Open("New Microsoft Excel Worksheet.xls")

Excel1.Save("New Microsoft Excel Worksheet.xls", FileFormatType.Excel2003)

End Sub


Thank you for your quick response.

Yes. The SetLicense method should be called at the start of program.