- About us
- Services
- Skills
- Web Development
- ColdFusion Development
- SharePoint Development
- Classic ASP Development
- ASP.NET Development
- Modern ASP .Net Development
- DotNetNuke Development
- Java/JSP/servlets Development
- Python Development
- PHP Development
- Perl Development
- Ruby on Rails (RoR) Development
- Lasso Development
- Real Basic Development
- Google API Integration Services
- Mobile Development
- Database & Client server Development
- Plug-in Development
- Reports/BI Development
- Automated Testing
- QA/Testing Skills
- Domain-based Testing
- E-Commerce Development
- CMS Development
- Desktop Development
- RIA Development
- App-based development
- Salesforce Development
- SugarCRM Development
- Dynamics GP GreatPlains development
- Dynamics SL Solomon development
- Microsoft Dynamics CRM Consulting Development
- Dynamics RMS development
- LiveCycle development
- QuickBooks development
- Drupal development
- Joomla development
- Typo3 development
- Magento development
- Dolphin social development
- Others
- Web Development
- Industries
- Knowledge
- Process
- Models
- Clients
- Career
| |
Software Technology Tips
The following code lines are useful to create an Excel sheet from a CSV file in VB.Net.
We need to pass the complete folder path and csv file name as two parameters. In the code I have given "NewExcelFile.xls" as the file name for new file to be created. This code will generate an NewExcelFile.xls file inside the given path with all records from csv file. To use Microsoft.Office.Interop.Excel namespace we need to add reference of Microsoft Excel 12.0 Object Library. |
Vb.Net Code:
Imports Excel = Microsoft.Office.Interop.Excel
Public Sub CreateExcelFromCsvFile(ByVal strFolderPath As String, ByVal strFileName As String)
Dim newFileName As String = "NewExcelFile.xls"
Dim oExcelFile As Object ' Open Excel application object
Try oExcelFile = GetObject(, "Excel.Application") Catch oExcelFile = CreateObject("Excel.Application") End Try oExcelFile.Visible = False
oExcelFile.Workbooks.Open(strFolderPath + "\" + strFileName)
' Turn off message box so that we do not get any messages
oExcelFile.DisplayAlerts = False ' Save the file as XLS file
oExcelFile.ActiveWorkbook.SaveAs(Filename:=strFolderPath + "\" + newFileName, FileFormat:=Excel.XlFileFormat.xlExcel5, CreateBackup:=False) ' Close the workbook
oExcelFile.ActiveWorkbook.Close(SaveChanges:=False) ' Turn the messages back on
oExcelFile.DisplayAlerts = True ' Quit from Excel
oExcelFile.Quit() ' Kill the variable
oExcelFile = Nothing End Sub |
Related Tags:
VB.NET, CSV, Excel
Author: Shibani Shubhadarshini
VB.NET
- Creating an Excel sheet from a CSV file in VB.Net
- Execute files with [Run as Administrator] option from code
- HTML to PDF conversion using iTextsharp
- GET POSTAL CODE BY USING GOOGLE GEOCODE MAPS API IN VB.NET
- How to check if MS Word is installed in the machine or not in VB.Net
- VB.Net code to uninstall any application
- Simulate keyboard press events programmatically in VB.Net
- Opening a word document in multiple versions of Word(.NET Windows Application)
- Adding a folder browser control to Set up project
- Adding an e-mail to Microsoft Outlook outbox using VB.Net
- .Net - Produce Special effects when loading or closing windows
- Check if SQL express is installed on target machine
- Open MS WORD or MS EXCEL document and set focus in Vista
- How to Generate a Report Header at Runtime when Printing/Exporting a Control using DevExpress XtraPrinting Library in VB.NET
- DateTime Picker Cell in DataGridView
- Showing messagebox as the topmost dialog
- Using FileSystemWatcher class in VB.Net
- Working with mail merge word document using VB.NET
- Importing data from a CSV file into a column with multiple commas
- To create a list of fonts (combo box with all the font names installed in the system) we can use InstalledFontCollection which represents the fonts installed on the system.
- More Related Tips
