How to create excel files dynamically?

Help Studio
, , , ,
1

Hi everyone,

May I ask, how can I create an excel file (workbook) dynamically without the need of creating a static excel file from application.

I am trying to filter out a set of data and then create an excel file dynamically and write the data that is filter into the new excel file that is being created.

image

2

name excel file as filename-now.tostring(dd-MM-yyyy)+“-”+now.hour+“-”+now.minute+“-”+now.second

3

@Hey_hi You are doing the right way. Just give test.xlsx in the write range. It will automatically create an excel file with the same name

OR

If you want to create the file with the current date and time then in the Write Range activity instead of test you can give below exp

Now.ToString("MMMM dd yyyy HH_mm_ss") & ".xlsx"
1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.