Python Forum
Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Python code to set column width
Post: RE: Python code to set column width

I'll try to figure out what libraries I need, cheers
1418 General Coding Help 11 1,521 Jan-20-2024, 04:48 AM
    Thread: Python date format changes to date & time
Post: RE: Python date format changes to date & time

I obviously need to do a lot more research on what libraries I need, cheers
1418 General Coding Help 4 707 Jan-20-2024, 04:45 AM
    Thread: Python date format changes to date & time
Post: RE: Python date format changes to date & time

Hi Deanhystad, thanks for responding. I will always be modifying data so I assume I will need Openpyxl not xlsxwriter...is that correct, cheers
1418 General Coding Help 4 707 Jan-15-2024, 12:34 PM
    Thread: Python code to set column width
Post: RE: Python code to set column width

Can you tell me what additional library I need, cheers
1418 General Coding Help 11 1,521 Jan-14-2024, 07:52 AM
    Thread: Python code to set column width
Post: RE: Python code to set column width

sgrey, I tried both these without success. I'm using Visual Studio, are you suggesting I need to download additional libraries? Or should I use Pycharm? Error:inspdata.set_column_width(columns=['EForm...
1418 General Coding Help 11 1,521 Jan-14-2024, 07:41 AM
    Thread: Python code to set column width
Post: RE: Python code to set column width

Thanks sgrey, I tried the below code but it didn't work, what have I done wrong, cheers Error:inspdata.style.set_column_width({'EForm Id':100,'Contractor':100})
1418 General Coding Help 11 1,521 Jan-14-2024, 06:22 AM
    Thread: Python code to set column width
Post: RE: Python code to set column width

Thanks Larz60 but I'm new to Python so I still can't figure that out. Could you write the code to set the width for two of my columns, EForm ID & Contractor, cheers
1418 General Coding Help 11 1,521 Jan-14-2024, 05:01 AM
    Thread: Python code for alignment and font size
Post: Python code for alignment and font size

Hi, I would like help with a code to align left and top and change font size to 10 similar to VBA code. The code I am creating is below, cheers. import pandas as pd inspdata=pd.read_excel('Inspectio...
1418 General Coding Help 0 363 Jan-14-2024, 03:56 AM
    Thread: Python date format changes to date & time
Post: Python date format changes to date & time

Hi, my original data is short date (15/10/2023) but when I run the below code python changes it to 2023-10-15 00:00:00, how can I prevent this? Cheers. import pandas as pd inspdata=pd.read_excel('In...
1418 General Coding Help 4 707 Jan-14-2024, 03:44 AM
    Thread: Python code to set column width
Post: Python code to set column width

Hi, I have tried several codes to set my column widths without success. Is there a simple code similar to VBA I could use? I would like to add column widths to the code I am building below. Do I need ...
1418 General Coding Help 11 1,521 Jan-14-2024, 03:31 AM

User Panel Messages

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