On to my next VB6 conversion which requires the use of Excel spreadsheets. Basically, I'm after which road will give me the best functionality and performance for creating basic spreadsheets for reports that have maybe thousands of rows (but not millions), some minor formatting (font type), titles and charts. I want to make sure I can set a 2D array to a range so I don't have to loop (and maybe all options allow for that).

I'm not worrying about anything prior to 2007 so everything will be XLSX format. Normally I don't need to read any spreadsheets though for my first project that is all I'll be doing.

From what I've been reading here and elsewhere, I get the sense that the Interop is a pain in general (perhaps because of server side issues) so I've seen Open XML SDK or EPPlus, which seems to be a "wrapper" for the SDK to make it much easier to use, highly recommended. Currently, everything will be done at client level but it's certainly possible that I'll have server side in the future.

As much as EPPlus seemed to be regarded elsewhere, I was surprised there were very few posts on it at this site when I Googled so that got me wondering why if it was so good.

Thanks for your advice and direction.