Questions tagged [excel]
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 MS Excel for single worksheet functions is available at Super User.
238,275
questions
0
votes
0answers
9 views
How do I reduce the time to Invoke Macro via Python?
I noted that when I invoke a macro (via Python) to do some stuff in my Excel workbook it takes longer than if I write the code in Python to do it directly. The time difference is about 50% less.
Is ...
-1
votes
0answers
11 views
Corrigir Macro VBA envio de mensagem de texto/SMS
Olá!
Estou montando uma macro que faz envio de mensagem de texto usando o Messages.Google.
Mas ele quando chega na parte Digite a Mensagem, ela n?o prossegue, e tambem n?o ponta nenhum erro.
Alguém ...
0
votes
0answers
12 views
How to access the Web using VBA? Please check my code
In order to improve the repeatitive work, I tried to access the Web site which is using in company using VBA.
So, I made code using VBA. And I checked it could be access the normal site such as google,...
0
votes
0answers
20 views
how can get the formula of a data table in excell_
this is my data and im trying to get the formula of it, how can i do it ( it dosent have to be using excell only but i dont know how to do it )
0 2 4 6 8
0 100 90 80 ...
0
votes
0answers
21 views
Worksheet copying dynamic cells
I'm hoping to get some idea on automating copying some data in-between columns and worksheets.
I have to clear column C, then copy B over, clear B then repeat for A. Where it gets tricky for me is ...
0
votes
1answer
25 views
Ranges in Excel vs. in Google Sheets
Let's take the following data:
It seems that if you do =A2:A7 in Excel it will return a range whereas if you do the same in Google Sheets it will evaluate that to a SUM:
What would be considered a ...
0
votes
1answer
19 views
Python program does not write to an Excel cell
First row is the header
I then want cells to be printed. The code runs successfully. Creates the file and the header but does not print the values like Cars, 10 etc from row 2. What's wrong in the ...
0
votes
0answers
9 views
Excel VBA - Downloaded csv file with url but it just displays html code instead of actual contents of csv file
There is an online spreadsheet that has the option to "Download Spreadsheet". When you select it, it downloads the file as a .csv to the downloads folder. I want to download this spreadsheet ...
0
votes
0answers
6 views
ASP NET Core is possible to read excel from bytes?
i need to create a method in my API controller, where the user upload a excel file.
After that i must read the excel and import some data to my database.
I found this article that seems very good (i ...
0
votes
2answers
23 views
Input Value on another table only when necessary
I have another excel problem. What function do I need to display only a lead time when there is an order placed? For this example, the 3rd Lead Time RN "0.19" will be displayed on Week 7 of ...
0
votes
0answers
14 views
Sorting a table by date in Excel, rows with the same date are not reversed as I expected? [duplicate]
When sorting by the date I was surprised excel does not reverse the rows of data within the same dates.
I have the following table of data:
Date Narrative ...
1
vote
4answers
34 views
Counting value based on 2 other column in excel
How to count the value as shows in the below example in vba or excel formula, Count column should have a value of the combination of column1 and column2.
0
votes
0answers
10 views
Use Sumproduct as Array Sumif
I'm trying to build a lookup that adjust its array based on criteria for both row and column. Originally I was using sumif function that is using the correct arrays, however I found out that sumif is ...
0
votes
2answers
21 views
VBA - Copy last Row Formula to New row (Table)
looking for a code that will copy formula from Last Row to a new row in a table
or some code that make the new row with formulas :)
example: Last row number C25= A25+B25 so the new row Number 26 will ...
1
vote
2answers
27 views
Copy just the value to new sheet in VBA
I'm so close on this, but keep getting errors if I try to use .Value or .PasteSpecial xlPasteValue. I'm not sure where to put it, but I've tried multiple options. I want this to work as is, but just ...
欧美日韩国产在线一区二区_午夜短视频在线观看_亚洲国产欧美日本视频_亚洲精品高清视频在线观看