Skip to main content
Question

quick question about excel writer settings

  • February 17, 2025
  • 2 replies
  • 41 views

fme_can_do_it
Enthusiast
Forum|alt.badge.img+9

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!

2 replies

fme_can_do_it
Enthusiast
Forum|alt.badge.img+9
  • Author
  • Enthusiast
  • February 17, 2025

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?


fme_can_do_it
Enthusiast
Forum|alt.badge.img+9
  • Author
  • Enthusiast
  • February 17, 2025

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings