Skip to main content
  • EN

Hi! I am currently writing data into an Excel spreadsheet. I have added two feature types that are configured to truncate existing data and overwrite it in the spreadsheet. Now, I need to add another feature type that includes charts and some formulas. These formulas have been set in Excel to sum data from one of the tabs I created in the spreadsheet, and I made a chart based on that data. Is there a way to keep the third tab intact when I overwrite and truncate the data in the first two sheets?

 

Thank you!

I figured out the issue. I had set my first two feature types to "truncate" and "existing," while my third feature type was set to "No" for both truncating and overwriting. However, truncating the first two tabs was causing the third tab to be deleted. To resolve this, I updated the Excel spreadsheet to the latest version, and now it works perfectly. The only remaining issue is that I am unable to pull the chart from the Excel file, as I didn't create this chart in FME Is there a way to extract it?

I was able to figure that one out as well!

This article helped me:

https://support.safe.com/hc/en-us/articles/25407596375309-Using-a-Template-File-when-Writing-Excel-Data

Reply


Community Stats

31,789
Posts
120,751
Replies
39,405
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.