Quick Tip: How to work with Excel files in VB.Net

8 ביולי 2008

Recently I've being asked by friend to show him a simple way to read/write data from/to MS Excel files. I found my old project with very simple method of working with excel files by using Microsoft.Jet.OLEDB.4.0 Provider (similar to MS Access). This is one of many methods to work with excel files. Read data from Excel Sheet:     ''' <summary>     ''' Reads the data from excel file.     ''' </summary>     ''' <param name="strFilePath">The file path.</param>     ''' <param name="strSheetName">Name of the sheet.</param>     ''' <returns></returns>     Public Function ReadDataFromExcelFile(ByVal...