Overview
Provides several smart services and functions for handling data in Excel and CSV formats.
Key Features & Functionality
Smart Services included are:
Functions included are:
*Version 2.0.0 - 31May18
- Thread-safe implementation of date, datetime and timestamps in the "Export SQL to flat files" and "Import CSV to Database" Smart Services
@Ben Ben Dudley ,I am still facing issues in Export to SQL smart service while exporting the data in multiple sheets.
There are three tabs in my excel. Using three nodes to export each sheet data.in first node , the data is exported successfully and the generated document is passed as input to the second node to overwrite the data in sheet 2 and the output of second node is passed as input to 3rd node. The final document has data in third sheet whereas the data in sheet 1 and sheet 2 were lost.
Can you please advise on this?
Thanks in advance!
Ok I figured it out - CDT field names, as opposed to cell names. However, it seems like it might be good if it could just do columns or rows, too.
Also, if you ever made a similar function that can preserve the "auto fit to row height" setting for cells post-generation, I'd be a fan ;-)
To clarify, the columns I was passing were defined like ={"D", "E", "F"}. The field names I'm trying now are being passed like ={"D2", "E2", "F2"}. The smart service is working as normal except nothing I've tried so far actually preserves the word wrap setting on the indicated field(s).
Ben Dudley - I had seen that, but it doesn't seem to do much by way of explanation. First I tried passing in some column names (since I want whole columns to retain wrap text functionality) and that did nothing. Then I passed in individual cell names (even though it'll be a pain to come up with individual cell names for 150 rows spread across 4 columns, all needing word wrap functionality). This also seems to have done nothing. Any more specific hints?
Hi - this release note may help:
*Version 1.9.5 - 23Apr18
- Added wrap text functionality: New input “wrap_text” provided for “CDT to Excel”- and “SQL to Excel”- Smart Service to define an array of field names to have the wrap text option enabled in the generated excel sheet.
I just downloaded the package to find instructions for Wrap_text in the readme file, but it doesn't seem to be mentioned at all - any help?
Thanks Ben Dudley!!
kishore and chandhinir a new version of the plug-in was just released. Please try downloading as it includes a fix that may help!
*Version 1.9.11 - 29May18
- Re-released as a fix was not transferred into the previous release