I’m have Table with COLUMN1 dataType NTEXT (SQL 2008)
After save value with Rich format then export to CELL. Apose not show correct
Example image attach
Hi,
How do you import from SQL Server 2008 table to Excel sheet, do you use Cells.ImportDataTable() method (of Aspose.Cells for .NET component)? Well, Aspose.Cells imports data of text data type as string from a column (in the datatable) e.g with ntext data type, it will not parse the rich formatting scripts of SQL 2008. I think when you import that column (of the datatable) to Excel manually (using MS Excel), MS Excel will not parse it either. You may check it for confirmation.
You got to manually apply rich formatting to the cells/range in the column accordingly by using Aspose.Cells APIs after you have filled the data into the sheet, see the documents / articles for your reference:
etc.
Thank you.