i need to make a simple program that loops though a list of excel files and copy/past 1 row to a master excel sheet.
i see that i have several options to create excel objects:
* using a connectionstring OLEDB
* use Excel Reference (Microsoft.Office.Interop.Excel)
What's the best way to do this? i want the option that is less dependent on the excel version of the end user (so it should work on both Excel 2007 and Excel 2010). And i don't want to install extra drivers like a OLEDB connector.
I have Excel 2010 installed on my laptop, endusers have Excel 2003 or Excel 2007