Stack Overflow
Stack Overflow

Questions tagged [excel-online]

119 questions
0
votes
1 answer

How to delete a worksheet if it exists and create a new worksheet with the same name with Office Scripts

I have a script that makes a copy of an existing worksheet and generates a table within this new worksheet called Lists. Looking for a way to delete the new worksheet whenever the script runs again, but I keep getting the 'Worksheet activate: The…
nouptime
  • 9,929
  • 5
  • 22
  • 37
0
votes
2 answers

Incorrect scatter chart displayed on Excel online

I try to display a simple scatter chart with the API office.js. For the same code and data, the scatter chart displayed is correct with excel desktop but incorrect with excel online. On excel desktop: On Excel online: The data used are: I…
Sami.S
  • 267
  • 1
  • 13
0
votes
0 answers

VBA getting excel data from a webpage without HTML

I am trying to get copy data from a web link that displays the excel file directly. I cannot right click and select inspect element for the HTML code as the link opens the excel file. (image atachde) Now the task is to copy the data from this file…
Muhammad Mustafa
  • 35
  • 2
  • 14
0
votes
1 answer

How to open an Excel Online document as a PDF

We have an Excel Online file that I'd like to link to, but as a pdf. In other words, I want a link that opens the contents of the Excel Online file as a PDF file. Ideally, admin users would be able to edit the excel file, then end-users would be…
JD136
  • 113
  • 9
0
votes
0 answers

Strange Excel Validator behavior

I meet strange Excel validator behavoir. My goal is to forbid user to enter some special symbols like '*'. so i found a solution based on ROW and INDIRECT. then when i`m trying to test - it woks only after manual access to Data Validation…
Andrew Samokish
  • 19
  • 3
0
votes
3 answers

How to enable new synchronous Excel Javascript API?

This article says a new simplified Office API is in "Preview" mode. Who gets to preview it? When will it come out of Preview (been almost a year)? Will it be available in Excel online? Is a special license required? I'm using the free Excel…
johny why
  • 2,047
  • 7
  • 27
  • 52
0
votes
2 answers

How can I extract bank data and import it into Excel in OneDrive?

I'm currently manually entering data from my bank accounts into a spreadsheet in OneDrive. I would like to be able to automate this process in some way. The two issues I am facing in automating this are: How do I extract transactions from my bank…
opticyclic
  • 7,412
  • 12
  • 81
  • 155
0
votes
2 answers

Excel Online: Add timestamp when cell changes in the same row

I've been searching high and low for a solution to this but I've only found lots of answers for Google Apps instead of Excel Online. Not sure if the Google Apps script can be used in Excel Online, but here goes anyway. What I'm looking for is…
user253529
  • 1
  • 1
0
votes
1 answer

Is there a way to return the "Body" of an Outlook email as a string and not HTML using Office Script?

I want to extend the "Pass data to scripts in an automatically-run Power Automate flow (preview)" tutorial to include the Body parameter of an email. function main( workbook: ExcelScript.Workbook, from: string, dateReceived: string, subject:…
Zach
  • 1
0
votes
0 answers

Embed Excel Display in asp.net core

we would like to simulate an excel worksheet data input in an asp.net core application (windows authentication). Is there a way (for demo pursposes) to embed the Excel (office 365) worksheet in a Asp.Net Core view?
serge
  • 13,940
  • 35
  • 121
  • 205
0
votes
0 answers

Is there a way to convert an Excel VBA to run as an Excel script (Excel online Automate)?

When a cell is selected, I would like to timestamp the row and move it to another sheet? Private Sub Worksheet_Change On Error GoTo Handler If Target.Column = 11 And Target.Value = "COMPLETE" Then Application.EnableEvents = False Target.Offset(0, 2)…
Tom
  • 1
  • 1
0
votes
1 answer

Read parquet file data from azure data lake to Excel stored in SharePoint Online

We have a following requirement to ingest data into an Excel file. Query data from parquet file stored in azure data lake storage gen2 Ingest data into an Excel file Store the Excel file in SharePoint Online What would be the optimal approach to…
Faizal
  • 353
  • 3
  • 16
0
votes
0 answers

Excel Online Erroring out

We have been using Excel Online to get data from an On Premise SQL Server , The files have been opening fine for the last 3 years without any issues until last Thursday as shown below We have not made any changes to the file for the last 3…
Vivek
  • 61
  • 4
  • 16
0
votes
0 answers

Import data to an excel online

What would be the best option to programmatically import large dataset (10 MB) file into an excel online workbook and protect the cells. Dataset file CSV / Parquet format is stored in azure data lake storage. I reviewed the Microsoft Graph API…
Faizal
  • 353
  • 3
  • 16
0
votes
1 answer

vlookup pulling values from other rows

I have a vlookup pulling data from a second sheet and I don't know what I is wrong. the majority of data is getting pulled over correctly, but in a few cases, they are not. I am using two Vlookups - one to pull from the 7th column in the range and…
Andy Latham
  • 41
  • 1
  • 7
1 2 3 4 5 6
7
8