I am using the ImportDataTable method to add a DataTable to a worksheet.
If the datatable contains a value who's length is greater then 32K characters I get the error
"You want to put a string longer than 32K to CellQ4"
Is there anyway to have the ImportDataTable method truncate strings greater then 32K so an error is not thrown?
The data is being pulled from an SQL database.