Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Hello!
We are having different issues with the converts one html document to a csv document. We are reviewing the plugging that makes this operation and we fund a mistake in the plugging's source code at ConvertHtmlToCSV.run(). At the insertion of the variable which i responsable for initiating the csv doesn't contain the argument charset, so the special characters of the Spanish alphabet which are included in the html doc, it appears in csv doc like strange characters. We think that the solution to this issue will be changing this sentence:
Are there any plans to support Connected System data sources?
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.