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..