JXLS Parallel Sheet Write Support

[vaibhavk311]

Hey Team, We have use-case where we need to add multiple sheets with each sheet containing 8 lac rows. I wanted to check that can we add Multi sheet Parallel Writing support to optimise performance of the JXLS.

Any help would be appreciated :)

[vaibhavk311]

Adding @SoltauFintel

[SoltauFintel]

What do you mean with "8 lac rows"? How many sheets and rows do you plan? (I ask myself if it's really necessary...)

[vaibhavk311]

@SoltauFintel We are planning for 8 lac rows per sheet. And total sheet at max is close to 20. That's where i was thinking that can writing operation to all sheets be done paralely.

[SoltauFintel]

I still don't understand what you mean with "8 lac rows". Can you describe it in other words?

If you mean 20 sheets with 8 rows - I think a parallel operation is oversized.

[vaibhavk311]

@SoltauFintel Yeah basically 20 sheets with 0.8 million rows in every sheet.

Writing paralely to every sheets will reduce the overall time. How will it become oversized ? Didn’t get that It should give better performance than writing sequentially

[SoltauFintel]

Ok, "8 lac rows" = "800,000 rows". Optimization makes sense for this, of course.

I suggest you fork the repo and develop it there. Please don't submit the PR for the next release. I think it's a too big change for the next release.

[vaibhavk311]

@SoltauFintel Yeah Sure thanks :)

[SoltauFintel]

Closed because nothing more happened here. Please reopen if necessary.