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


Messages In This Thread
Openpyxl: Excel formula & condition formatting removed - by JaneTan - Sep-25-2020, 07:02 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  {SOLVED]Help getting formula value in Excel to a csv Pedroski55 1 116 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 377 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 296 Jul-07-2021, 02:06 PM
Last Post: Marbelous
  Importing text file into excel spreadsheet with formatting david_dsmn 1 621 Apr-05-2021, 10:21 PM
Last Post: david_dsmn
  How to append a value to specific excel cell using openpyxl hobbyist 0 1,338 Mar-05-2021, 07:14 PM
Last Post: hobbyist
  Append excel sheet using openpyxl TammyP 1 605 Feb-02-2021, 06:32 PM
Last Post: nilamo
  Openpyxl tkinter search a value in Excel column Heathcliff_1 0 954 Dec-02-2020, 04:35 PM
Last Post: Heathcliff_1
  Reading from Excel: value not formula! faryad13 0 833 Oct-28-2020, 09:52 PM
Last Post: faryad13
  Formatting Data/Time with Pyodbc and openpyxl bearcats6001 0 839 Aug-17-2020, 03:44 PM
Last Post: bearcats6001
  Convert Excel to CSV and retain formatting slider09 5 1,159 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