Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: How to compare two columns and highlight the unique values of column two using pandas
Post: How to compare two columns and highlight the uniqu...
I was using following conditional formatting code but it is not working : #Data_analysis_std is excel file name #pd is pandas object writer = pd.ExcelWriter('Data_Analysis_Std.xlsx', engine ='openpyx...
 shubhamjainj General Coding Help 0 4,282 Feb-24-2020, 06:19 AM
    Thread: Run macros of excel sheet from python scripts
Post: RE: Run macros of excel sheet from python scripts
Thanks for the reply. I tried above code still getting the same error. Error:Traceback (most recent call last): File "C:\Users\username\AppData\Local\Programs\Python\Python37\macro_call.py", line 25...
 shubhamjainj General Coding Help 3 10,454 May-01-2019, 05:31 AM
    Thread: Run macros of excel sheet from python scripts
Post: Run macros of excel sheet from python scripts
Hello, I am getting the following error while running the macro using python scripts Error:Traceback (most recent call last): File "C:\Users\username\AppData\Local\Programs\Python\Python37\macro_ca...
 shubhamjainj General Coding Help 3 10,454 May-01-2019, 03:34 AM
    Thread: Openpyxl - When save existing xlsx sheet, images/drawing does not get saved
Post: RE: Openpyxl - When save existing xlsx sheet, imag...
Thanks for the update. Could you please point out, if their is any other possible way to make this work. Maybe by using some other packages..
 shubhamjainj General Coding Help 2 8,447 Apr-16-2019, 07:09 AM
    Thread: Openpyxl - When save existing xlsx sheet, images/drawing does not get saved
Post: Openpyxl - When save existing xlsx sheet, images/d...
Openpyxl - After modifying existing xlsx sheet with some drawings/images, when saved already existing images and drawings does not get saved. I am new to python, please let me know is this expected b...
 shubhamjainj General Coding Help 2 8,447 Apr-16-2019, 04:18 AM
    Thread: Openpyxl - while saving excel file getting error
Post: Openpyxl - while saving excel file getting error
Vml = fromstring(self.workbook.vba.archive.read(ws.legacy_drawing)) AttributeError: 'Nonetype' object has no attribute 'read' Getting this error when try to save data in xlsx file. Can anyone pls he...
 shubhamjainj General Coding Help 1 4,575 Apr-09-2019, 11:11 AM
    Thread: Getting error while loading excel(.xlsx) file using openpyxl module
Post: Getting error while loading excel(.xlsx) file usin...
Hi, import openpyxl #Path of workBook path = "C:\\***\\python_sheet.xlsx" #Load worksheet from the directory(path) wb = openpyxl.load_workbook(path)Getting following error while loading excel file f...
 shubhamjainj General Coding Help 1 8,965 Mar-01-2019, 09:41 AM
    Thread: Value error when converting hex value to bytearray
Post: RE: Value error when converting hex value to bytea...
Ok Thanks, will check
 shubhamjainj General Coding Help 7 10,491 Mar-01-2019, 06:20 AM
    Thread: Value error when converting hex value to bytearray
Post: Value error when converting hex value to bytearray
Hi, I am getting ValueError: non-hexadecimal number found in fromhex() arg at position 7. Below is the code : Cmd1 = bytearray.fromhex("08 22 1 0 1 0 D4"); Please let me know how to solve this issue
 shubhamjainj General Coding Help 7 10,491 Mar-01-2019, 06:02 AM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020