+9Hi,
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?
+60You can use the SharePointOnlineConnector to download both files, update one from the other an upload it back to SharePoint.
+9that's great, but cell cores, formatting and formulas are lost when I do this.
+60that'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.
