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

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.

AddSheet00001.zip (124.0 KB)

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

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

1 Like

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

1 Like

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