Questions tagged [excel]
Only for questions on programming against Excel objects or files, or 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. Do NOT use with other spreadsheet software like [google-sheets].
excel
52
questions
1
vote
1
answer
6
views
Filter and sort data with multiple column & row criteria and match corresponding data to it with flexible return_arrays
0
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
1
Product
Shop
2023-S
2023-M
2024-S
2024-M
Type
2
3
500
4
P-Line_A
Step1
5
Prod_A
shop3
80
2%
500
22%
t1
ColCrit1
ColCrit2
ColCrit3
6
Prod_B
shop2
...
0
votes
0
answers
9
views
Delete cells to autofit columns to default size
I am using the below code to delete cells and autofit all columns in multiple sheets to default size. I am not a good writer of codes but used this to get results. My query, Is there a way to do this ...
0
votes
0
answers
10
views
Assign a table from an excel spreadsheet to a variable, so i can paste it in a website using Selenium - Python
I'm looking to be able to assign a table from an excel spreadsheet to a variable, so that i can paste it in a text field in Selenium
This is the code that i have tried
It pasted the headers of the ...
0
votes
0
answers
17
views
How to create button from file excel "Master file" import data from the another excel "File input"
When others write into the "input file" that I send to another person's computer, when they write their information, that information will be saved in the ''Master file''.
I want to get the ...
0
votes
0
answers
35
views
Getting error for COM excel when trying to build project in Visual Studio
When I build my project I am getting error saying
The type or namespace name 'Excel' does not exist in the namespace 'Microsoft.Office.Interop' (are you missing an assembly reference?)
In the ....
0
votes
1
answer
24
views
Excel ClearContents or Cell Set to = “ “
I’m trying to have a macro button to clear contents of a range of cells, and upon using the code below , It clears the contents of merged and unmerged cells. Is there a way to not clear the contents ...
0
votes
1
answer
23
views
Excel Ungrouping data
I am trying to ungroup the data in excel file.
I am not aware of row no which have been grouped.
When I click on 2 on top of file data gets ungrouped.
Is there a way I could do it using python.
I ...
0
votes
0
answers
7
views
VB Macro editor in excel - cross checking data in sheets and keep getting error that specified sheets dont exist
I am trying to cross check data in one excel with two sheets. Every time I try and run my code it gives me the error of "one or both of the specified sheets don exist" even though they are ...
0
votes
0
answers
11
views
How do I disable any kind of automatic conversion into excel when using xlwings?
When using xlwings, I want to, for example, write the string "4 / 5" into excel. However, if I write.
sheet[0,0].value = "4 / 5"
I get: string converted to date
I do not want to ...
1
vote
0
answers
20
views
Run time Error '91' Object variable or with block variable not set
I'm working in excel on a database that uses values from one sheet to update another. There is a sheet named "Line List" which contains line numbers (unique identifiers for piping) and lists ...
-1
votes
0
answers
15
views
Filter the number of values in a pivot table [duplicate]
I have a table in the below format:
where the category stretches from X1 to X5 and Time repeats from 1 to 9. s1 to s5 are having independent data entries.
When I convert it into pivot table, I get ...
-1
votes
1
answer
43
views
Macro to delete cells with "" in a column
I have a column full of either numbers or blanks, except Excel doesn't treat them as blanks because they are actually a formula like =IFERROR(A1+B1,""). I would like a macro to copy this ...
1
vote
1
answer
26
views
Partial Power Query transposition so that captions remain
Novice power query user here. I would greatly appreciate if someone could help me with the following problem. I'm tasked with modifying an excel template that is roughly of that format:
City
Borough
...
0
votes
1
answer
33
views
Excel - COUNTIFS with multiple match criteria including a date condition
I am trying to pull all records that have been resolved in the last 7 days. I want to count these records by area.
Here is my Excel workbook.
Sheet 1
Row 1 for Titles: **Area (column A) | State (...
0
votes
0
answers
37
views
Why does this VBA code connecting to a SQL database return a syntax error?
This SQL query works perfectly in my Advanced Query Tool setup, but returns a Syntax Error when I plug it into the following SQL query:
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
...