Spotfire and Excel

[Alexandre Giazzon]

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,

Alex

[Jose Leviaguirre]

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