Stack Overflow
Stack Overflow

Questions tagged [excel-online]

119 questions
1
vote
0 answers

Excel Web Regional Formats

I want to create a Excel for Web, which changes the currency format according to the regional settings of the logged in user. So, when user Dan with regional settings Germany is logged in he should see € as currency. When Phill is logged in with…
Benjamin Lichtenstein
  • 108
  • 1
  • 10
1
vote
1 answer

TypeScript/Office Scripts - Sum the Values of A Cell Based on The Values of An Another cell

I am recently experimenting with Office Scripts and TypeScript and I have encountered the following problem. I have an Excel file that contains the following data: calendar weeks -> eg. CW1 = calendar week1, CW2 = calendar week 2 etc the values for…
Mateusz Woś
  • 333
  • 2
  • 10
1
vote
0 answers

Data not Refreshing on Excel Online

I have an Excel file on SharePoint with data from an external data source (SQL Server). I want to setup an Office script to automate the refresh of the data and then trigger it via power automate. However, i am unable to get the data refreshed (even…
Dee
  • 199
  • 4
  • 17
1
vote
1 answer

Excel Online Script for Message Boxes

I am working on converting all of my VBA scripts over to Excel Online automation. Has anyone figured out how to convert MsgBox from VBA to Excel Online automation? ex: MsgBox "Some Text" I'm setting my code attached to buttons for users to select.…
Bri
  • 11
  • 2
  • 6
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
1 answer

Incrementing Alphabet Counter for Excel Online in Office Script

Context We have data that is exported from elsewhere that we need to process on a regular basis automatically, but we've no control over how it is exported and it comes out in an unsightly and difficult to use manner. So we automated a script which…
Obahar
  • 107
  • 1
  • 1
  • 10
1
vote
1 answer

Excel Office Script to FillDown

Was wondering if there is a way to write excel office script to fill down values in excel sheet. Similar to what we achieve using 'go to special' in the legacy excel Or if we can convert below VBA to excel office script. Sub FillDown() For each…
George Chitechi
  • 25
  • 5
1
vote
1 answer

Logging to console whenever a cell value exceeds character limit

I have this pseudocode in mind to log an error whenever the length of a cell value within the ItemNumber column exceeds 10 characters. I would also like to display the offending row number as well. Haven't got a chance to test this out fully, but is…
nouptime
  • 9,929
  • 5
  • 22
  • 37
1
vote
1 answer

Excel WEB Addin disappears (crashed) if javascript code in parallel session recreates table

Meet strange problem with Excel addin. Having two parallel sessions in a single file on SharePoint and Addin activated in both: in the first session, the addin recreates (deletes and then adds) the worksheet, then creates a table there and fills it…
Andrew Samokish
  • 19
  • 3
1
vote
2 answers

Call Function via User Interaction with Office Scripts in Excel Online

Is it possible to trigger an Office Scripts function within Excel Online as a result of a user action? For example, can I run a specific Office Scripts function when the user clicks on a hyperlink within Excel Online? If so, can you give an…
Engine Room
  • 53
  • 7
1
vote
1 answer

How to choose preferred date of add-in publication

guys! Currently, I'm working on an investigation of an add-in publishing process. I've not submitted any solutions to the AppSource yet, that is why my question may be silly. So, the question is the next, is it possible to choose a preferred date…
sveta_d
  • 103
  • 6
1
vote
1 answer

Excel Online automatic data fill

I'm working with a file in excel online... I'm not the owner but I want to understand how it works. There are some cells with no formula where data is automatically filled from others sheets when users type text. How is it possible? If I try to…
epi82
  • 497
  • 2
  • 10
  • 21
1
vote
0 answers

Is it possible to share an Excel file online with the autoopen feature (read-only by preference)?

(* I have asked similar questions previously, but I still cannot get it work. I'm re-asking the question to see if there is some updates. *) I could well create an Excel file with the autoopen feature by this approach. The autoopen feature works in…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
1
vote
1 answer

How to ensure that Excel Online request is less than 5MB using Office JavaScript API

Apparently there is a 5MB limit when making requests in Excel Online (see: https://github.com/OfficeDev/office-js-docs-reference/issues/354). We are using the Office JavaScript API to write large amounts of data into an Excel worksheet, using the…
extremeandy
  • 503
  • 3
  • 13
1
vote
0 answers

Is there a way to create a dynamic form that generates questions based on rows in an Excel table?

I have an Excel table that has data added to it periodically. I have a second table that describes the connection between the items in the first table. For the sake of an example: First table with data: and second table with connections. I would…
DNL_MLSTN
  • 11
  • 3
1
2
3 4 5 6 7 8