VB.net Tutorials
71. How to Open and Edit Cells in an Excel 2007 file in VB.NET
By: Issac : 2009-01-31
Description: To open or edit an Excel 2007 worksheet in you have to add Microsoft 12.0 Object Library in your project. From the following pictures to show how to add Excel reference library in your project.
72. To read the entire worksheet in an Excel workbook through VB.net Code
By: Issac : 2009-01-31
Description: In this tutorial we can see how to find the used area in a worksheet and the last data row in Excel. For finding last row we are using WorkSheet.UsedRange. It will return the last cell. The following code opens an Excel file and reads the entire content.
73. Format Excel 2007 Page in VB.NET
By: Issac : 2009-01-31
Description: We can see some common formatting we can do in Excel 2007 page. For that let's enter mark sheet data into a file and format it, Excel sheet we gonna work will look something like this as we see in the following picture.
74. Insert Background Pictures in Excel 2007 from VB.NET
By: Issac : 2009-01-31
Description: This article will enable you to add a background picture in Excel 2007,this can be done by using SetBackgriundPicture method
75. Using Excel 2007 Chart in VB.NET 2005
By: Issac : 2009-01-31
Description: We can create Chart in Excel using VB.NET 2005 . The following section shows how to create a Chart in Excel 2007 through VB.NET source code . Before we crate a Chart , we have to fill data in Excel sheet. After enter data your Excel sheet is look like the following picture.
76. Export Chart from Excel 2007 as Picture file in VB.NET 2005
By: Issac : 2009-01-31
Description: The following program shows how can Export a Chart from Excel 2007 to Picture file like , BMP , JPG , GIF etc .Before we crate a Chart , we have to fill data in Excel sheet. After enter data your Excel sheet is look like the following picture.
77. Using Excel 2007 Chart VB.net Picture Box
By: Issac : 2009-01-31
Description: The following program shows, how to get the Excel chart as an image in Picture Box .Before we crate a Chart, we have to fill data in Excel sheet. After enter data your Excel sheet is look like the following picture.
78. Using Excel 2007 DataBar in VB.net
By: Issac : 2009-01-31
Description: This tutorial helps you to construct a data bar inside an Excel 2007 sheet, here we enter the data of a Mark List and format the page. Finally we need to select the range we want to add DataBar and select the color.
79. Excel 2007 Data Validation Input Message using VB.net
By: Issac : 2009-01-31
Description: To embed message in Excel spread sheet we can use data validation input messages once we select the cell it will display the message, we can use .net to set those data validation input. Let's see the source code for it.
80. Read Data from Excel using OLEDB in VB.NET 2005
By: Issac : 2009-01-31
Description: We can see about OLEDB object which can be used to work with data in cell (i.e. insert, edit, delete, select etc), we can use OleDbConnection, OleDbDataAdapter and dataset for doing these operations in an Excel File, also you have to import system.Data