I have an xlsx file that contains a dropdown list with almost 150 entries.I am to create a Database table with each of these entries as an row in it.How can I get the entries?
@JohnSUN – Could you turn your comment into a question for resolution, please? (I don’t see an easy way to test your solution myself, as I don’t have XLSX documents w/drop-downs, but perhaps @rajeevs or someone else can verify
@qubit1 - I’m still not sure I answered the question that was asked. I am confused by references to Databases in the description of the problem
You have to use BASIC for this:
CellRange.Validation.Formula1
would give you something like “A”;“B”;“C”;“D”
http://www.oooforum.org/forum/viewtopic.phtml?p=341161#341161