python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - openpyxl

Python Pandas csv files to Excel worksheets - Cleanup

I want to take multiple .csv files and convert them to Excel worksheets in one workbook, specifically using Pandas. I finally got this to work, but I know the code itself is of poorly written. Any sug...
test-img

Jason Yuill

python

excel

pandas

csv

openpyxl

Votes: 0

Answers: 0

Can OpenPyxl create custom workbook views?

Long intro to my question... While trying to automate my creation of an Excel spreadsheet to track student marks (don't like any of the mark tracking tools available to me) I created a Python program ...
test-img

CambridgeCro

python

excel

openpyxl

Votes: 0

Answers: 0

How to set ws.title to today's date with openpyxl

I am pulling a list from a sharepoint site using shareplum. The output is saved locally in an excel file. There is only one sheet created. I need to set the name of the worksheet to the date user will...
test-img

santee

python

openpyxl

Votes: 0

Answers: 1

Latest Answer

Try use datetime.now().strftime("%m/%d/%Y, %H:%M:%S")
test-img

Даниял

Python how to loop through this excel data and push it into another workbook?

I am currently trying to write a script that will loop through the 'members' column (see image workbook A) and copy the rows into another work book. For example 'A2 L0 - A2 L4' the corresponding rows ...
test-img

popo.dior

python

excel

loops

openpyxl

Votes: 0

Answers: 1

Latest Answer

I think this will do what your question asks: import openpyxl as opxl from openpyxl.utils.cell import coordinate_from_string, column_index_from_string book_a = opxl.load_workbook('WORKBOOK A.xlsx', re...
test-img

constantstranger

Posts

Questions

Blogs

Jobs