Hi guys, I need to reading a *"xls" files in a folder via vb. net. How can i do that ? NOT : I’m not open it just listing in a console → ExcelFolder → abc.xls → ExcelFolder → bbb.xls → ExcelFolder ->ccc.xls Thanks.

Hi @Kuki_Force Please remove for folder in folder. You do not need that. That is what is making the files inside the folder to be looped getFiles = Directory.GetFiles(FolderLocation,"*xls") Console.WriteLine("Number of Files : " + getFiles.Count.ToString) For Each Files As String In getFiles …

Reading "*xls" File in a Folder via vb.net

Help Studio

AkshaySandhu (AkshaySingh Sandhu) December 6, 2022, 8:33am 7

Just modify your code to look something like below
Directory.GetFiles(FolderLocation, "*.xlsx", SearchOption.AllDirectories)

1 Like

Topic		Replies	Views
Read Excel sheet by using Vb.net Studio	19	4403	June 11, 2022
How to read all excel files in a folder Studio studio , question , activities_panel	4	2232	February 2, 2023
Read multiple excel files Studio activities , question	3	861	June 23, 2023
How to read excel files using multiple files in folder Studio studio , question , activities_panel	5	67	September 23, 2024
Best approach (or suggestion) to open multiple excel files from two different folders? Help excel , activities , workflow , studio	5	3295	June 27, 2018

Reading "*xls" File in a Folder via vb.net

Related topics