Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Hi Mike,
A few of the listed smart services and functions in the description are deprecated in the plugin. Please update the description with available features and deprecated. Please let me know if I can find documentation for it anywhere.
Hi Everyone,
Is there any way to format the data before importing to DB using Load CSV to Database/Import CSV to Database
One of the column is unknown. Can untell me which smart service u r using
hi all,
has anyone come across the following error when attempting to import. the Smart Service is generating the exception :
???Unknown column '' in 'field list'???We've checked the Excel sheet and it looks to be valid with no hidden characters etc.
Has anyone come across the error :
???Unknown column '' in 'field list'???
We've checked the Excel we're uploading and it matches the DB table correctly.
cry me a river
yes this is a bit ridiculous
Hello Everyone,
is there any DB compatibility issues with 'Import CSV to Database' smart service. I am using oracle and it doesn't seem to be working even after correct configuration.
Anyone also faced same issue, please let me know. TIA!
Hi,
Can we use the function readexcelsheet() to read an excel file with an extension .xlsb ?
Am getting the following error if I try to read the .xlsb file.
Expression evaluation error at function fn!readexcelsheet [line 3]:
Thanks.
Is there any limitations for the number of rows or size of the csv for 'Import CSV to Database'?