- Incrementing a counter variable while reading or skipping a line using File System Object (FSO).
- Read all the content using FSO-ReadAll method, split it line by line and put into an array.
- Read the content and count no. of lines using RegExp.
But we have one more approach using System.IO.File.ReadAllLines method which is much better and more efficient than the above methods. Let’s see how it is done.
'Storing File path in strFilePath variable
'Creating object for .Net IO File class
'Counting no. of lines using Length after reading all the lines using ReadAllLines method
If we want to count no. of lines from a text file which is having more number of lines, then we can go for the above method. This method is faster since there is no need to loop line by line using FSO or put all the lines in an array to get the count.