Python Forum
Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Openpyxl Help
Post: RE: Openpyxl Help

(Apr-19-2021, 01:17 PM)Larz60+ Wrote: can you supply a sample of each input file format. You can alter or make up the data if it is sensitive. Need something to run code against. I'd also suggest t...
SunWers General Coding Help 2 2,630 Apr-20-2021, 12:11 AM
    Thread: Openpyxl Help
Post: Openpyxl Help

Hello Everyone, I've been working on getting some scripts together to help me automate some of the reports that I do daily and I think I'm about there but I have a few questions. I enjoy working wit...
SunWers General Coding Help 2 2,630 Apr-19-2021, 12:51 AM
    Thread: Need Help With a Script
Post: RE: Need Help With a Script

I think I'm finally getting closer to what I'm trying to achieve. As mentioned above I have two worksheets, one is an import file and the other is a blank report to add the import data. This is the ...
SunWers General Coding Help 6 3,436 Jan-07-2021, 03:26 AM
    Thread: Need Help With a Script
Post: RE: Need Help With a Script

(Jan-05-2021, 09:00 PM)buran Wrote: How do you expect to iterate over single cell object, that does not support iteration? Oh I think I understand... if I had more than one cell in ws2 the script wo...
SunWers General Coding Help 6 3,436 Jan-05-2021, 09:43 PM
    Thread: Need Help With a Script
Post: RE: Need Help With a Script

(Jan-05-2021, 06:34 PM)buran Wrote: (Jan-05-2021, 05:49 PM)SunWers Wrote: What would I be doing wrong?Isn't it obvious from the traceback? ws2['C4'] is a cell object and you try to iterate over it...
SunWers General Coding Help 6 3,436 Jan-05-2021, 08:56 PM
    Thread: Need Help With a Script
Post: RE: Need Help With a Script

OK.... Update I've changed my script once again. Here is what I have now: import openpyxl wb1 = openpyxl.load_workbook(r'ImportFile1.xlsx') wb2 = openpyxl.load_workbook('Weekly-temp1.xlsx') ws1 ...
SunWers General Coding Help 6 3,436 Jan-05-2021, 05:49 PM
    Thread: Need Help With a Script
Post: Need Help With a Script

Hi, I'm still working on trying to get a script together for importing data to my cutter reports. Seems like I've had this script a million different ways... I decided to parse the .csv file manual...
SunWers General Coding Help 6 3,436 Jan-05-2021, 05:42 PM
    Thread: Converting .txt to .csv file
Post: RE: Converting .txt to .csv file

Thank You! I think what I will do is parse them myself and then go from there. I'm thinking there is a way to pull the files as .csv format. But I won't know for sure until I get back to work Monda...
SunWers General Coding Help 21 11,718 Jan-02-2021, 01:22 AM
    Thread: Converting .txt to .csv file
Post: RE: Converting .txt to .csv file

(Jan-01-2021, 07:53 AM)palladium Wrote: (Jan-01-2021, 07:31 AM)SunWers Wrote: Hi Palladium, I just tried adding "sep = None" and this is the error message I get... runfile('C:/Users/vhubb/Docume...
SunWers General Coding Help 21 11,718 Jan-01-2021, 08:04 AM
    Thread: Converting .txt to .csv file
Post: RE: Converting .txt to .csv file

I'm thinking this might work. This is from my google drive https://drive.google.com/file/d/1j-Uc3XL...sp=sharing
SunWers General Coding Help 21 11,718 Jan-01-2021, 07:56 AM
    Thread: Converting .txt to .csv file
Post: RE: Converting .txt to .csv file

(Jan-01-2021, 07:41 AM)buran Wrote: can you upload sample input file? Looking at the screenshot again, it is more likely a fixed-width file. Sorry, crazy question.... how do I upload a file?
SunWers General Coding Help 21 11,718 Jan-01-2021, 07:48 AM
    Thread: Converting .txt to .csv file
Post: RE: Converting .txt to .csv file

(Jan-01-2021, 07:27 AM)buran Wrote: (Jan-01-2021, 06:29 AM)SunWers Wrote: I was thinking I needed to convert it to a .csv file that I would then need to convert to a .xlsx file.No need to convert ...
SunWers General Coding Help 21 11,718 Jan-01-2021, 07:39 AM
    Thread: Converting .txt to .csv file
Post: RE: Converting .txt to .csv file

(Jan-01-2021, 06:52 AM)palladium Wrote: (Jan-01-2021, 06:29 AM)SunWers Wrote: I'm thinking it's because of this part of the code with the ; Easiest way to find out is to print out the dataframe an...
SunWers General Coding Help 21 11,718 Jan-01-2021, 07:31 AM
    Thread: Converting .txt to .csv file
Post: Converting .txt to .csv file

Hi, I'm needing a little help getting a text/tab delimited file imported in with python. I think I'm missing how to import the columns... This is what my text file looks like. I was thinking it wa...
SunWers General Coding Help 21 11,718 Jan-01-2021, 06:29 AM
    Thread: Help with Creating a Script for Automating Reports
Post: Help with Creating a Script for Automating Reports

Hi, I'm new to Phython and I'm working on trying to automate some reports that I've done manually for years. I work for a manufacturing facility that makes garments. Some detail on the reports that...
SunWers General Coding Help 1 1,882 Dec-29-2020, 06:36 PM
    Thread: How to Copy Single Value From One Excel Sheet to Another
Post: RE: How to Copy Single Value From One Excel Sheet ...

Thank You! I will check this out. (Dec-29-2020, 09:28 AM)Pedroski55 Wrote: Not too sure exactly what you want. I don't have to copy any formulas or charts, so I never tried and I don't know about...
SunWers General Coding Help 4 4,200 Dec-29-2020, 05:39 PM
    Thread: How to Copy Single Value From One Excel Sheet to Another
Post: RE: How to Copy Single Value From One Excel Sheet ...

(Dec-28-2020, 06:42 AM)buran Wrote: ws.cell(row=4,column=3).value=ws1.cell(row=4,column=6).value Hi buran, Thank you! I think I've been looking at the computer screen way too long and need to take...
SunWers General Coding Help 4 4,200 Dec-28-2020, 07:18 PM
    Thread: How to Copy Single Value From One Excel Sheet to Another
Post: How to Copy Single Value From One Excel Sheet to A...

Hi Everyone, I'm trying to copy one value from a worksheet to another, but I'm doing something wrong. Can someone help me understand how to do this. I'm trying to copy a value from workbook(Weekl...
SunWers General Coding Help 4 4,200 Dec-28-2020, 06:03 AM

User Panel Messages

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