I'm facing an issue reading the excel file with validation list

5,113 views
Skip to first unread message

Nayana Narasimha

unread,
May 24, 2019, 6:17:42 AM5/24/19
to openpyxl-users
This the waring:
 UserWarning: Data Validation extension is not supported and will be removed
  warn(msg)

I want read the file and update the content and retain the validation as well

Charlie Clark

unread,
May 24, 2019, 6:19:30 AM5/24/19
to openpyx...@googlegroups.com
Am .05.2019, 12:17 Uhr, schrieb Nayana Narasimha
<nayanana...@gmail.com>:

> This the waring:
>
> *UserWarning: Data Validation extension is not supported and will be
> removed
> warn(msg)*
>
>
> *I want read the file and update the content and retain the validation
> as well*

The warning is pretty clear: file contains a validation not covered by the
original OOXML specification, which is why it will be lost from the file.
There is currently no way around this.

Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226

Nayana Narasimha

unread,
May 24, 2019, 6:46:00 AM5/24/19
to openpyx...@googlegroups.com
Thanks for the update.

Is there any fix for this issue in the future?

--
You received this message because you are subscribed to the Google Groups "openpyxl-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openpyxl-user...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/openpyxl-users/op.z2ahmqn85mynk9%40fuchsia.fritz.box.
For more options, visit https://groups.google.com/d/optout.

Charlie Clark

unread,
May 24, 2019, 6:47:29 AM5/24/19
to openpyx...@googlegroups.com
Am .05.2019, 12:47 Uhr, schrieb Nayana Narasimha
<nayanana...@gmail.com>:

> Is there any fix for this issue in the future?

If someone writes it…
Reply all
Reply to author
Forward
0 new messages