HI All,
I am working on 19.3 and have a requirement where I need to filter data from from the view based on the condition that are provided by user and then have to export it to excel.
The total no of column are 59 hence single node of Write Datastore Entity to excel is getting failed.
I tried using the same smart node twice where first node have selection of first 50 fieldsand starting cell value as "A1" and 2nd node have selection for remaining fields and starting cell as "AY" i.e 51st column.
When I am debugging the process the document obtained has only last node column.
Is there anyway by which we can get all the 59 in columns in one sheet of the excel by using Write "Datastore Entity To Excel Smart Service"
Discussion posts and replies are publicly visible
Have you tried using the Export SQL to Excel Smart Service. Create a SQL View that populates the same data as the CDT and use this service to create the spreadsheet bypassing the CDT.
For what it's worth, last I heard Export SQL to Excel has been officially deprecated from the Excel Tools plug-in, and I expect that anyone who deploys the current version of the plug-in won't even be able to access it.
Hi Mike, It may have. We needed to use it a year ago because of limitations we ran into when exporting the DSE. Haven't looked at it since.
I also use it extensively (in a project that's been using it for years and we just can't ever upgrade the plugin version because of this) - when they originally rolled out the EDSEtE smart service it was promoted as a "replacement" for Export SQL to Excel (as well as Export CDT to Excel), but certain things, especially the inability to use an excel base template file, renders it useless to me.