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.
Many thanks
Jump to Post>Can I avoid referencing the Interop library Microsoft.Office.Interop,Excel?? Is there another way to link to Excel?
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.)
You can use OLEDB for read and write to Excel File
http://vb.net-informations.com/excel-2007/vb.net_excel_oledb.htm
Gever
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.