Creation of Excel file with dynamic file name

[Shashi_T ($h@$h!)]

Continuing the discussion from Create new excel (dynamic name) for web scraped information for each seperate web account:

Hi,

I get error while open the file after creation with dynamic File name as mentioned in relevant topic at the end.

kindly suggest any solution.

Regards,
ST

[nimin (nimzz)]

Hi @Shashi_T ,

Could you please share the filename part you specified in the workflow?

Warm regards,
Nimin

[Rahul_Pasupuleti]

You can save EXCELSHEET dynamically by:

Sheetname+datetime.now(“hh_mm_ss_dd_MM_yyyy”).toString

[Shashi_T ($h@$h!)]

Hi,

In this way m generating the filename,creation of file is working fine without nay error but after creation while opening its giving error which i have posted already.
If i dont use customize name of the FileName and pass directly TestCaseDetailsMaster.xlsx then it open without error.

[nimin (nimzz)]

Hi @Shashi_T,

Your file name formatting looks fine. Please add a ‘delay’ activity with a duration of 3 or 5 seconds after the ‘write range’ inside the loop and try it.

Warm regards,
Nimin

[aman_sheik]

@Shashi_T

Can you please use workbook activites. Hope it will works

Thankq
Aman sheik

[Shashi_T ($h@$h!)]

YUP…I was using Workbook activity earlier, It was not working. Now i replace it through Excel Scope activity and Write Range of it …now issue has been resolved but if PC doesnt installed MS office then it will be prob with Excel scope activity.

Ideally it should work with workbook too.

Regards,
$T.

[sathwikreddy (Chinthala Sathwik Reddy)]

Hi,
Can u please try by directly giving the below instruction in the excel scope instead of passing it through a variable
“Data\OUTPUT\TestCaseDetailsMaster_”+GetOutputFileCount.Tostring+“.xslx”

comment the assign activities and please make sure the variable which use “GetOutputfileCount” is Globalized.

It worked in my case.

[Shashi_T ($h@$h!)]

yes tried, its working under “Excel Application Scope” but not with workbook.

Thanks

[sathwikreddy (Chinthala Sathwik Reddy)]

Hi,
as far as i know there are two write range activities in the list. use the workbook write range used for workbook instead of using the write range which is used for excel. check the below picture. use the activity under workbook.

Mark this as solution if u think this is the solution.

Regards.