Excel Tools

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?

Hi Dmitry,

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"

Hi,

Is "Export SQL data to Excel" Smart service deprecated? 

Please let me if any alternative available for this smart service.