Welcome to python-forum.io

Results

Search Results

Post

Author

Forum

Replies

Views

Posted [asc]

Thread: openpyxl nested for loop help
Post: RE: openpyxl nested for loop help

Hello, Newbie here too :) For what I understand, at loop 1 you replace all the "X" by "value1" in the object wb in memory. At loop 2 no "X" to be replaced wil be found in wb. Creating a new destinat...

LocalFolder

General Coding Help

5,668

Oct-16-2019, 12:35 PM

Thread: Openpyxl with large file
Post: RE: Openpyxl with large file

Hello, (Oct-15-2019, 08:40 AM)buran Wrote: check this So question https://stackoverflow.com/questions/2187...ata-excels and suggested workarounds for incremental saving the file Thank you Buran but...

LocalFolder

General Coding Help

9,232

Oct-15-2019, 11:24 AM

Thread: Openpyxl with large file
Post: RE: Openpyxl with large file

Good morning, So, I dumped all my data into a csv file. It work fine, resulting a 16Mo file for around 42k lines of initial data. After that I wanted to append the csv into a fresh xls file with the ...

LocalFolder

General Coding Help

9,232

Oct-15-2019, 08:32 AM

Thread: Openpyxl with large file
Post: RE: Openpyxl with large file

Good morning, So, I tried to split the writing and saving process of the workbook every 5k lines. I wanted to introduce "a sleeping time" between each 5k lines of data written. Even with 30sec of sle...

LocalFolder

General Coding Help

9,232

Oct-14-2019, 12:27 PM

Thread: Openpyxl with large file
Post: Openpyxl with large file

Good morning my dear Python Experts, I'm new here, I'm not an expert with coding or python and i have an issue with openpyxl. I have some process that produce xls files with data in sheets within a ...

LocalFolder

General Coding Help

9,232

Oct-11-2019, 08:47 AM

Results

User Panel Messages

Announcements