All Questions
136 questions
0
votes
0
answers
26
views
Python refresh error in an Excel wrkbk that has formulas with Named Ranges
I'm currently using this script to refresh an Excel workbook from python. The script works well with the exception that the formulas that have Named Ranges in them don't fully calculate and are left ...
2
votes
1
answer
50
views
How to Close All Excel Files in a Specific Directory Using Python?
I'm working on automating some tasks using Python, and one of the requirements is to close all Excel files that are currently open in a specific directory. I often have multiple Excel files open from ...
- 21
0
votes
0
answers
54
views
Dynamically filling Excel template fields based on conditions in Python
I am trying to generate Excel certificates from a template file, filling specific cells with data based on certain conditions. I want to dynamically fill out product details, recipient address, and ...
- 149
0
votes
1
answer
106
views
Is there a way to consistently visually navigate excel in Python?
I am looking to automate a reporting process for my job, which involves taking a screenshot of multiple excel sheets within the same workbook. Right now, I am using pyAutoGui, which works O.K.
The ...
1
vote
1
answer
83
views
Export Excel Spreadsheet From Website - Python
I am trying to find a way to export a Microsoft Excel spreadsheet (.xlsx) from a website and store locally (to my desktop) or to a database. I am able to parse a URL with tabular content and display/...
- 349
1
vote
1
answer
643
views
How do I copy-paste a worksheet from one excel workbook to another using python?
In Excel, I can manually:
open the source workbook
select the sheet I want to copy
click the Select All button in the upper left corner
ctrl-c
open the targe workbook
insert a new sheet using the ...
- 2,952
0
votes
1
answer
85
views
Trying to Automate Comparison between 2 Columns in Excel using Python
I am trying to automate the find feature in excel that uses the contain functionality. I want to identify if a value is present in a string of text. For example a description field. If it finds that ...
- 1
0
votes
0
answers
353
views
How to integrate a Microsoft Power apps application with a script to export and update data automatically
I have a Microsoft power apps application that I built and one part of the weekly maintenance to keep this application updated with the correct information is to manually update some sort of data from ...
- 1
0
votes
0
answers
257
views
Automate Microsoft Excel and Word Using Python: Fill word table from list of names from excel document
I am trying to complete the below code for automating form tables in word and excel. It is designed to access an excel table, find the unique names in column 1, then fill out a table in a word ...
0
votes
2
answers
660
views
AttributeError: 'NoneType' object has no attribute 'ActiveSheet' even though the excel workbook is running
import win32com.client
#Attach to the running excel
excel = win32com.client.GetActiveObject("Excel.Application")
workbook = excel.ActiveWorkbook
worksheet = workbook.ActiveSheet
active_cell ...
- 13
0
votes
0
answers
163
views
Automate Password Removal in directory with password in excel with script
Essentially I receive a bunch of files every so often, the files are excel documents that are password protected ( the password is the same for all and static). I want the script to iterate through ...
0
votes
3
answers
740
views
Openpyxl: Write value in the first empty cell in Column A of an Excel file
I would like to write variables into an Excel. As the Excel is already filled with content, I would like to start writing the first variable into the first empty cell of column A. Then I jump to the ...
2
votes
1
answer
1k
views
Issues with '@' symbol in Excel formula when using OpenPyXL to write .xlsx file with INDEX functions
I'm currently working on a Python script that utilizes OpenPyXL to write formulas to a .xlsx file. The specific formula I'm using involves the TEXTJOIN and INDEX functions. However, upon opening the ...
- 148
0
votes
1
answer
397
views
How to automate an report process with python?
Every day, I have to create a performance report within one hour. While I cannot change the entire process, my goal is to automate the tedious task of copying and pasting data from other sources into ...
0
votes
0
answers
38
views
how to do vlookup in python for only one column from multiple excel files?
Lets say I have 5 Excel files named as A, B, C, D, X. Now I want to automate this vlookup in python. Suppose I want to have vlookup data in X file from rest 4 files. All the files have common column ...
