Author Topic: Extracting Excel Data  (Read 985 times)

0 Members and 1 Guest are viewing this topic.

MP

  • Seagull
  • Posts: 17206
Re: Extracting Excel Data
« Reply #15 on: April 05, 2018, 02:33:28 PM »
Good to hear -- thanks for checking guys -- rather err on the side of caution -- cheers.
\|// Set goal. Experiment tirelessly until
|Oo| practice has become expertise.  Loop.
|- | LinkedIn | Dropbox | About

WILL HATCH

  • Bull Frog
  • Posts: 447
Re: Extracting Excel Data
« Reply #16 on: April 05, 2018, 10:12:16 PM »
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

  • Swamp Rat
  • Posts: 593
Re: Extracting Excel Data
« Reply #17 on: April 09, 2018, 02:31:19 PM »
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.
Keith Brown | AutoCAD MEP Blog | RSS Feed
AutoCAD MEP 2014 / Revit MEP 2014 / EastCoast CAD/CAM addon / Visual Studio 2013

WILL HATCH

  • Bull Frog
  • Posts: 447
Re: Extracting Excel Data
« Reply #18 on: April 09, 2018, 03:06:43 PM »
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  :uglystupid2:

WILL HATCH

  • Bull Frog
  • Posts: 447
Re: Extracting Excel Data
« Reply #19 on: April 12, 2018, 06:22:26 PM »
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/