Solved

FME 2022.1 - Why is the XLSXW writer so slow?

  • 6 September 2022
  • 3 replies
  • 13 views
speknl
Rank

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

icon

Best answer by markatsafe 6 September 2022, 20:17

View original

3 replies

M
Badge +2

@speknl​ Please see this question for more details

speknl
Rank

@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
Badge +2

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

Reply


Community Stats

28,693
Posts
109,433
Replies
36,544
Members
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.