combine multiple xlsx files which include dropdown columns in them.
Kushal Kumaran
kushal at locationd.net
Wed Sep 8 21:05:16 EDT 2021
On Tue, Sep 07 2021 at 10:05:58 PM, "hongy... at gmail.com" <hongyi.zhao at gmail.com> wrote:
> I've some xlsx files which include dropdown columns in them. I want to
> know whether I can combine all the lines into one xlsx file. Any hints
> for doing this job with python programmatically will be highly
> appreciated.
>
The dropdown is *probably* implemented using Excel's data validation
mechanism. openpyxl's documentation says it can read[1]/write Excel
files and also mentions data validation[2]. You might be able to use it
to read the existing files, combine the rows and write to a different
file.
[1] https://openpyxl.readthedocs.io/en/stable/usage.html#read-an-existing-workbook
[2] https://openpyxl.readthedocs.io/en/stable/validation.html
--
regards,
kushal
More information about the Python-list
mailing list