On Tue, Sep 07 2021 at 10:05:58 PM, "hongy...@gmail.com" <hongyi.z...@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 -- https://mail.python.org/mailman/listinfo/python-list
