What is fast way to add 300 sheets with data to Excel?

Help
, ,
1

Currently I’m using Excel Application Scope which is unchecked AutoSave and unchecked Visible, and using Save Workbook as the first picture below.

  • Estimated execution time is 10 minutes.
  • Adding new sheet is slower as the sheets increase.

Add 300 sheets to Excel (1)
Add 300 sheets to Excel (1)2559×1360 217 KB

Add 300 sheets to Excel (2)
Add 300 sheets to Excel (2)2560×1360 177 KB

My computer information
My computer information1431×659 35.9 KB

AddSheet00001.zip (124.0 KB)

2

Have you tried the system wrtie range instead of excel application scope?

That is all completed back end rather than front end, so may be quicker.

1 Like
3

@TimK, thank you very much. Estimated execution time is 2.47 minutes.

Add 300 sheets to Excel (3)
Add 300 sheets to Excel (3)2559×1360 240 KB

Add 300 sheets to Excel (4)
Add 300 sheets to Excel (4)2538×372 27.3 KB

1 Like
4

No Problem :slight_smile: a lot better than 10 minutes :rocket:

1 Like
5

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