Topic: Extracting Excel Data

[MP]

Good to hear -- thanks for checking guys -- rather err on the side of caution -- cheers.

[WILL HATCH]

Holly bananas that OLEDB method is fast.

Note: I had to install https://www.microsoft.com/en-us/download/details.aspx?id=13255 - the x64 version did not work - for this method to work for me.

Yeah, it made me squeal a bit when I ran it the first time!

For all the other inputs, thanks and I agree that direct xml would be better. I'm working in a very MS oriented engineering shop and the engineers here love working in Excel. No need for additional installation, it just worked.

[Keith Brown]

For all the other inputs, thanks and I agree that direct xml would be better. I'm working in a very MS oriented engineering shop and the engineers here love working in Excel. No need for additional installation, it just worked.

The gembox solution is an API that you use that does not require excel be installed on the machine so there is no secondary installation needed for your engineers.  It is very fast and easy to learn.

[WILL HATCH]

Thanks Keith, it looks pretty awesome. The licensing is a bit awkward as I pay the same to read a couple large files in one app as I do to bundle it in my app and distribute freely... but I've also  spent more time on this issue in the past than I could buy back for that price 

[WILL HATCH]

So I just received some code today from a colleague that references a library I've never heard of before. I love that it's a nuget package!
https://www.nuget.org/packages/FastExcel/