Total effort in hours
10:00
10:00
10:00
10:00
00:00
00:00
10:00
10:00
10:00
10:00
10:00
00:00
Can anyone plz assist me to get the sum of effort hours from excel column.
what would be the syntax, plz assist
Total effort in hours
10:00
10:00
10:00
10:00
00:00
00:00
10:00
10:00
10:00
10:00
10:00
00:00
Can anyone plz assist me to get the sum of effort hours from excel column.
what would be the syntax, plz assist
yes, please
Hi @vidhan.rpa,
Try this and let us know if it works.
dt.AsEnumerable().Sum(Function(row) row.Field(Of Decimal)(“Total effort in hours”))
Total effort in hours - this is your column name
dt- this is your datatable
It is not working, error throwing as specified cast is not valid.
Yaa, Got that let me do some modification in that !
Hello,
can u plz tell assist me on the below.
I have 60 different excel files in a 60 folder and those 60 folder is in another folder. How do I ready each file from them.
@vidhan.rpa - To read all the files with in subfolders , you can code like below.
FilesList = Directory.GetFiles(YourFolderpath," * .xlsx * ", SearchOption.AllDirectories)
Note:Remove the spaces after * and after xlsx * . i am not able to type with that format here…
Then loop through each files and build your process.
It is working fine, can u tell me how do I get the filename and extension from the path. For example: In below path I want only filename as Format_SNR and extenstion .xlsx.
Plz tell me the syntax if u r aware.
“C:\Users\NI6991\Documents\UiPath#Project Documents#\Robert Bosch\Template Attachment Folder\I1234\Format_SNR.xlsx”
for only file name without extension use :
`
Path.GetFileNameWithoutExtension(yourpath)
for only extension use:
`
Path.GetExtension(yourpath)
@vidhan.rpa - As @Shikhar_Tandon mentioned , you can get the filename and the extension using those codes. You have do those inside your for each loop.
Try this:
Hope this helps you figure out your issue or you can get more help at O365CloudExperts.
Regards,
Jerry M.