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
  {SOLVED]Help getting formula value in Excel to a csv Pedroski55 1 90 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 369 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 288 Jul-07-2021, 02:06 PM
Last Post: Marbelous
  Importing text file into excel spreadsheet with formatting david_dsmn 1 615 Apr-05-2021, 10:21 PM
Last Post: david_dsmn
  How to append a value to specific excel cell using openpyxl hobbyist 0 1,321 Mar-05-2021, 07:14 PM
Last Post: hobbyist
  Append excel sheet using openpyxl TammyP 1 592 Feb-02-2021, 06:32 PM
Last Post: nilamo
  Openpyxl tkinter search a value in Excel column Heathcliff_1 0 947 Dec-02-2020, 04:35 PM
Last Post: Heathcliff_1
  Reading from Excel: value not formula! faryad13 0 826 Oct-28-2020, 09:52 PM
Last Post: faryad13
  Formatting Data/Time with Pyodbc and openpyxl bearcats6001 0 830 Aug-17-2020, 03:44 PM
Last Post: bearcats6001
  Convert Excel to CSV and retain formatting slider09 5 1,150 Jul-24-2020, 10:36 AM
Last Post: Gribouillis

Forum Jump:

User Panel Messages

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