Excel Tools

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.

Hi, I will update documentation for this method. I verified that it's working correctly as Excel documents start their rows with 1. 

Thank you!
Great to know

I was using the function readexcelsheet() in an expression object.

Hi, can you send me the errors that are thrown by your database. We have hooks in the code to check database type and use proper syntax. I would like to complete the build out to support your database.