Convert Xrdml To Excel -

# Extract the data data = [] for elem in root.findall('.// diffractionPattern'): data.append([elem.find('2theta').text, elem.find('intensity').text])

:

To keep metadata, create a second sheet in Excel with that information manually. convert xrdml to excel

Unlike a simple spreadsheet, an XRDML file is a nested document. It contains not just the raw counts, but also "headers" detailing the wavelength, instrument settings, and scanning parameters. A simple "open with" command in Excel often results in a cluttered mess of tags ( ) rather than clean columns. Recommended Tools for Conversion # Extract the data data = [] for elem in root