Stack Overflow
Stack Overflow

Questions tagged [ms-office-script]

28 questions
0
votes
1 answer

Table column data used as PivotTable filter?

In a worksheet titled 'Config' I have several lists of names in a table with several columns denoting different teams, for the sake of example lets say: Team A Team B Alan Dane Geof Keri This team table will be updated and change with…
LeeB86
  • 1
  • 1
0
votes
1 answer

How do I select an entire column from a range?

I am trying to identify all the cells in a column that have the following and change the font color to red. a space a hyphen an underscore more than 16 characters in a cell This is my code function main(workbook: ExcelScript.Workbook) { // Get…
Swarochisa
  • 3
  • 1
0
votes
1 answer

Adding QR code on my Excel Online using office script and Powerautomate

I am using the following code to insert the QR code on my workbook, while this code work when i run it from office script, I am not able to run this script from Power automate because it looks like power automate does not support using fetch in…
Samundra
  • 19
  • 4
0
votes
1 answer

Office Script -> After filter select visible rows and paste next sheet lastRow concept

I have S1 and S2 sheet; S1 sheet -> S1 has two unique values that I need to filter and copy/paste visible rows to the next sheet, like ABC_1 sheet and ABC_2 S2 sheet -> S2 has the same unique values, I need to filter and paste ABC_1 last…
user21553220
  • 1
  • 1
0
votes
0 answers

update the VBA code and the same in office scripts

I have following code in VBA to achieve this in Excel. there is column with header and values. in some cells there could be multiple values separated by comma,semicolon or pipe. I wany to split such cells and the new values exept the 1st one paste…
Pato
  • 153
  • 6
0
votes
1 answer

Output all cell colors from a range in Excel using Office Scripts

Is there a way of extracting the fill colours from a range of cells into an array quickly and without looping through cells? Something like the code shown below. Am I missing something obvious? let sheet = workbook.getWorksheet('Sheet1') //For cell…
Griatsala
  • 3
  • 2
0
votes
1 answer

Microsoft Office Scripts- moving to a specific cell

For Office Scripts professionals, I can move from Tab1 To Tab2 through the script, but I don’t know how to move to cell A1 when moving to another tab. Any ideas please I try to link a script to a button to move to a specific Cell (Ex:A1) in…
user20624894
  • 1
0
votes
1 answer

Call Word and Compare 2 Word document versions from Excel Office Script

Is it possible to call Word from an Excel Office Script and compare two versions of the same word document?
Diogo Amorim Dev
  • 1
0
votes
1 answer

Set a selection of cells to a certain color by clicking a button

I want to colorize selected fields from user with a Office Script. Is that possible? Robert EDIT: Select a number of cells, depending on which the user chooses Press a Button (Make Cell Green) Colorize the Cells which were selected.
Rob90
  • 1
  • 2
0
votes
1 answer

Office-Scripts: Add Client-Analysts combinations entered as exceptions in a column into another Table

In a Mappings table, I am having an Exceptions column in which some cells contain strings that have multiple custom delimiters viz., Client1~Analyst1*Client2~Analyst2 etc Mappings…
sifar
  • 1,086
  • 1
  • 17
  • 43
0
votes
2 answers

Powershell get spare licenses

I am trying to get the amount of spare licenses available from the Get-MsolAccountSku command. Here's the code (output below) $Licenses = Get-MsolAccountSku $spare = Foreach ($License in $licenses) { ($License.ActiveUnits - $License.ConsumedUnits)…
Jack Brooks
  • 15
  • 6
0
votes
1 answer

Combine Specific columns from several tables using excel office script to one table

A looking for a way to get specific columns by name from several tables. My data comes in several sheets with different number of columns upto 38 columns so i cannot use getColumnById. I only need 7 columns from this. First am converting all sheet…
George Chitechi
  • 25
  • 5
-1
votes
1 answer

Split multivalues in the same column in Office Script

I have following table in Excel. I would like to split the values in the column Product only based on delimiters comma, semicolon or pipe. The code is working but that it splits just multi values in the cells and copies them in the same column with…
Pato
  • 153
  • 6
1
2