My vb 2008 app uses Excel, but only briefly. Can I avoid referencing the Interop library Microsoft.Office.Interop,Excel?? Is there another way to link to Excel?
In terms of its dealings with Excel, my app does little more than open a workbook and shade some cells.
Using database functionality you can read and write to an excel file without having to automate Excel as long as what you are writing following a consistent table structure. I definitely prefer this method it is very easy and doesnt require the user to even have Excel. However you do lose formatting options such as bolding cells. (ive been trying to find a way for the last month and havent been able to do so.)
