Member Avatar for JohnDove

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

  • 4 Contributors
  • 3 Replies
  • 192 Views
  • 3 Months Discussion Span
  • Latest Post Latest Post by gever
Member Avatar for kvprajapati

>Can I avoid referencing the Interop library Microsoft.Office.Interop,Excel?? Is there another way to link to Excel?

ADO.NET and OpenXML.

Member Avatar for TomW

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.)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.