I have here a line of code which reads a text file and save it to an array, It works well. But I wanna ask if there is anything like this code that can be use to read a excel file? Something like this :
You can't read an Excel file line by line with a simple reader. You can
create an Excel Application object and access it that way or
use ADO or OleDb objects to access the data like a database
Using the first method allows you to access the Excel data on a cell by cell basis. Using the second method allows you to access the data row by row as long as the data is in tabular form (where every row is in the same format).