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
  Openpyxl tkinter search a value in Excel column Heathcliff_1 0 171 Dec-02-2020, 04:35 PM
Last Post: Heathcliff_1
  Reading from Excel: value not formula! faryad13 0 183 Oct-28-2020, 09:52 PM
Last Post: faryad13
  Formatting Data/Time with Pyodbc and openpyxl bearcats6001 0 319 Aug-17-2020, 03:44 PM
Last Post: bearcats6001
  Convert Excel to CSV and retain formatting slider09 5 607 Jul-24-2020, 10:36 AM
Last Post: Gribouillis
  Increment formula Kristenl2784 4 436 Jul-20-2020, 10:14 PM
Last Post: Kristenl2784
  Why is one duplicate not removed? Emekadavid 4 453 Jun-09-2020, 06:34 PM
Last Post: perfringo
  openpyxl - How can I copy some row from an excel file and paste them in another one? aquerci 2 1,363 Jun-07-2020, 04:26 AM
Last Post: buran
  else condition not called when if condition is false Sandz1286 10 1,421 Jun-05-2020, 05:01 PM
Last Post: ebolisa
  [HELP] Nested conditional? double condition followed by another condition. penahuse 25 1,552 Jun-01-2020, 06:00 PM
Last Post: penahuse
  How can I speed up my openpyxl program reading Excel .xlsx files? deac33 0 614 May-04-2020, 08:02 PM
Last Post: deac33

Forum Jump:

User Panel Messages

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