Duplicate Keys Item when use SXSSF

[Warkanlock]

Hey guys,

I've using XSSF mode like for 6 months but now my Excel file increase a lot of its size so I switch to Streaming Mode but I've been seeing a lot of weird issues related to "Cannot save item with duplicate Key".

Error comes exactly from the Dictionary object (C# exception actually), but why this does not implement the same structure as XSSF?

[tonyqus]

I think this is a bug of SXSSF. How many rows and columns do you have in your current Excel file in average?

[Warkanlock]

So far more than 10000 keys, I see the code I think it's a bug from the Dictionary structure. I'll clon the project and check If I can think something.

Thanks Tony

[tonyqus]

Looks your company is using NPOI. Can you contribue your use case to #705 ?

[Warkanlock]

Looks your company is using NPOI. Can you contribue your use case to #705 ?

I'm not working at PwC anymore 😭

[wjl1627]

I solved this bug by directly changing the source code in version 2.5.1. add code " if (!numberFormats.ContainsKey(formatId))"

cause: