|
What's the best way to interact with Excel using Visual Basic Studio 2010? I've got a bunch of tables that I need to process, each with around 5000 rows and they've all got roughly the same column layout. I want to grab a couple of values from one row, check it against some other external text files, then put a value into a column at the end of that row. Then move onto the next row and do the same. I've looked at LINQ to XML, LINQ to SQL, ADO.net, and the Excel-interop. LINQ seems only good for reading (not writing) and ADO.net seems slow when opening the table.I've only really taken a quick look at this so far, so these first thoughts might be wrong. Any input would be appreciated.
|
# ¿ Jun 18, 2014 23:43 |
|
|
# ¿ May 15, 2024 21:16 |
|
Thanks, I forgot to mention that we are using Express Edition. I've heard VSTO being mentioned on some sites, is this worth the upgrade?
|
# ¿ Jun 19, 2014 01:12 |
|
crashdome posted:... DNP Excel File ... Cheers, thanks crashdome. Looks like we're working with similar types of files. I'll give this a shot. Xarb posted:I have used the EPPlus library to create Excel files from my data: Thanks, I've had a look into this as well.
|
# ¿ Jun 19, 2014 23:19 |