Hi all,
I want to export CLOB data to excel and I tried with the following approaches:
Approach 1:
I am currently using the Export datastore entity to excel in which I need to export 50+ columns in the same sheet(eg:Sheet1) but getting error message as "Unable to export. Maximum number of columns exceeded: 50 (APNX-1-4505-038)".
So I tried splitting the 25 columns in 1st Export DSE to Excel smart service node and then pass the output of 1st smart service node to the 2nd Export DSE to Excel node to update the same sheet.But the first 25 columns data were wiped off and the last 25 columns were exported in the excel.
Also, Can let me know how many rows can be exported using Export DSE to Excel?
Approach 2:
Tried using Export SQL to Excel but this plugin does not support CLOB datatype.So I am unable to export the CLOB data.
Any suggestions would be helpful.
Thanks in advance!
Discussion posts and replies are publicly visible
There are two versions of it. I see below in the plugin document. The first one is deprecated but the other one will be there. Are you refering to exceltools plugin (com.appiancorp.ps.exceltools-2.0.2)?
<smart-service name="Export CDT To Excel (Deprecated)" key="ExportCdtToExcel" class="com.appiancorp.ps.exceltools.smartservice.export.ExportCdtToExcel" />
<smart-service name="Export CDT To Excel" key="ExportCdtToExcelv2" class="com.appiancorp.ps.exceltools.smartservice.export.ExportCdtToExcelv2" />