Click here to Skip to main content
15,904,935 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
I want to use excel sheets with vb.net
Posted
Comments
Sandeep Mewara 20-Apr-11 10:14am    
No effort.

As you are very vauge about what you are after doing have a look at this Automate Excel[^]
 
Share this answer
 
Excel Connectivity in VB.NET[^] may help you get started.
 
Share this answer
 
Assuming that you will be creating an Add-in for your application.
Import the following:
VB
Imports xl = Microsoft.Office.Interop.Excel

Dim xlApp as xl.Application;
xlApp = Globals.ThisAddin.Application                 'Get the application object 
Dim workbook As xl.WorkBook = xlApp.ActiveWorkbook    'Get the active workbook object
Dim worksheet As xl.WorkSheet = workbook.ActiveSheet  'Get the active worksheet object

Now you can use the properties of your worksheet in the way you want.

However if you want to open a simple workbook, then you can simply do this :

Process.Start("excel")
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900