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 |