All Questions
14,992 questions
1
vote
1
answer
36
views
Read data from sheet1 and output filtered data on sheet2
Is it possible?
Or it seems that each sheet is a separate environment?
CONTEXT:
A clean way to read 200 rows of data (and 30+ columns) is using something like
df=xl("A:BS", headers=True)
So ...
- 12k
1
vote
2
answers
201
views
How to force a string to stay a string and not be converted to a date ? - Python [closed]
I'm facing an issue while pushing data into Excel using Python.
I need to write a string like "4/10" to a cell, but Excel automatically converts it into a date.
However, "4/10" is ...
- 21
1
vote
2
answers
118
views
Update formulas in excel using Python
I am trying to update formulas in an existing excel which has data and tables but I am failing to update the formulas so that they would update the data for example:
Okay since I get some answers but ...
- 55
-3
votes
0
answers
142
views
Why doesn't dynamic string work with xl() function in 'Python in Excel'?
I try Python in Excel.
The following code works well.
label = xl("AH2")
But the following code does not work.
row_label = '2'
col_s = 'AH'
label = xl(f"{col_s}{row_label}")
What ...
- 2,301
0
votes
1
answer
56
views
Python scraper not returning value to Excel
I have a Python webscraper that pulls a specific value every 1 second. The target website it AJAXed, so I'm not hitting it with too many requests.
This is the Python code:
import time
import logging
...
- 1,136
0
votes
0
answers
73
views
How to solve Python error?: pywintypes.com_error exception that I use for changing the location an excel file
I have this code that I used to convert an excel file ( .xls) to (.xlsx) and edit it and save it to another location. It used to work perfectly but just now I encounter some Error with the xlmain11....
0
votes
0
answers
50
views
How to Distinguish Between Product Codes and Quantities in Mixed Cells in Python?
I'm working on a script that processes an Excel file containing product information. The data includes both product codes (which are 5-digit numeric values) and quantities, but these values are ...
2
votes
0
answers
62
views
Error opening Excel file in python edited on Excel Web Interface
Problem:
I'm encountering issues when trying to open Excel files (.xlsx) with pandas that was edited on SharePoint Online (Microsoft 365) via the web Excel interface and then downloaded.
Code and ...
- 471
0
votes
0
answers
53
views
How do I convert Excel to CSV, but preserve the dates using Python? [duplicate]
I have some code that creates csv files from an xlsx file, however, all dates are coming in the csv file as a float. This is a problem when I have more than one date in a column. Anyone know how to ...
- 17
0
votes
0
answers
18
views
Parameter optimization using PSO algorithm in python
I have hydrology model which I built using excel and I want add the parameter optimization using Particle Swarm Optimization algorithm using Python. The idea of the code is to extract the value of ...
1
vote
1
answer
75
views
how to read excel merged cell properties value using python?
I need to read data from an Excel file. The first cell contains the property name, and the second cell contains the property value. However, some of the property names in the first column are merged ...
- 5,075
0
votes
0
answers
87
views
Excel Table Manipulation using Pandas (Python)
Context:
I work at a company where we handle equipment and employee records.
We receive Excel spreadsheets with data on equipment usage (hour meters, mileage, and entries/exits).
These spreadsheets ...
- 1
1
vote
0
answers
43
views
Google Drive API Batch Upload Fails with Latin-1 Encoding Error, Works Individually
I'm encountering a UnicodeEncodeError: 'latin-1' codec can't encode character '\ufffd' when attempting to upload Excel files to Google Drive using the Google Drive API's batch request functionality. ...
0
votes
1
answer
38
views
Read content of Excel with multiple sheets with pandas and append new one sheet
I have a Python script that reads content from JSON file and then write to excel file using pandas with that code and format:
fichero_excel_salida = 'Estad.xlsx'
nombre_pagina = 'Jornada_' + str(...
- 13
0
votes
1
answer
62
views
pipx installed xlwings module not found
I have an Excel workbook that uses an xlwings RunPythonScript() call to an external python script. As I want to run this python script outside of my vdev I've installed pipx and through pipx installed ...
- 11