複数のシートを個々にファイル作成する。:Create multiple files individually

1つのexcelファイルで複数のシートがあります。
複数のシートに名前をつけ1シートに対して1ファイルの作成を考えています。

複数のシート名の取得はできましたがうまくファイルに出力できません。
xmalファイルは最後のexcel出力でどうすべきなのか悩んでいます。
教えていただきたく思います。
VBAでは多々ありますが、uipathで実現したく考えています。

There are multiple sheets in one excel file.
We are giving names to multiple sheets and thinking of creating one file for one sheet.

Although we were able to retrieve more than one sheet name, we can not output it to the file well.
The xmal file is worrying about what to do with the last excel output.
I would like to tell you.
Although there are many in VBA, I’d like to realize it with uipath.file_from_allSheet.xaml (9.9 KB)
test2.xlsx (8.9 KB)

@matrix99999 Check attached file

file_from_allSheet_updated.xaml (10.5 KB)

2 Likes

Dear sir.
Thank you very much.
I am studying because I am a beginner.
It is the second month, including “UIPATH”.
Every day is fumbling.

1 Like

Please still let me know because I am short of studying.
It is about excel file used in “Excel application scope”.
I thought excel file used was effective only during “Excel application scope”.
After passing “Excel application scope”, we thought that the corresponding excel file was automatically saved and finished.
What should I do when controlling it?

@matrix99999 Can you elaborate more what exactly you need

I’m sorry for the poor explanation.
“Uipath” will exit with the excel file used first. (test2.xlsx)
I would like to know how to close this excel file.
I am sorry to have trouble.

@matrix99999 follow this link How to use Close Workbook? - #2 by acaciomelo

I’m sorry.
What is described in close workbook?
Specifying a file name results in an error.
Could you tell me.close

@matrix99999 Use myWb that you created in excel application scope

close

1 Like

Dear sir.
Thank you very much.
It went well!

1 Like