How to get information from excel if I do not know name of sheet and how many columns

[arivu96 (Arivazhagan A)]

Hi @Aggi,

use the below code to get the download path and store it into string variable(strpath)
Environment.GetFolderPath(Environment.SpecialFolder.UserProfile)+"\Downloads" **or** Environment.ExpandEnvironmentVariables("%USERPROFILE%\Downloads")

strXLFilePath=Directory.GetFiles(folderlocation, “*.xlsx”)(0)

use Excel Application scope to read the sheet. (Refer the below path how to get the sheet names)

How to get the Sheet name from Excel

Dear all: I have a solution for y’all. First, install this package. ExcelActivities.1.0.18.nupkg (9.5 KB) Second: open this xaml and set up the path to an excel workbook with more than one sheet. Readsheetname.xaml (7.7 KB) Please, please comment your findings on this.

Read range Excel sheet index

Hello there, Yes you can. Use excel application scope activity , create output variable from the property called workbook(eg:wb) To see the sheet name just use write line and pass like this wb.GetSheets(0). Then use Read range and in the sheet pass like this wb.GetSheets(0). PS: make sure to use that outside the excel scope(means you need to add one more excel scope and use read range there)

Then use Read Range to get the data from the excel.

Regards,
Arivu