Hello Guys,
I wanna get sheet name of first excel from folder
getting following error
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
i am getting same error
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
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.