I understand that this is an Excel limitation. Can Aspose add a feature to automatically truncate strings greater then 32K characters when adding from a datatable?
The DataTable is created from a SELECT statement on a database table.
Right now the only alternative would be for developers to iterate over each row and column in the data table, check the strings length, truncate if necessary and assign the value to a cell. I’m assuming your ImportDataTable method is many times faster then doing this in our code.
You could also just modify the database query to provide truncated results to the Cells API. Not as clean, but it’s cleaner than iterating the rows yourself.