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
208
questions
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....
-2
votes
0
answers
23
views
post to get info to write a part of VBA CODe for at my workplace [closed]
So, I need help to write vba code from the start. I have a folderpath (C:\Users\shubham.vashisht\Desktop\Collection Bot\Removerow) that contains a lot of excel file
the format of these excel files are ...
- 1
-2
votes
1
answer
77
views
My SaveAs Code is not responding. How do I fix it? [closed]
I am working in a worksheet that has a lot of tables and query's and I want to make a Macro to save the document that has been filled in and start a blank one with the same query's and tables but only ...
1
vote
0
answers
21
views
How to stop a #N/A result showing in a most frequent value formula? [duplicate]
I have a spreadsheet of raw data that includes a cost based on a product code. I am trying to create a table that collates that information into an easy to read overview.
The cell I am currently ...
- 11
4
votes
4
answers
89
views
Compare a number array with existing records in Excel or VBA
I have a sheet with 3k+ lines and 15 columns. Each column is filled with a random number from 1 to 25. Very much like lottery results, where each column is a number drawn from the lottery. (from 1-25)
...
- 123
0
votes
1
answer
61
views
How do I handle merged cells in Excel using Pandas parse function?
I have an Excel file with merged columns and rows, and I want to read the excel file and parse it to convert it into a DataFrame.
This is just a small example of what happened because the real data ...
- 1
0
votes
1
answer
22
views
can power automate save an excel output as unicode
I have returned an excel table from office script into power automate. However when i save the file as a txt file. Notepad++ detect the file as UTF-8
Is it possible to replicate Excel's "Save As ...
- 3
0
votes
2
answers
43
views
VBA: Editing Power Query M-Code using VBA
I have a shared Excel file with a Power Query that extracts data from an external local file. However, several users work with the shared file and they need the Power Query to access the local file ...
- 1
0
votes
1
answer
26
views
Error 91 - DataBodyRange.Copy ignore null
"DB" sheet contains 1 table with 3 Columns - Trade Date, ISIN, Trade ID. This is the output of a power query to pull data from the database (based on certain criteria) and display it here.
&...
- 25
0
votes
0
answers
28
views
Update Excel cell values using links indirectly
I have my master data sheet where I have data from other multiple data files. What I would like to do is to call this data automatically, like the links do. However, these data files don't have always ...
- 1,100
0
votes
0
answers
17
views
Preserve separately selectable Columns in PDF export of Excel document
When exporting Word documents or rendering LaTeX, you can designate columns and thus enable seperate selection of sections of the Document:
Meanwhile when exporting Excel, I could not find any way to ...
- 23
0
votes
3
answers
55
views
Need help to extract this XML node - Excel connection strings in Python
I have a Python program opening up Excel (XLSX) files, and trying to find the <connection> node.
This is the full XML from the connections.xml file.
<?xml version="1.0" encoding=&...
0
votes
0
answers
20
views
How to find group pair duplicates in Excel (creating graph nodes)
I have a class of 40 students performing 5 group activities. Each group having 3-4 students per activity. My goal using Excel is to find and minimize the number of instances where students have the ...
- 379
1
vote
1
answer
39
views
macro to change the color of a cell after i copy it (CTRL+C)
i do a lot of testing and i use a list of barcodes generated in Excel.
I copy the barcode i use, then change the color of the cell so i know which ones are used.
Is there a way a macro could ...
- 35
1
vote
2
answers
40
views
Sum Bottom of Column(s) with Dynamic Formula
I am working on a vba code that places the sum of a column (F) dynamically at the bottom. I would like this formula to loop through the remaining columns in the worksheet up to column AM (e.g. columns ...
- 51