combine multiple xlsx files which include dropdown columns in them.
hongy...@gmail.com
hongyi.zhao at gmail.com
Wed Sep 8 22:31:09 EDT 2021
On Thursday, September 9, 2021 at 9:15:23 AM UTC+8, Kushal Kumaran wrote:
> On Tue, Sep 07 2021 at 10:05:58 PM, "hongy... at gmail.com" <hongy... 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
Thank you for your comments. For a related discussion on this topic, please refer to [1].
[1] https://groups.google.com/g/openpyxl-users/c/k2xnPZS2kbo/m/m2YmEO9ZBgAJ
Regards,
HY
More information about the Python-list
mailing list