Free Support Forum - aspose.com

How to read CLOB datatype columns into single cell of Excel Worksheet

how to read CLOB datatype columns into single cell of Excel Worksheet.

We are currently using below method to import data into cells.

worksheet.getCells().importResultSet(((DbResultWrapper)data).getResultSet(), startRow,
startColumn, true);

Do we have any other api to import data for preprocessing for Clob?

Note: I do have basic code for reading the clob column from the database.

Hi,


I think you are doing fine, you have to process the CLOB data by yourself as there is not any specific API in the Product for it. In short, for your CLOB data, you must process it by yourself. If the direct resultset from db contains CLOB data, then you have to wrap the resultset before using Aspose.Cells APIs to import data from it.

Thanks,