Stack Overflow
Stack Overflow

Questions tagged [excel-online]

119 questions
0
votes
0 answers

How to add an AzureAD Application in Excel Online shared access

I have an Azure AD application that needs to read data from Excel spreadsheet in onedrive for business. I would like to allow this application to have a read only right on this spreadsheet like a human user has when we use the share button. I would…
JuChom
  • 5,717
  • 5
  • 45
  • 78
0
votes
0 answers

Create a random number when a new Form is submitted

I have created a Microsoft form for Purchase Order Requests, when someone submits the form I would like the table on the excel worksheet to create a purchase order number, I am using a combination of sequential and random numbers to create this…
user3777576
  • 69
  • 9
0
votes
0 answers

Is there a way to automatically send emails to a responders "mentioned" email rather than the logged in email address?

I am working with MS Forms and MS Excel office online. I have used Powerautomate to automatically feed responses into my excel file. Each time a response is filled I want to send an email to the responder to the email address which they provide in…
ftlouie_5
  • 21
  • 2
0
votes
1 answer

Turn cell containing "Serial Number" into a hyperlink to a cell containing that same "Serial Number" in another tab and vice versa

Background Email requests are received. They can be classified into 4: A. P. N.W. S.E. There is a spreadsheet with 5 tables namely, Monitoring, A., P., N.W., S.E. tables. When an email is received, a power automate flow adds the email details as a…
VeeEss
  • 33
  • 5
0
votes
0 answers

Importrange dynamic in Excel Online

How can I reference a cell in Excel online like in Google sheets? In the following example I'm making a reference in A1 to another spreadsheet with provides me the data I'm retrieving, located in A4. Here is an example of what I'm trying to do in…
mau
  • 185
  • 11
0
votes
0 answers

How to save a Worksheet to pdf using excel online scripts

I am trying to save a worksheet as a PDF and then send it to an email. Right now I have a sheet set up for taking form responses and in the same workbook I have a sheet that displays the answers of the form in an organized and readable manner. I…
user3777576
  • 69
  • 9
0
votes
1 answer

ExcelScript - run on cell selection / editing (bind?)

How can I run a piece of code on a cell selection? And how can I run it again, when I start editing the value in the cell? I been going through the documentation, and in no way I can find anything (a specific binding???) to achieve the desired…
MarcinWolny
  • 1,600
  • 2
  • 27
  • 40
0
votes
1 answer

Formula to edit part of a text in one cell based on an values in another cell

I'm looking for an excel based formula for one of my projects which can help in removing certain parts of a cell (Cell A - names separated by a based on the values in Cell B (similar format as Cell A). I'm running a flow on this file as well hence…
Githin Mathew George
  • 1
0
votes
1 answer

Can I copy an ENTIRE Excel sheet and paste to another Excel spreadsheet using Power Automate. (Sharepoint)

I am working from SharePoint. I would like to COPY AN ENTIRE Excel Sheet-A from Spreadsheet A and Paste it into another Sheet, Sheet-B on Spreadsheet B using Microsoft Power Automate. Some important things to note: Sheet-A does not have column…
Koketso M
  • 15
  • 1
  • 8
0
votes
1 answer

How to send email in office 365 using office script excel online

I'm currently creating an office script to send email from excel online(hosted in onedriveforbusiness). The components of the email am extracting from excel cell values. Have done a research and it looks to me that office script has syntax similar…
Bernietechy
  • 186
  • 1
  • 16
0
votes
1 answer

Hiding columns using office scripts

I would like to hide certain columns using office script for Excel Online workbook. I used the recorder to create the script. But when I ran it, it resulted in errors. Below is the recorded script: function main(workbook: ExcelScript.Workbook)…
exceldude2001
  • 141
  • 2
  • 2
  • 13
0
votes
1 answer

How to find out the current group level of a range in excel for web using office-script

I am trying to find out how to identify the current group level of a range in office-script. Based on the documentation I was only able to find the group or ungroup…
Konrad Schäfers
  • 1
0
votes
1 answer

Office Scripts: Code to sum values in one column based on the value in another column in Excel

I am new to TypeScript and my goal today would be to sum up all the cell values in a column in an Excel file, based on the cell values in another column. In my Excel file, I have the calendar weeks, stored in column U and the corresponding values…
Mateusz Woś
  • 333
  • 2
  • 10
0
votes
0 answers

SharePoint and Excel Online Data Connections

I'm experimenting here so please bear with me or offer some direction/starter for ten. We have SharePoint, Excel Online. I had an XLS on my desktop with a data connection out to CSV file to load a table, nothing to special but works a dream when…
Gary Williams
  • 1
  • 2
0
votes
1 answer

How to Add Smartsheet Rows to Excel Table Power Automate

I am currently working on an automation to copy a row to an excel table from Smartsheet, then extract that table data to a SharePoint list (thanks Microsoft :( ). However I'm having an issues filtering my automation to the new row that was added or…
Puno
  • 61
  • 9
1 2 3 4
5
6 7 8