Jump to content
We've recently updated our Privacy Statement, available here. ×

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


Remi COURTEY

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...