Stack Overflow
Stack Overflow

Questions tagged [ms-office-script]

28 questions
3
votes
1 answer

assigned a value to characters and perform a mathematical functions (+,-,*,/) of a string (having characters) in MS excel

I want to perform a sum of a given string ('ABCDEF') based on its pre-assigned values. i.e first I want to assign values to each character and then calculate the total value of the string having pre-assigned characters. Is it possible to carryout…
shivam
  • 596
  • 2
  • 9
2
votes
0 answers

How can I mark part of the text in a cell in bold?

With VBA you can mark a part of the text bold like this: Sub Makro1() ActiveCell.FormulaR1C1 = "test test test test test" With ActiveCell.Characters(Start:=1, Length:=6).Font .FontStyle = "Standard" End With With…
Maksim Esau
  • 21
  • 1
1
vote
1 answer

Adding Image from URL to specific Cell using Office script

I am trying to add a QR Code on specific Cell using office script, The following code works fine but, I am not able to figure out how to specify the position(cell G1), I want that QR Code top left corner to start at Cell "G1". async function…
Samundra
  • 19
  • 4
1
vote
0 answers

Create 1 ReturnObject from 2 JSON object arrays with Typescript

I'm trying to create a JSON with an Excel office script, to use this JSON in a Microsoft Power Automate flow to create Item master data . My problem is that I don't get the message header and the Item details into 1 ReturnObject. I'm a beginner in…
Roop
  • 11
  • 1
1
vote
1 answer

Where is the "Settings" for connecting Office Scripts to VS Code Web?

Per, https://learn.microsoft.com/en-us/office/dev/scripts/develop/vscode-for-scripts?source=recommendations#connect-visual-studio-code-to-office-scripts, I should "Under the More options (…) menu, select Editor settings.", but I don't see the…
swv
  • 691
  • 1
  • 12
  • 28
1
vote
0 answers

Excel office script - Delete row (except first 2 columns) after row has been copied to a new tab

I have a script that will move a row to another table if a certain cell within that row is filled. The script then deletes the entire row. I would like for this to continue but instead of deleting the entire row it would be great if it deleted the…
Eti
  • 23
  • 4
1
vote
1 answer

How can I do step by step debugging, or even set break point in Excel 365 Office Scirpt code?

I have enabled Office Script, and I see AUTOMATE tab in my Excel-365. I can write a script and also see results in log and on sheet . But when I see the tab, or the script, I do NOT see any way to take step by step execution, or even set a…
Rahul Mehta
  • 31
  • 3
1
vote
2 answers

Excel online Office-Scripts . Copy Range A1:J10 from worksheet2 and paste it on last row of column A of another sheet

I need some help I can do it in Excel VBA but can't find out how in Excel Online. I have the below example 1 work but it is not dynamic I need it to paste under the last row. If you can help please provide an example or edit the code and resend.…
Carly Adams
  • 13
  • 1
  • 4
1
vote
2 answers

Custom Date format values in array

I want to format dates in a Table column in Excel 365 Web using a custom format. I can format a cell but not the cell value picked up in a variable or array. function main(workbook: ExcelScript.Workbook) { let selectedSheet =…
sifar
  • 1,086
  • 1
  • 17
  • 43
0
votes
0 answers

Invoke Office Script from VBA editor in Excel

Is it possible to invoke Office Script directly from the VBA editor in Excel? Is there an object in Excel that refers to Office Script?
maro
  • 1
  • 1
0
votes
0 answers

How to convert Google App Script to Office Script?

I've been working with something similar to the bellow snipped to import data into Google Sheets via App script. Now I need to do the same for Microsoft Excel Online (365) via Office Script, but I am at a loss as I do not fully understand Office…
Andrei Berianu
  • 23
  • 3
0
votes
1 answer

MS 365 Excel Scripts Error " Range clear: There was an internal error while processing the request."

I am working on a workbook that has several worksheets, I am using the following code to find the formulas on each sheet and convert then to their calculated values. function main(workbook: ExcelScript.Workbook) { // Acc Input { const accInp…
ArielOverboard
  • 3
  • 1
0
votes
0 answers

ExportAsFixedFormat method on Project

I have got the next error when I try to use Subroutine. The error is: My code is: Sub CreatePackages() Dim folderPath As String Dim matrix As Project Dim template As Project Dim templatePath As String Dim selectedMatrix As Variant On Error GoTo…
Damian Brown
  • 1
  • 1
0
votes
1 answer

Format Excel data in a particular case

My data in Excel is I want this data using the formula
SANJOG
  • 31
  • 1
  • 1
  • 6
0
votes
0 answers

Copy data from multiple sheets into single sheet

I'm trying to copy the excel multiple worksheets data into single worksheet using office scripts.can anyone tell how to do it? I tried getting first range of the sheets after loop through the sheets but it's not working. I'm new to this so please…
Rohan Kapoor
  • 1
1
2