Skip to main content
Solved

FME 2022.1 - Why is the XLSXW writer so slow?

  • 6 September 2022
  • 3 replies
  • 51 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

View original

Forum|alt.badge.img+2

@speknl​ Please see this question for more details


speknl
Contributor
Forum|alt.badge.img
  • Contributor
  • September 6, 2022
markatsafe wrote:

@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


Forum|alt.badge.img+2

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


Reply


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