Stack Overflow
Stack Overflow

Questions tagged [excel-online]

119 questions
0
votes
2 answers

MS Excel vlookup a cell, get row, get the rightmost column from that row

Similar question seems to be this. However in my case I need an additional step (I think). What I can't get done is combine these two steps. Let's say the data structure is as below Col A | Col B | Col C | Col D | Col E | Row 1 Val1 |…
user2058413
  • 691
  • 3
  • 10
  • 28
0
votes
0 answers

Convert Excel file to csv via R without having Microsoft excel on my computer?

I'm using R packages that require input files, but I don't have Microsoft Excel on my computer. Is there a way I can add an input file through Microsoft online or turn a read-only Excel file into a usable csv file?
Sophie Wulfing
  • 1
  • 1
0
votes
1 answer

Excel is unfilling calculated cells at random

I have an Excel file on SharePoint. Multiple people edit said file. Offline and online. Excel unfills all calculated cells (VLOOKUP and MATCH) that depend on other sheets in the same workbook at random. So if you would open or reload that file,…
LineLineLine
  • 9
  • 1
0
votes
2 answers

Logic app expression for path to File not working

I tried to find documentation in the subject but fell short until now. I am trying to use Logic Apps in order to update a table when a trigger occurs. Adding some context: In many separate excel online file that are located in different area of…
RenauV
  • 363
  • 2
  • 11
0
votes
1 answer

Share an Excel file online with an autoopen add-in

I have an Excel file in my OneDrive. When editing the file, I often use an add-in from Microsoft AppSource that I submitted. Now, I want to share this Excel file by a URL link, such that other users click on the link, open the file on Excel Online…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
0
votes
1 answer

How do I create auto combine URLs in Excel when i input the text?

URLs Sample A:https://stackoverflow.com/questions/ask?a="" B:https://stackoverflow.com/questions/ask?b="" C:https://stackoverflow.com/questions/ask?c="" A B C 1 AA10002143 BBANZIEC CC123415 2 AA21001234 BBCSKAUD …
scala.quest
  • 29
  • 1
  • 6
0
votes
1 answer

Bulk update of contacts with related records

I have a requirement to perform a bulk update on Contacts using Excel Online, but there is a set of entities with a N:N relationship to Contacts that need to be filled in order to facilitate data input. As it's impossible to edit this kind of…
felipe.zkn
  • 2,012
  • 7
  • 31
  • 63
0
votes
2 answers

WOPI - Excel documents do not switch to edit mode when clicking on "Edit in Browser" button

I have a WOPI service which returns in its CheckFileInfo all required data including: "UserCanWrite": true, "EditModePostMessage": true, "UserCanNotWriteRelative": true, "HostEditUrl": "domain.com/Home/Detail/fileId?action=edit", "HostViewUrl":…
Baron Ntambwe
  • 11
  • 1
  • 5
0
votes
1 answer

Excel Javascript API - setSelectedDataAsync with R1C1 formulas in Online Excel

I have to use the setSelectedDataAsync method to insert data to a sheet coming from an API. There is quite a bit of data (1000 lines by 100 cols). In this data there are also formulas, coming in R1C1 format. This works perfectly in my desktop…
Rafael
  • 31
  • 4
0
votes
1 answer

Asp.net session: Iframe inception

Bit of a wild question, probably sounds like a design issue, but given the scenario, is the following possible? A parent window on domain xxxx.com opens a new page with an iframe in it accessing domain yyyy.com, which itself contains an iframe to…
MattS
  • 1
  • 1
-1
votes
1 answer

Split multivalues in the same column in Office Script

I have following table in Excel. I would like to split the values in the column Product only based on delimiters comma, semicolon or pipe. The code is working but that it splits just multi values in the cells and copies them in the same column with…
Pato
  • 153
  • 6
-1
votes
1 answer

Excel Web browser

I am trying to group data from dates to quarter in excel with pivot table . But while working in excel on web . I cannot find any Grouping option. Plz tell me how to solve it. Also Combo charts are unavailaible. I mean line and column chart. enter…
Soumu Sharma
  • 1
-1
votes
1 answer

Flutter - How to add a row in Excel Online

I am trying to develop an application which will work with an Excel sheet stored in OneDrive (Excel Online). I want to use flutter to add data into the excel sheet however I cannot find any APIs to do so. So far I only found the flutter excel…
gohan ssj
  • 1
  • 1
-1
votes
1 answer

How to identify Logged in user of sharepoint while opening a macro enabled spreadsheet on sharepoint in open in

I have a spreadsheet (macro enabled ) mounted on a sharepoint for multiple user access in centralized location. However the macro doesn't get kicked off when opening the excel online,but the workaround for this is to open in excel mode which made…
user2075017
  • 457
  • 4
  • 11
  • 23
1 2 3 4 5 6 7
8