Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Does anyone know what the most up to date version of excel tools is? Or is there only one version of excel tools? I see above that it is compatible with Appian version 17.1 and above.
Does "Import Excel to Database" support .xls ?
We are facing issue when uploading XLS file making the node to fail. There is no issue with uploading XLSX files though.
ERROR:
"The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF)"
Hi Dmitry,
Cant create dynamic view. Could you please elaborate ootb ss.
Are you building a query dynamically in such a way that you cannot create a view with that query? If you can create a view, then you can create a DSE against the view and use the OOTB SS.
Thanks April!!
I will try.
Hi musthafaj0003 - have you tried the SQL to Excel plug-in?
Export Datastore Entity to Excel smart services export data from single entity, but i need to export data from query.
Hi, we now provide smart services called "Export Datastore Entity to Excel" and "Export Datastore Entity to CSV"
I am having issue with this function excelreadcellsbynumber() Attaching Sample code here:
excelreadcellsbynumber( excelDoc: todocument(618022), sheetNumbers:{1}, columnNumbers:{1,2}, rowNumbers:{1,2})
And it is giving me "Expression evaluation error at function 'excelreadcellsbynumber':" Has anyone faced this problem, Please let me know.Thank you.
Could you please provide detailed steps to configure "import Excel to Database"