Defines the measurement type (e.g., continuous, step scan) and active axis (2-Theta). : Contains the actual measurement values.
What (e.g., HighScore Plus, Match!, GSAS-II) will you use to open the generated XRDML?
: The critical node containing your numerical data. It nests (the independent variable, usually 2-Theta) and (the dependent variable, usually counts or counts per second). The DataPoints Structure
– compare numerical values (export back to CSV from XRDML and diff with original). convert excel to xrdml high quality
Save the following script as excel_to_xrdml.py . It reads structured Excel data, validates the step increments, and exports a fully compliant XRDML file.
Open your Excel file and go to File > Save As . Select Text (Tab delimited) (*.txt) or CSV (Comma delimited) (*.csv) . Rename the file extension from .txt or .csv to .xy or .asc .
Converting XY data from Excel to the XML-based XRDML format requires strict adherence to the schema definitions. To achieve a high-quality conversion, the process involves mapping spreadsheet columns to specific XML nodes (Start/End positions, Step size, and Intensities). Our method eliminates the common pitfalls of data truncation and header corruption, producing a robust XRDML file that retains the original resolution and provenance of your experiment. Defines the measurement type (e
# Save if output_path is None: output_path = excel_path.replace('.xlsx', '.xrdml').replace('.xls', '.xrdml')
The quality of your final XRDML file is directly dependent on the quality of your source data in Excel. Here are the critical steps to ensure success before you perform the conversion:
How to Convert Excel Data to XRDML Format with High Quality X-ray diffraction (XRD) data is frequently recorded, shared, or manipulated in Microsoft Excel. However, analytical software like Malvern Panalytical’s HighScore Plus requires specialized formats like XRDML. : The critical node containing your numerical data
If you are uncomfortable running code, you can use specialized intermediate freeware:
# Remove extra newlines before root (minidom adds one) pretty_xml = pretty_xml[pretty_xml.find('<?xml'):] if '<?xml' in pretty_xml else pretty_xml
Because modern XRD analysis software (GSAS-II, TOPAS, Profex) relies on .
Python allows you to read Excel files via pandas and generate an exact, valid XRDML schema. This method ensures that floating-point errors are eliminated and required metadata tags are explicitly written.
When you convert standard tabular .xlsx or .csv files into XRDML, maintaining high quality is paramount. A poor conversion can corrupt data metadata, alter step sizes, or render the file unreadable by analysis software like HighScore Plus.