Read information from selext box / combo box? #1197

Activity

1. Austin1990 commented on May 19, 2023

   

   Austin1990

   on May 19, 2023

   Last edited by scanny

   More actions

   You need to follow the method in this post:

   python-docx get info from dropdownlist (in table) - Stack Overflow

   The word\document.xml file in your document contains this structure from which you can extract the information you need :

   <w:sdt>
     <w:sdtPr>
       <w:alias w:val="Entered by"/>
       <w:id w:val="1433320977"/>
       <w:dropDownList>
         <w:listItem w:displayText="Job entered by" w:value="Job entered by"/>
         <w:listItem w:displayText="Mark" w:value="Mark"/>
         <w:listItem w:displayText="Chooky" w:value="Chooky"/>
         <w:listItem w:displayText="Steve" w:value="Steve"/>
         <w:listItem w:displayText="Lisa" w:value="Lisa"/>
       </w:dropDownList>
     </w:sdtPr>
     <w:sdtContent>
       <w:r w:rsidR="004B3CEC">
         <w:t>Lisa</w:t>
       </w:r>
     </w:sdtContent>
   </w:sdt>
   
2. Austin1990 commented on May 19, 2023

   

   Austin1990

   on May 19, 2023

   Last edited by Austin1990

   More actions

   Managed to produce some sample code:

   import docx
   import zipfile
   from bs4 import BeautifulSoup as bs
   
   try:
       file = 'inp.docx'
       doc = docx.Document(file)
       ddl = doc.tables
       for idxT,table in enumerate(doc.tables):
           for idxR, row in enumerate(table.rows):
               for idxC, cell in enumerate(row.cells):
                   for idxP, para in enumerate(cell.paragraphs):
                       print(f'para {para.text}')
   
       # get data from the dropdown lists
       document = zipfile.ZipFile(file)
       xml_data = document.read('word/document.xml')
       document.close()
   
       soup = bs(xml_data, 'xml')
       ddlists = soup.findAll('dropDownList')
       for ddl in ddlists:
           ddl_parent = ddl.parent
           ddl_parent_entries = list(ddl_parent.children)
           for ddl_parent_entry in ddl_parent_entries:
               val = ddl_parent_entry.get('w:val')
               if val and 'Entered by' in val:
                   ddl_entries = list(ddl.children)
                   names = []
                   for entry in ddl_entries:
                       names.append(entry.get('w:displayText'))
                   sibling = ddl_parent.next_sibling
                   select = sibling.findNext('w:t')
                   selected = select.get_text()
   
       print(f'List of names: {names}')
       print(f'Name selected: {selected}')
   
   except:
       print("Error")
   
3. scanny

   added

   sdtStructured Document Tags (forms)Structured Document Tags (forms)

   on Sep 24, 2023