+8Hi,
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?
+54You can use the SharePointOnlineConnector to download both files, update one from the other an upload it back to SharePoint.
+54that'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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
