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,122
questions
0
votes
2
answers
36
views
How to count the number of cells in a range that has been named with the Dim statement in VBA [duplicate]
I am trying to figure out how to use things like .count with a range that I have stored as a variable in VBA
I have made the following function which works
Function test2() As Variant
test2 = ...
0
votes
0
answers
21
views
Unable to Locate "Sheet1" in Excel File When Using pyodbc to Insert Data into MS Access
I'm trying to insert data from an Excel file into an MS Access database using pyodbc, but I keep encountering an error stating that "Sheet1" cannot be found in the Excel file. Here's my
...
0
votes
0
answers
23
views
Python Error : [42S02] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine could not find the object 'Sheet1$'
For some reason with what I am trying I cannot get to find the excel Sheet1. Here is my code:
filename = 'ALC_2022068_06282024-testing copy.xlsx'
sql = r"""INSERT INTO tblALC_test ([...
2
votes
1
answer
22
views
Algorithm for parse formula excel from original cell to destination cell
I am trying to parse formula in excel with 3 params: Formula, original cell address, destination cell address.
Example, with some rules:
Formula
Original Address
Destination Address
Result Expected
...
2
votes
2
answers
45
views
excel - how to pick the whole row using randbetween
I'm trying to pick a random row from my dataset shown below.
I'm wanting to pick out 2 rows from the list at random, with column C being the column that is randomized and column D to match with the ...
-4
votes
0
answers
19
views
Using "openpyxl" Excel lib. With Python [closed]
Currently I am Using openpyxl Lib with Python to Generate and customize Reports as a task for my job, for a small scale it works fine,
but when dealing with lots of Rows and Columns and more sheets or ...
0
votes
0
answers
19
views
How to upload excel file in nodejs?
Title: How to Upload and Read an Excel File in Node.js Using Express and Multer
I'm trying to upload and read an Excel file in my Node.js application using Express, Multer, and the XLSX library. I've ...
0
votes
1
answer
22
views
Error when using hashtag in Data Validation in Excel
I am using Macbook Sonoma and am struggling to use # in the Worksheet. I have a dynamic column in a separate sheet called Lists that will have new values, so I am using the below formula to make sure ...
0
votes
0
answers
21
views
Display photos using one drive or hard drive without prompting grant file access in Excel on a Mac
I need your support to fix this code so that it doesn't prompt for file access permissions in Excel for Mac.
The code works fine when the path directory is within my laptop's local storage in the ...
0
votes
0
answers
28
views
Adding Average at the very last part of the row and column in a dataset
I have a sample dataset of total outbound calls, it comprises rows (dates) and columns (hourly), my goal is to show totals and average of outbound calls per day (rows), and the totals and average of ...
1
vote
0
answers
15
views
Excel sheet refreshed using Python. Not able to use data until program is closed and reopened
I have a Python program connected to an excel spreadsheet. That spreadsheet gets data from a spreadsheet on a server. There are several columns with text information and a date column. My python gui ...
0
votes
1
answer
25
views
I want copy the paragraph that a comment has been added to in Word and put into an Excel table
i found a really simple macro in LinkedIn, from 'Harriet. L', to look at the Comments in a Word document and create an Excel table sowing the 'page, author, comment text & date created' for each ...
0
votes
0
answers
13
views
Copy range and format from excel and paste into new word doc
I need to have a button with a macro that copies a range of cells and their formatting/make it autofit width wise on an doc and pasted them into a new word document when the button is clicked.
This is ...
0
votes
0
answers
23
views
Openxlsx Excel file with hyperlinks not working in Protected View
I'm making excel files that contain hyperlinks in some cells using the openxlsx package.
However, when you download the file from the Shiny app, it opens in Protected view. Trying to click on the link ...
-1
votes
2
answers
73
views
How to select multiple cells in VBA if there is a blank in between?
If I can dynamically (without hardcoded cell range) come to the yellow marked cell "", how can I select the range like in the screenshot dynamically? xlDown brings me only to the row before ...