This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

WPF MVVM. how to create Excel sheet

Question
0

Sign in to vote
I should export query data into an Excel file. I know I can use Microsoft.Interop.Excel package, but I read in WPF forum it may be too slow for big sized data.
Is there some more performing tool I can use? thanks
- Moved by Alex-KSGZ Thursday, February 6, 2020 5:37 AM
Friday, January 10, 2020 8:52 AM

All replies

0

Sign in to vote

There 3rd party libraries you can look at that are free and not free.

Sunday, January 12, 2020 1:17 AM
0

Sign in to vote

I would use NPOI or Open XML SDK or ExcelPackage. Make sure you create an XLSX if you have lots of records.

https://github.com/tonyqus/npoi/

https://docs.microsoft.com/en-us/office/open-xml/open-xml-sdk

https://www.nuget.org/packages/ExcelPackage

Sunday, January 12, 2020 7:08 AM