Stack Overflow
Stack Overflow

Questions tagged [excel-online]

119 questions
4
votes
1 answer

Corrupted workbook created, when trying to create one using ms-graph APIs

I am trying to create a new Workbook inside my OneDrive, using the following API call : HTTP request: POST https://graph.microsoft.com/v1.0/me/drive/root:/:/children Content-Type: application/json { "name": "NewBook.xlsx", "file": { }, …
taurus05
  • 2,491
  • 15
  • 28
3
votes
1 answer

Excel Online connection to Azure Analysis Services?

Is it possible to connect to Azure Analysis Services from Excel Online? I can't find any option to do it, like in the offline version (Data -> Get Data). If I create a file in Excel desktop version and open it online there is a Refresh button shown…
saso
  • 754
  • 7
  • 18
3
votes
1 answer

Excel online custom URL parameters

Im trying to create custom URL links that will enable a user to be navigated to a specific cell value on an Excel online sheet hosted in Sharepoint online. In my quest to find the answer i have across this parameter that enables you to choose the…
ItsMeSpirrederman
  • 31
  • 1
3
votes
1 answer

Office.js Excel Online Failed to load resource: functions.json

I developed an Excel Add-in using JavaScript API (office.js). Then, I'm using an Asp.Net MVC at the server-side. This works fine on excel desktop, but custom functions don't work in Excel on the web. When I inspect the task pane it shows these…
DeSanterra
  • 81
  • 1
  • 1
  • 8
3
votes
2 answers

Copy Excel OneDrive table to an specific cell on another Excel OneDrive table (Power Automate)

I need to copy data from one excel worksheet and paste (values only) on another worksheet using power automate + Office script I started to creat a flow using the answer in the link bellow. Power Automate: Copy Excel OneDrive table to the bottom of…
Thaís Ferreira Araújo
  • 33
  • 6
3
votes
2 answers

Embedded SharePoint Online Excel file doesn't display horizontal scrollbar

Desired Behaviour Embed an Excel document that is hosted on SharePoint online into an HTML page. Actual Behaviour The embed loads, however there is no horizontal scrollbar. The only way to get to the data to the right of the view port is to click on…
user1063287
  • 10,265
  • 25
  • 122
  • 218
2
votes
1 answer

Edit many sheets in same time - Excel online No VBA or Power automate or else

My team had to move to Office365 and we cannot use anymore our former MS Excel with his VBA or our former G Sheets with his Scripts. I already redo the workbook. Basically, it has many exactly same sheets. The only difference between the sheets is…
Manuel Pelletier
  • 33
  • 3
2
votes
1 answer

Why is pasting data in an excel range using office.js taking too long?

We are working on an excel workbook(~ 13 MBs in size) having 15 sheets. We are pasting data on a single sheet and all the other sheets have a moderate amount of formulas linked to this data dump sheet. We need to paste approx. 10,000 rows and 30…
Muskan Jain
  • 21
  • 1
2
votes
1 answer

= text() formula only working when I press enter

I'm working in excel online. I already checked calculation issues. And for some reason the following formula only works when I go to the cell and hit enter: =text(A1;"mmm-yy") Expected output : Jan-21 Actual output: Jan-yy If I go to the cell and…
erosero
  • 21
  • 2
2
votes
2 answers

How to handle event on data change in excel sheet to refresh all pivot tables?

I have a VBA code applied to Worksheet and its change. So whenever there is new entry or deletion (any change) in the sheet, it refresh all the pivot tables attached to it - Private Sub Worksheet_Change(ByVal Target As…
Shaikh Naushad
  • 53
  • 1
  • 9
2
votes
0 answers

Cannot share an autoopen-tagged document in read-only mode

I have an Excel file in my OneDrive, I want to create a URL link such that: 1) when my colleagues open the URL in a browser, it could open the file in Excel Online in the read-only mode, 2) and the task-pane of Script Lab is auto-opened. I have…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
2
votes
3 answers

Anyway to obtain cell Precedents and Dependents in Excel Javascript API?

Unlike the desktop Excel APIs, which contain a "Precedents" and a "Dependents" on the Range object, the short answer is no for the Excel Javascript APIs, which brings me here. Is there a way or third-party piece of code to circumvent this huge…
BuZz
  • 16,318
  • 31
  • 86
  • 141
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

Failed to fetch in Excel Office Web Script

I'm getting a Line 15: Failed to fetch error without further details. This is my script in Excel Web. async function main(workbook: ExcelScript.Workbook) { let sheet = workbook.getActiveWorksheet(); const company:string =…
Kay B
  • 11
  • 2
1
vote
2 answers

Get workbook url from office scripts api

Hopefully a rather simple one but I cannot work out how to get the URL or full path (fullname) for the workbook. The workbook is https://example.sharepoint.com/sites/abc/x/y/z/file.xlsx How do I get this path out of office script api
mfaiz
  • 475
  • 1
  • 7
  • 17
1
2 3 4 5 6 7 8