Is there a way to import .xlsm files using custom SharePoint connector?

[Qing Wong]

I am currently only able to import .xlsx and .csv files using the custom SharePoint connector. Is there a way to extend the compatibility to include .xlsm?

[Peter McKinnis]

Qing,

We will investigate whether the Custom SharePoint Connector can support .xlsm files and get back to you. If the macros are needed to produce the data, then that probably will not be supported since Excel files are just opened and read as data files.

Regards,

Peter

[Qing Wong]

Hello Peter,

Macros are not needed to produce data; they simply perform some functions while the sheet is being used.

Thanks,

Qing

[Qing Wong]

Hello Peter,

Has there been any update on investigating connectivity with .xlsm? We are aware that there is another SharePoint connector from EPAM, but they use a legacy authentication protocol which is not ideal.

Thanks,

Qing

[Peter McKinnis]

Qing,

Yes, in initial testing xlsm files work. We need to finish up a couple of other things and then release a new deployment. I will reply in this question when a new release is on the TIBCO Exchange.

Thanks,

Peter

[Qing Wong]

Fantastic news! Please keep me posted for when a new release is available.

Thanks,

Qing

[Peter McKinnis]

Qing,

The updated Custom Connector for Spotfire to read from SharePoint Online files is available on the TIBCO Exchange site. You should be able to read data from your Excel Macro (xlsm) files now.

Thanks,

Peter