Python Forum
Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: overwrite data using openpyxl
Post: overwrite data using openpyxl

I have an excel sheet where I need to mainupulate a certain work sheet. I am trying to clear the contents in the worksheet and overwrite contents from a text file. My code is as follows #!/usr/bin/...
BNB General Coding Help 0 10,575 Jun-21-2017, 11:31 AM
    Thread: read multiple .xlsx files and text files in a directory
Post: RE: read multiple .xlsx files and text files in a ...

Well, just an update, I have solved my issue with openpyxl but its just that openpyxl is not very helpful in saving images (as mentioned in its documentation) from original excel file and it disappear...
BNB Data Science 11 25,682 Jun-07-2017, 07:42 AM
    Thread: read multiple .xlsx files and text files in a directory
Post: RE: read multiple .xlsx files and text files in a ...

Hello, the text files are a result of some calculation done using awk and I need to paste the results back to the excel files.
BNB Data Science 11 25,682 Jun-05-2017, 07:57 AM
    Thread: read multiple .xlsx files and text files in a directory
Post: read multiple .xlsx files and text files in a dire...

I have a list of .xlsx files (names 1.xlsx, 2.xlsx etc), each with several worksheet, in a directory. I need to insert data from its corresponding text file (named 1.txt, 2.txt etc) on the second wor...
BNB Data Science 11 25,682 Jun-02-2017, 11:14 AM
    Thread: Write data into existing Excel (xlsx) file with multiple sheets
Post: Write data into existing Excel (xlsx) file with mu...

I have an excel (xlsx) file with 11 worksheets and I need to insert the contents of a text file from Row 3 onwards in Sheet 2 named 'Filtered'. Currently, this is the code I am trying #!/usr/bin/env ...
BNB Data Science 1 15,341 Jun-01-2017, 12:10 PM
    Thread: Help with code
Post: RE: Helo with code

Hello, As I said, I am not familiar with Python. Any kind of help would be appreciated. Thank you
BNB General Coding Help 3 3,401 May-24-2017, 01:54 PM
    Thread: Help with code
Post: Help with code

Hello, *sorry about the subject, unable to edit it* I am new to Python and trying to figure out a way to start. I have a large section of code that was generated by someone else and I now need to edit...
BNB General Coding Help 3 3,401 May-24-2017, 12:07 PM

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020