Hi
I have automated downloading an excel report from a website and all goes fine except that .
the name of file is changing daily based on date
I have a template file with name report.xcl
And what i observed is that the workbook sheet should be match the name of the
template file . So i tried to rename the downloaded report with rename activity but it does not work
?Can anyone help
File not exist , please note autmation is working fine all the the day if i make template
file as recent day but when tommorow come
The process is working but without any desired result
Can you show your configuration and the error screenshot please
By default the sheetname will be the file name most of the times for auto downloaded files…so we might need to use rename sheet as well for this
Cheers
Yes you are right , the sheet have the same name of the file . And when you manulaly rename file the sheet name changes also
My problem here is renaming of the downloaded file from wait download activity
?How i can change it
First save it then rename using rename activity…wait for download will give output file
Cheers
Thanks for your support , i solved it by move file activity and change the name in destination .
I have another concern ,
if future report rows increases , is range
?dynamically increases also
