Stack Overflow
Stack Overflow

Questions tagged [excel-online]

119 questions
0
votes
1 answer

Referencing another Workbook in Office Scripts

I have a Workbook that requires it to interact with another workbook. I have the below code which will run fine and get the value of the cell. But I need there to be a function to reference another Workbook. function main(workbook:…
N30C0rt3X
  • 31
  • 7
0
votes
1 answer

Copy data from one workbook to another in Excel Online

I am using Excel Online in the browser, have setup a workbook link to my main file from a source. In my main file I have table headers and additional columns with formula. I just need from A2 to AC down. The issue is that the source file changes…
N30C0rt3X
  • 31
  • 7
0
votes
1 answer

Check if Excel file saved in SharePoint can be edited in full desktop (not locked by user using Excel Online)

Users are working on Excel files in Excel Online saved in a SharePoint library. I need to be able to refresh some of the data in the files in full desktop Excel so need to know if anyone is in the file preventing me from opening the file in full…
Chris
  • 43
  • 1
  • 4
  • 13
0
votes
2 answers

Trigger Ribbon menu in Excel online using Typescript

I am trying to trigger a 3rd party Addin for Excel 365 online using a simple Typescript code written in the Scripts Automate window. function main(workbook: ExcelScript.Workbook) { // Your code here let element : HTMLElement =…
sifar
  • 1,086
  • 1
  • 17
  • 43
0
votes
0 answers

I have an excel online file(business) and my company is hp. I want a way to download the excel file to my PC using python

I tried using the below code but it is giving me 403 FORBIDDEN as the response import time import urllib.request import pandas as pd import requests import json def share_point_login(): print('called') site=" url of the excel file" …
akash
  • 1
  • 2
0
votes
2 answers

Office script "failed to load [code] [library]" error

I have a class that should keep the excel table's values as a property. If I put getValues() inside the class constructor, the script fails with failed to load [code] [library] error (full message from editor console output). function main(wkb:…
Tomasz Golos
  • 1
0
votes
1 answer

Highlight dates closer than 3 months away

I have a simple spreadsheet listing certificates and expiry dates. Before we moved this to sharepoint online we had a macro than on opening the spreadsheet would check dates in a range of cells and highlight those within three months. It was…
CurrySoup
  • 17
  • 7
0
votes
1 answer

excel online and confused in conditional formatting

I am using excel online and confused in conditional formatting that it has just few colors for formatting. I have tried to find online to use different colors for formatting but could not find any article.
user16978245
0
votes
1 answer

Excel Office Script : iterate through a 2D array and use setValues to write the data

I currenty use Excel Office Script to get a response from Jotform API. In my Json response, on the first level of my Array, I get some informations like "Submission ID" and "timestamp from Submission", then I have a Key "Answers" with all the…
user13746257
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
0
votes
1 answer

How to read an object within an object in OfficeScript - interfaces and setValues()

I'm currently learning Excel Office Script through API requests. Granted I'm not a programmer. Here, something I do very easily in Jquery is giving me headaches in Excel Office Script. I cannot seem to be able to structure objects correctly in order…
user13746257
0
votes
1 answer

Telling Azure SQL Database to pull data from Excel Online Document?

Good morning! I've found TONS of articles, questions, and guides on how to import data from local excel documents to Azure SQL databases, or how to pull from an Azure database to Excel, but nothing about how I could use SQL to query an excel online…
GCale
  • 1
  • 1
0
votes
0 answers

MS Flow Excel Business Delete Row Error 409

I have built an Excel File on Sharepoint that technicians enter data into. Now I am trying to use Power Automate to move old records (rows) to an Archive sheet. I can get the data to copy over to the other sheet just fine but when the flow gets to…
Bri
  • 11
  • 2
  • 6
0
votes
1 answer

How to copy Excel cells for matched value to other workseets?

I'm trying to build a way to track issued access cards. Our access cards are (4) digits in length. I'd like to track the status of the card "Issued, Faulty, Lost, Returned" as well as the date of the status change. Ideally, when someone updates the…
Mike
  • 3
  • 2
0
votes
2 answers

Filling an Array with more than 8 values filles everything with the 9. ( Office Script / Excel Online )

this question relates to Office Script which uses TypeScript and I don't know if its an issues of my none existant coding skills or the Office Skript System. Basically pushing 8 variables to an array works, if I add a 9. the array get's overwritten…
Christoph D.
  • 1
  • 1
1 2 3 4 5
6
7 8