![Questions Tagged [Excel]](https://docuprint.cloud68.co/uploads/questions-tagged-excel_1200.jpg)
Only for questions on programming against Excel objects or files, or complex formula development. You may combine the Excel tag with VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, and other programming related tags and questions if applicable. General help regarding Excel for single worksheet functions is available at Super User ().
264,421
questions
0
votes
0
answers
5
views
Strikethrough in Excel VBA
When I enter a second date in a cell, I want the initial date to be strikethrough and keep the both date in the same cell
I have a range of cells from column E to H, in which each cell has date.
Your ...
0
votes
1
answer
13
views
How do I merge all .xlsx files in a folder into one file in R
I currently have 12 excel files that are of the same length that I would like to read in R and combine them into one data frame for analysis, how do I do this? I would prefer to not have to go through ...
1
vote
0
answers
23
views
Is there a way to check if string or substring value from one column in a dataframe exists another column in a different dataframe?
I am trying to compare two similar columns from two different excel sheets using python,
df1['CrowdStrike'] = np.where(df1['VM'].isin(df2['VM']), 'YES', 'NO')
it then populates a column to say if it ...
0
votes
0
answers
15
views
Excel VBA web-scraping working half of the time
I have a VBA program used to scrape specific data from online real estate listings. I will add the code below. It searches the HTML code to return elements including Address, Year built, features, ...
0
votes
0
answers
15
views
How to read excel formulas from a csv file with python
I'm trying to use a plugin that the firm where I work have in excel. This plugin retrieves information about financial markets but it has no API to use with a "request" or "get" ...
0
votes
0
answers
9
views
Application.Onkey doesn't activate while in an excel formula
I am trying to "overwrite" the excel hotkey for selecting the entire row while in a formula
i.e. while in a cell, I type "=IF(B2 = C2, "EQUAL TO " & A2" and while ...
0
votes
0
answers
10
views
Laravel Import: file_put_contents(...): failed to open stream: No such file or directory
I'm trying to import an excel file with image on it, however i came across this error which says file_put_contents(images/detail_pengajuan/16553943431.jpg): failed to open stream: No such file or ...
0
votes
1
answer
16
views
Get the value of a clicked cell
In my Excel Worksheet I have a cell with an Image of a folder. When clicked I start a macro that ask for the folder selection. That part works fine but I would like to write the folder path in the ...
-1
votes
0
answers
11
views
Play Video from Sharepoint using Excel
Is it possible to play a video on Windows Media player through excel, where the video file is stored on SharePoint?
It works fine when on my local PC, but that means no one can view the video if the ...
0
votes
0
answers
16
views
How to call a cell with a path and use it for a formula
Worksheet'!$A3 has the file path of the document I want to reference.
R://User/Example/[Practice.xlsx]
In there I want to get the sum of $F$10:$J$10 in Sheet2 of the Practice.xlsx document.
I thought ...
-1
votes
0
answers
12
views
How to automatically add series to a scatterchart
I'm trying to create a dynamic Scatterchart in the worksheet("Graphs") using a button.
The Series has to be equal to Worksheets("VS_P240_X").Cells(2,a), where a is a counter for ...
0
votes
0
answers
20
views
How do you move one row to the next empty row if a cell has data?
Is there a function or VBA code in Excel that checks; if a cell has text data > move that row to another row on the same sheet.
Ie. In Table 2 the middle column has data > move that row from ...
0
votes
2
answers
11
views
Ideas to extract specific invoice pdf data for different formats and convert to Excel
I am currently working on a digitalisation project which consists in extracting specific information from pdf-formatted electricity invoices. Once the data is extracted, I would like to store it in an ...
0
votes
0
answers
6
views
Excel Power Pivot Table isnt giving correct information
I have excel power pivot tables. I have created relationship from table 1 to table 2. But when I create a pivot table I am getting the following:
enter image description here
but in reality it should ...
0
votes
0
answers
7
views
How to export Matlab Bathtub Curve to excel? In Matlab R2021.b
I wish to convert my Bathtub graph to data form, and plot it in excel.
Can anyone advice me how to export this graph data to excel? Thank you.
Matlab Bathtub curve
Below is my Matlab code (in R2021b ...
