Things You'll Need:
- VB.net
- Excel
-
Step 1
Launch the application that will be using this code to write data to an excel spreadsheet. In order for this code to work Excel has to be installed on the PC where the file is going to be created (which makes sense since why would the user want it if they don't have the means to open it).
-
Step 2
Declare the variables that will be needed in order to make this process happen. eHow does now allow code to be written within the steps so refere to the picture.
-
Step 3
With your variables declared, lets set up the object that will represent the spreadsheet. Again look at the picture associated with this step for the code. The first line of code creates our excel object, the second line, adds a workbook to the excel object and then finally we create a worksheet.
-
Step 4
You can now write data to specific rows and columns just as it looks in the picture associated with this step. The cell values (i.e. "A1", "B1" etc.) can also be variable names assigned to rows and columns. This allows you to dynamically populate those cells.
-
Step 5
Save the file and close the object. Just remember to give your filename variable the path to where you want it saved and of course a name with the ".xls" extension.
