Skip to main content
Solved

FME 2022.1 - Why is the XLSXW writer so slow?

  • September 6, 2022
  • 3 replies
  • 104 views
speknl
Contributor
Forum|alt.badge.img

I have this workbench in which I combine multiple CSV-files and write out to one Excel-file. the file contains aprox. 190K rows. In the previous FME version (2020.x) I used this workbench it took a few minutes. Now the XLSXW is taking hours to write the output.

 

Did something change in the way the XLSXW writer functions? I did a test by writing to a CSV file, this took seconds to complete, so clearly the problem lies with the Excel writer.

 

Hopefully someone knows about a fix.

 

Cheers,

 

Jaap

Best answer by markatsafe

@speknl​ Please see this question for more details

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

M
Forum|alt.badge.img+2
  • markatsafe
  • Best Answer
  • September 6, 2022

@speknl​ Please see this question for more details

speknl
Contributor
Forum|alt.badge.img
  • speknlContributor
  • Author
  • Contributor
  • September 6, 2022

@speknl​ Please see this question for more details

Thanks for your reply Mark!

I will try the latest beta tomorrow and report back to you.

 

cheers,

 

Jaap

M
Forum|alt.badge.img+2
  • markatsafe
  • September 7, 2022

@speknl​ FME 2022.1.2 (b22627) released today with the Excel performance patch . Thanks for your patience on this regression

Community Stats

32,154
Posts
122,048
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.