Python Forum
Openpyxl: Excel formula & condition formatting removed
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Openpyxl: Excel formula & condition formatting removed
#1
I need to read and write to an xlsm excel file. I used the below

import openpyxl
file='....xlsm'
wb=openpyxl.load_workbook(file, data_only=True, read_only=False, keep_vba=True)
But I get the warning "conditional formatting is not supported and will be removed"
In my xlsm file:

Some of my conditioning format get removed, but not all
My formula are also converted to values.
I noted that the conditional formatting and formula that are removed have links to another sheet in my xlsm file.

How do I solve this?
I can't use "data_only=False" as I need Python to read the values of some formula.
Thank you
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Help using a dynamic array excel formula with XLWings FXMonkey 2 1,210 Jun-06-2023, 09:46 PM
Last Post: FXMonkey
  Excel Automation using Openpyxl pradyumnajpn 1 771 May-16-2023, 09:38 AM
Last Post: Larz60+
  Openpyxl manipulate excel write formula SamLiu 0 1,002 Nov-04-2022, 03:00 PM
Last Post: SamLiu
  OpenPyXl formatting issues kpayney1 0 1,599 Nov-26-2021, 01:56 AM
Last Post: kpayney1
  {SOLVED]Help getting formula value in Excel to a csv Pedroski55 1 1,971 Sep-20-2021, 12:19 AM
Last Post: Pedroski55
  Python “Formula” Package: How do I parse Excel formula with a range of cells? JaneTan 1 2,642 Jul-12-2021, 11:09 AM
Last Post: jefsummers
  How do I read in a Formula in Excel and convert it to do the computation in Python? JaneTan 2 2,565 Jul-07-2021, 02:06 PM
Last Post: Marbelous
  Importing text file into excel spreadsheet with formatting david_dsmn 1 3,550 Apr-05-2021, 10:21 PM
Last Post: david_dsmn
  How to append a value to specific excel cell using openpyxl hobbyist 0 4,769 Mar-05-2021, 07:14 PM
Last Post: hobbyist
  Append excel sheet using openpyxl TammyP 1 2,315 Feb-02-2021, 06:32 PM
Last Post: nilamo

Forum Jump:

User Panel Messages

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