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].
207
questions
0
votes
0
answers
27
views
Uploading file to ASP.NET Core Web API using VBA
I'm struggling to upload a CSV file from local drive to a Web API.
Sub Upload()
Dim objHTTP As New MSXML2.ServerXMLHTTP60
Dim url As String
Dim filename, resp As String
Dim boundary, ...
- 2,412
0
votes
1
answer
35
views
Get value from different excel sheets with criteria
i want to get value from another excel sheets based on some criteria. at first look at the picture.
here in the gray highlighted cell i want to get the value from other sheet and it'll be dynamic and ...
- 111
0
votes
1
answer
39
views
How to Calculate Times in Variable Cells
I am trying to create an excel file that logs diver times. Specifically, I am logging their in/out times, total dive time, and surface intervals. If you're not a diver, the total dive time is the ...
- 147
-1
votes
0
answers
49
views
Cells gets only a zero
I wrote a function in Excel VBA and use
cells(x,y) to get the values.
The problem is the table cells I copied into the excel sheet will only be read as zero. But the cells I wrote the values in by ...
- 29
0
votes
1
answer
38
views
What excel formula can I use to compare 2 columns and pick the cell that does not have #n/a in it?
A
B
C
**1**
ID 1
ID 2
Expected Output
**2**
0011Q00001xC8a7QAC
#N/A
0011Q00001xC8a7QAC
**3**
0011Q00001xC8aTQAS
#N/A
0011Q00001xC8aTQAS
**4**
#N/A
0011Q00001xxxFFFQr
0011Q00001xxxFFFQr
**5**
#N/A
...
1
vote
0
answers
20
views
Active X Controls change position on worksheet despite being software-fixed [duplicate]
the position of my controls change after clicking on them, despite my attempt to fix position by the code below. Is there anything else I should do? Please help.
Private Sub CalculateMe_Click()
Dim ...
- 11
0
votes
1
answer
18
views
How to link a shape to a column so when the shape gets larger the column get larger too?
I want to do a database on Excel and in the first page there is a navigation menu on the left side working with macros for each tab to send the user to this exact tab. The code is the following and ...
0
votes
0
answers
30
views
VBA checkboxes being inserted differently after running code again
I am trying to insert user form checkboxes in column C of my excel file because i'll use logic in another macro to see if they are checked and write information to word based on that. This code worked ...
0
votes
4
answers
54
views
How to return number placement based on criteria from a table?
I've run into an issue that I can't quite figure out. I need to return the placement of a list of values based on a separate criteria.
I have a table that looks like this:
I'm looking for a way to ...
- 189
0
votes
0
answers
21
views
Getting extra null rows when I am trying read excel file with EPPlus OfficeOpenXml
I have an Excel file with 4 sheets. However, it is behaving incorrectly when I am reading the first sheet in my C# (.NET Core 3.1) code.
The sheet has around 350-450 entries, sometimes it reads only 4 ...
- 402
2
votes
3
answers
60
views
Workbook tab Color count loop
I need help with a loop to count all colored tabs in a workbook. I have 4 different colors, I would like to data to sum on the first tab of the workbook showing how many green, yellow...ect.
Public ...
-1
votes
1
answer
35
views
Creating/Updating an excel file with slicers from python
I have some python code which creates a few pandas data frames which I need to put into a spreadsheet, with different data on multiple sheets and with slicers for easy filtering. This then gets sent ...
- 3,144
1
vote
1
answer
42
views
How to untoggle all custom ribbon buttons except one programmatically in Excel-VBA (only works with breakpoint)?
I created a custom ribbon UI for Excel, using the Office Ribbon X Editor. On that ribbon are several toggleButtons. The XML looks like this:
<customUI xmlns="http://schemas.microsoft.com/...
- 21
0
votes
1
answer
22
views
Using unicode characters in Power Automate Online Excel Filter Queries
I have an Excel "List rows present in a table" action in Power Automate online with the ODATA filter query 🖶 eq 'x', as the Excel column is named with the unicode character 🖶 (U+1F5B6), ...
- 1,038
0
votes
0
answers
36
views
We need to move cell A100 below A54
We are freezing rows from A51 to A54 and I have selected cell A100.
await Excel.run(async (context) => {
const sheet = context.workbook.worksheets.getActiveWorksheet();
sheet.freezePanes....
