Getting error while passing first excel file

Hello Guys,
I wanna get sheet name of first excel from folder

getting following error

1 Like

hi
you were almost done @smita.mobifly
–Change the type of dir variable to string and try once
Cheers

as we have used Take(1) at last of get file method the output will be a string
–so kindly change the type of dir variable to string and pass that as input to the excel application scope
–hope that would work for sure
Cheers @smita.mobifly

@smita.mobifly

i am getting same error

1 Like

Hi @smita.mobifly

Use str =directory.getfiles(inputffilepath)
For each item in wb.getsheets create a work book variables

Print the sheet names

Thanks
Ashwin.S

Is the variable type changed
May I know what was the error now
Kindly share the screenshot pls

Cheers @smita.mobifly

i have multiple files into one folder and wanted sheet name of on of the file, all files are same

1 Like

Fine,
Kindly try with this @smita.mobifly
out_folderpath = Directory.GetFiles(yourfolder_path,"*.xlsx").OrderByDescending(Function(d) New FileInfo(d).CreationTime).ToList(0)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.