Excel Use Case: I am running the bot at 8 AM, Pulling the data from the web and exporting the data to excel.
Now, I will run the bot for every one hour and exporting the data from the web, but I don’t know the exact bandwidth (or) Size of the data.
By the End of the day, In the excel the data for each and every should be exported to the sheet, without overwriting the existing data.
Unable to built the code , for the above scenario. Please Suggest.
Thanks in Advance,
Harsha.
First check if the target file exists…if yes then use append range else use write range so that the file is automatically created when not there and gets updated when available
Hope this helps
Cheers
Hi @Harsha_S1 ,
You would need to First Check if the excel file where you are writing the data already exists. It means the data is already there and it has executed once. Then you would need to use Append Range Activity instead of Write Range Activity since the data would get appended to the existing data in the excel.
Although, there are many scenarios that we would need to understand, but in an overview this would be the case for implementation.
Hi, Thanks for ur response!!
By using the Append Range, how can we implement it in real-time. Please Explain.
Hi Anil, Thanks for ur response!!
By using the Append Range, how can we implement it in real-time. Please Explain.
Does Append Range won’t overwrite the existing data?
Append range does not over write the data…
If you use append range automatically the last row is calculated and the data is appended to the already existing data
For write rnage you have to provide atleast start cell but for append range you need jot provide it is auto calculated depending on number of roes already filled
Cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.