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
288,302
questions
-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 ...
1
vote
1
answer
43
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/...
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), ...
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 ...
-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
22
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 ...
4
votes
4
answers
90
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)
...
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 ...
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 ...
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 ...
0
votes
1
answer
27
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.
&...
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 ...
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 ...
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=&...