Jump to content

Spotfire and Excel

Alexandre Giazzon

Recommended Posts

Hello all, I hope this message finds you well.

Do you know if Spotfire is able to open an Excel file (lets say in a Sharepoint location), open, read all the contents and identify the last row, paste the data and save the file

If yes, can anyone share how the code would be like

Many thanks in advance,


Link to comment
Share on other sites

Hello Alex,

There is a Microsoft SharePoint Online connector that comes with the latests versions of Spotfire. There is no code required for what you are trying to achieve. You can use on-demand parameters to fetch the latest rows and append rows to your data. I use an expression to get anything greater that a specific date or ID or a combination of both to identify the last row and bring anything sequentially or date-wise new data

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...