Stack Overflow
Stack Overflow

Questions tagged [excel-online]

119 questions
0
votes
1 answer

Excel Online Office Scripts: "namedRanges.findAsync is not a function" error when running script via Microsoft Flow

I have a script that consolidates data in the online version of Excel. The script works perfectly when run directly within Excel Online. However, when the same script is executed using Microsoft Flow, I encounter the following error: We were unable…
Dejan Dozet
  • 948
  • 10
  • 26
0
votes
1 answer

Conditional Formatting not applying to all the cells in a given range

I have an issue in Excel online where my conditional formatting is not applied to the given cell range. I have tried using absolute cell ranges as well, but for some reason excel online keeps overriding them back to relative values.
k9yosh
  • 858
  • 1
  • 11
  • 31
0
votes
1 answer

Excel Online Script - How to Reference another file

I am trying to reference another file from my blank script file. I just want to use the script to clear filters using this method via power automate. I do not want power query or other methods. The typescript here will only look the current opened…
Jonnyboi
  • 505
  • 5
  • 19
0
votes
0 answers

Typescript code help to evaluate column H (EffDate) cell value not equal to today's date minus 1 day, true delete row in Excel sheet

I want to delete all rows that don't meet the condition date.now() -1 day. I have multiple date columns but only want to evaluate column H (Column #7). I tried using various code examples but could not get any of them to work.
GIWI
  • 1
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
0 answers

Using Excel add-in in Excel Online, but only for dedicated documents

We need an Office JavaScript API-based Excel add-in, that should be available only within the company, and the usage should be limited only to a few dedicated documents in Excel Online. We have created a prototype of the add-in, published the…
pholpar
  • 1,725
  • 2
  • 14
  • 23
0
votes
0 answers

How can i access content type properties of an excel workbook in ExcelScript?

I have this little script in VBA to fill fields with content type properties assigend on SharePoint. Function SHAREPOINTPROPERTY(sPropertyName As String) As String SHAREPOINTPROPERTY =…
Benedikt
  • 41
  • 4
0
votes
1 answer

How to deal with large data set?

In normal operation, I need to download the dataset from my company database and compute it in excel. I would like to automate it by using ExcelOnline and follow this link:…
mike yau
  • 1
  • 1
0
votes
1 answer

Office script does not process all data

I have created an office script (cannot use VBA, because it has to work in Excel online), which transforms data and converts it to table. However, it only works only if I have no more that 4 rows of data, if there are more rows the rest does not get…
Lukas Nickus
  • 21
  • 3
0
votes
1 answer

Copying or Updating Data from One Excel sheet to Another, Both online on SharePoint

hope you have a nice day/evening ahead, I'm very much noob and wanted to get around this. Have two Excel Files: (A) and (B) on a SharePoint. The excel file (B) (A tracker) is updated everyday has one sheet only. I need the update to reflect on…
DotaBowl
  • 1
0
votes
1 answer

Copy and Paste Rows to another worksheet based on a cells value

Summary: I have a tab called "Working List", in column AI is a Yes/No/Blank field. Once a day (may use a button, may create a power automate flow, not sure yet), we want to run a script that moves the "Yes" rows to another sheet called "Completed"…
Jess
  • 1
0
votes
0 answers

Force pasting as plain text in Excel?

I have a workbook that multiple people access and I want to avoid people screwing up the formatting by pasting in text of all different sizes and formats. Is there a way to force text to paste as plain text? Or, can I force all text to format to…
mxavery
  • 1
  • 3
0
votes
0 answers

How to make Excel Online/2016 sheet have variable Connected sheet?

So, I'm trying to make an Excel sheet (we'll call this Problem Workbook) that is connected and pulls data from another Excel workbook in a SharePoint online folder. That sheet I'm referencing is a workbook spit out by Forms. I need to aggregate that…
mxavery
  • 1
  • 3
0
votes
0 answers

Excel Online Cannot Match Multiple References At A Time

I am trying to use INDEX MATCH with 2 matches across two different sheets however multivariable matching only works on Excel Desktop and not Excel Online. I need this to work on the online version because of the auto-sync with a Microsoft form. I…
RobnGG
  • 1
0
votes
1 answer

Showstopping bug in Excel Online that breaks all add-ins

Also submitted here: https://github.com/OfficeDev/office-js/issues/2940 Starting October 31st, 2022 (Halloween Special): Any Excel spreadsheet open in Excel Online gets stripped of settings saved in it before. This renders useless all plug-ins that…
taralex
  • 935
  • 2
  • 12
  • 29
1 2 3
4
5 6 7 8