Hello. If the Excel file name is ex, is there a way to make it ex1 next step?
Please check if this code is correctly written?
Hi @22222222asas ,
You can copy file with name +1
then use that file in next step
Regards,
LNV
@22222222asas
[Get the files in the folder
Files=Directory.GetFiles(“FolderPath”,“.xlsx”)]This is exceptional
Use wild Cards Like *, ? in the place of counter
Please provide screenshot with explanation for clearer understanding!
Please provide screenshot with explanation for clearer understanding!
Hi,
you can choose overwrite if folder have file same name
1 Like
Give the folder path to a variable and pass as the string variable.
Use the for each file in folder and pass the folder path so that it iterates through the files in that specific folder and also you can use the filter optin and mention "*.xlsx and by giving that you can pick only the excel files.
Within that current file in folder please do the actions you required.
Hope it helps!!
1 Like
Thank you very much.
but sorry… I think I need to change the question
If the Excel file name is ex, is there a way to make it new ex1 next time?
ex)
ex next file → ex1 new next file ->ex2 next new file
Please check if this code is correctly written?
If xlsx files are present in the single folder use the below approach
Arr_ofXlsx=Directory.GetFiles(“C:\Users\rlgandu\Downloads\File placeholder”,“.xlsx”)
In the highlighted section perform your actions
1 Like
Here I have uploaded the xaml for your reference.
sample.xaml (191.6 KB)
Hope it helps!!
Thank you, too!
I have another question, can I ask you?
With Data Scraping, pdf page 1 is saved as Excel, but page 2 is not saved and only Excel works May I know why?
Even though you are using the extract the data table for 2nd page it’s still getting extracted the data from page 1 only? Is that your query? Please correct if I’m wrong.
Regards
1 Like
That’s right! But it doesn’t even generate Excel.
Please check the rows extracted for the 2nd page by printing the below syntax in a message box.
Datatablevariable.Rows.Count
And let me know the output of the message box
Regards
Can you please share the syntax in the excel application scope. and also the process sequence.
regards
1 Like
I’m so sorry I’m late.
No log history left… Could you explain the screenshot?
You can use the “Extract Structured Data” activity on the first page to extract data from a PDF table and save it to a data table. Then, utilize the “Excel Application Scope” activity to save the extracted data to an Excel file.
Repeat these steps for each page of the PDF
ashokkarale
renosh.sunny
A_Learner
Teo_Hui_Qian
adi.mehare
donghai
erkanceylan