Free Support Forum - aspose.com

Garbage Text in the worksheet

Hi..

I see random garbage text in the worksheets that i create.

I saw the following text in warning worksheet "GarbageText will be added to each worksheet if this excel file is created using a Template." but i dont use templates.

This is how i create the file.

Dim reportexcel As New Excel

Dim ind As Integer = reportexcel.Worksheets.Add()

reportWS = reportexcel.Worksheets(ind)

reportWS.Cells.ImportDataTable(ds.Tables(0), True, "A2")

I am not an excel guy so i might be missing something here..

Thanks

If you call the following methods, garbage text will be injected with evaluation copy:

Excel.Open

Excel.OpenCSV

Excel.CalculateFormula

If you still find garbage text, please check if your data contains garbage data. If not, please post your project here, I will check it.