Questions tagged [excel]
Matthew Martinez 
Ask Question
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 2- Bountied 2
- Unanswered
- Frequent
- Score
- Unanswered (my tags)
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 ... excel vba macos- 3
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 ... r excel merging-data- 1
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 ... python excel pandas dataframe numpy- 11
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, ... html excel vba web-scraping- 1
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" ... python excel pandas csv openpyxl- 151
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 ... excel vba sendkeys- 1
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 ... php excel laravel image import- 3
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 ... excel vba- 55
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 ... excel vba sharepoint windows-media-player- 21
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 ... excel excel-formula- 1
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 ... excel vba charts- 1
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 ... excel vba- 13
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 ... excel ocr extract text-extraction data-extraction- 1
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 ... excel powerpivot table-relationships- 1
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 ... excel matlab- 1
15 30 50 per page12345…17629 Next
