Hi,
I have a spreadsheet in sharepoint where one of the sheets needs to be updated weekly, from another sheet that is in another file in sharepoint.
I tried using the sharepoint connector but it makes me lose cell color, formulas and other formatting.
The ideal would be just to delete a sheet inside a sharepoint file and insert a new sheet, without harming the other sheets.
How can FME help me with this?
You can use the SharePointOnlineConnector to download both files, update one from the other an upload it back to SharePoint.
that's great, but cell cores, formatting and formulas are lost when I do this.
that's great, but cell cores, formatting and formulas are lost when I do this.
I think, if you update the excel file (overwrite = no) instead of rewrite it, you can keep the original stuff, but it is hard to say / reproduce without data. But it can be hard, yes.