I'm working on setting up a script that reads in an Excel file. I'm merging the spreadsheet with another based on a unique column and the owner doesn't want the formulas in one column to be disturbed. They still want access to view the formula. Is it possible to write to that sheet but still preserve the formula?
@rocky12 Yes you can preserve the formula. On your Excel Reader Parameters, select Read Formulas. Say you have an attribute "Sum", this will add a secondary attribute, Sum.formula. On your writer, ensure you include the Sum.formula & Sum on the writer feature type. This will preserve the formula.
Example workspace (FME 2020): excelformula.fmwt
markatsafe wrote:
@rocky12 Yes you can preserve the formula. On your Excel Reader Parameters, select Read Formulas. Say you have an attribute "Sum", this will add a secondary attribute, Sum.formula. On your writer, ensure you include the Sum.formula & Sum on the writer feature type. This will preserve the formula.
Example workspace (FME 2020): excelformula.fmwt
@markatsafe where do you see read formulas. I'm working with 2019.2, is this compatible?
+25- Influencer
rocky12 wrote:
@markatsafe where do you see read formulas. I'm working with 2019.2, is this compatible?
hi @rocky12, it's in the readers parameters, right under the attributes window:
markatsafe wrote:
@rocky12 Yes you can preserve the formula. On your Excel Reader Parameters, select Read Formulas. Say you have an attribute "Sum", this will add a secondary attribute, Sum.formula. On your writer, ensure you include the Sum.formula & Sum on the writer feature type. This will preserve the formula.
Example workspace (FME 2020): excelformula.fmwt
That works, and that is awesome. Thank you. Now, do you know how to move the formula around? I'm shifting the amount of columns that I have so now it's referencing different cells when it writes out...
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.