I want to Addrows to my datatable thanks to IronPython, with data coming from multiple Excel files

[Remi COURTEY]

Hello community :)

For one of my projectI want to Addrows to my datatable thanks to IronPython, with data coming from multiple Excel files.

Indeed, I have a folder with Excel extracts that are loaded each month with monthly data. I need to upload all this data into Spotfire and I think IronPython is the best way to do it.

My objective is to add the rows of the newfile (each month) to the Spotfire Data Table to be able to visualize them.

Could you help me

Thanks in advance!

 

Rmi COURTEY

[Rayees Wani]

There is no public ExcelDataSource API exposed by Spotfire.

You may want to check below wiki which uses Mocrosoft library Microsoft.Office.Interop to achieve the same:

How to import multiple Excel spreadsheets in TIBCO Spotfire Using IronPython Scripting

https://community.spotfire.com/wiki/how-import-multiple-excel-spreadsheets-...

You can also vote for the below existing idea:

Excel file(xls/xlsx,etc) Import API

https://ideas.tibco.com/ideas/TS-I-5240