Now i need to insert my extracted strings from the pdf into those heards at the right place, so my branch string would go to the first one then so on. How can i perfrom it ?
Yes keep it after the for each loop and no need to loop it again. Once all iterations done then it will come to Excel application scope and here use Write range activity to write into excel file and provide that output dataTable.
Think i am doing something wrong here. Ok so i have first one sequence with build data table
Here i have added the columns and output dt
Next i have a for each loop that goes through all of my folders then another for each going through each file and extracting data ( this works perfect )
then at the end of the for each loop i have the add data row with dt as Datatable and with those variables in the array row
outside of for each loop at the very end i have the excel app scope with write range
in workbook path i have stored a variable with my folder path as string
then in datatable the DT
Starting cell ββ
and sheetname sheet1
Its still not working so i have done something wrong