I’m trying to rewrite some old VBA code to Office Script.
One of the steps is to set data validation on several columns.
With the script I am able to loop all columns of a named table.
So my idea was to use a switch on the column names to set the related data validation.
So far so good – but: all defined rules set in the ForEach loop are somehow not done when calling the setRule() but all columns do have afterwards the last defined rule (here: the one from column name “Lagerstatus”.
Does anyone knows how to solve this problem?
Thanks in advance!
Best regeards,
Pascal

im relativley new to Excel Scripts and i need your help.

In Excel 365 I’m trying to create a sheet which generates a unique ID which doesn’t change, for each row/item in a table.

In Excel 365 I’m trying to create a sheet which generates a unique ID which doesn’t change, for each row/item in a table.

I am really new to Office Scripts.

I am really new to Office Scripts.

It is quite often that when I click Run for an Excel Office Script it will not start executing or delay starting to run for more than a few seconds. The scripts are only about 200 lines.

How to position the labels (years, in this case) at the very bottom of the cart using Excel Office Scripts?

Is there any way to add rich-text formatting within a single cell in a Microsoft Excel Office Script?

I’m not even sure if this is possible but I am trying to write an Office Script to copy the contents of one table and paste it to a new file and save it. The script I’m using I got some help from ChatGPT: