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:
Get Workbook and Sheet Metadata
Hi,
As per the Appian https://docs.appian.com/suite/help/23.1/excel-guidance.html#write-data-to-an-excel-workbook , it inform that we can use this write more than 50 columns in the excel. Any suggestion how it can be achieved?
Requesting follow up on whether issue importing date from an Excel file generated by Google Sheets can be processed by Import Excel to Database smart service.
readexcelsheetpaging() this one works quite well, have not used csv ones yet, hope those works too.
Does this plugin support these fucntions readcsvlogpagingwithheaders() & readexcelsheetpaging() and all the other read related fucntions for CSV files
readexcel() has been deprecated for about 2 years. readexcelsheetpaging() is the replacement and while it is not like for like it has additional functionality for most used cases.
Is the readexcel() function deprecated in this version? We need to read an excel file(xlsx) which has multiple grids in a sheet and both have different structures. Only readexcel() can read it but it is not showing the parameters to be passed.
Agreed with Stefan. Plugin brings a readme that has a detailed usage guide for each function/smart service. If you are looking for something else in particular please let us know.
If you are looking for documentation, just download the plugin. It includes a "readme.pdf".
Hello. I see here a lot of questions with no answers. Isn't there anyone supporting this plug-in? Please could anyone indicate if any documentation or use notes exist? So we don't have to make the crash course to make it work? For sure something can be found in youtube, but it would be better some indications from the official site.
thanks ;)