Unanswered

Office script for multiple worksheets

(0) Share

Report

Posted on by msimmonds

I am new to office scripting so I may be a little off base but here goes:

As with so many, I need to create tables in Excel workbooks that are received via email. The added challenge is that the workbooks may have one to six worksheets and I need to create a table in all worksheets present. The one thing working in our favor is that there are only 6 sheet names for the users to select from. For the sake of simplicity lets say the sheet names are red, blue, green, yellow, black and white. One workbook may contain the worksheets red and white, while another workbook may contain all 6 and another only contain green.

The Microsoft documentation seems to be saying that using a variable for the sheet names in scripting. But the only options I have seen for selecting a sheet are to select the first sheet or the active sheet.

I need some way to select each sheet that is present. Does anyone have a solution that will do this?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Yutao Huang Microsoft Employee on at

Like (0)

Report
Do you need to do exactly the same thing on every worksheet present in that workbook?

If yes, something like this may help:
function main(workbook: ExcelScript.Workbook) { workbook.getWorksheets().forEach(sheet => { // Do stuff to the sheet }); }

But if you need to do different things on different sheets, you may need to do something like this:
function main(workbook: ExcelScript.Workbook) { let redSheet = workbook.getWorksheet("red"); // Do stuff on redSheet let blueSheet = workbook.getWorksheet("blue"); // Do stuff on blueSheet let greenSheet = workbook.getWorksheet("green"); // Do stuff on greenSheet // ... }

2 people found this reply helpful.

Was this reply helpful? Yes No
FeierCiprian 20 on at

Like (0)

Report

This Office script will help you convert all sheets into table once you run it from Power Automate

Was this reply helpful? Yes No