The client had the following scenario – renaming a large number of sheets. The obvious choice was to use Excel. So we needed two Graphs, one for writing to Excel, one for reading back.
Writing to Excel was pretty straightforward:
Note the Archi-Lab Get Built In Parameter node – this ensures that we are language independent
The result is a spreadsheet with 5 columns – Element Id, original Sheet Number, original Sheet Name, new Sheet Number and new Sheet Name. The last two can be changed to new values.
Now lets change some sheet names and numbers
Reading from Excel was a bit tricky
Here we have to use the Set Builtin Parameter method provided by Archi-Lab; Set Parameter by Name would not work for Sheet Numbers.
And the result…