I am developing a VB.Net application that runs on a server which opens and reads data from Excel files into a SQL Server table.
I cannot use the COM Excel interop approach as the customer will not allow me to install Excel on the server and, as I understand it, the Excel.Application() class is part of a COM component that is only available after Excel has been installed.
I understand that VSTO allows the developer to create VS solutions that access Office applications without having to install Microsoft Office on the target server. However, I have never used VSTO and do not know where to start.
Could someone provide me with the code for a VB.Net application that simply opens an Excel spreadsheet using VSTO and displays the contents of cell A1 : "Hello World".
URGENT
Start Free Trial
