Convert Excel To Xrdml High Quality [2021] < Windows >

The GPS sensor driver suite for Windows.



GPSDirect allows you to reuse your legacy GPS source, such as a COM port device and map it to a Windows GPS Sensor for your apps that are GPS sensor-aware (Maps, etc).

GPSReverse does the reverse, maps a Sensor as a virtual COM port. It is useful for legacy apps ato use a sensor which exists in modern PCs.

The Transfer Tool transfers information from and to these drivers.

Driver Features

GPSDirect

  • From legacy COM port or bluetooth GPS to Windows Sensor.
  • Also allows simulation, injection, fixed and IP:Port mode.
  • Supported Sensors output: X, Y, Z, HDOP, VDOP, PDOP, NSAT, Speed, True Heading, Fix Quality, Satellite Information.
  • Sensor-API compatible (The CLSID for the ISensor (for developers) is {800EE0CB-71EC-40f0-991C-7E76BFABD1AF}).
  • Location API compatible

GPSReverse

  • From Windows Sensor to COM port GPS.
  • Also supports injection and ILocation.
  • COM port compatible.

Transfer Tool

  • Transfer data from GPSDirect, GPSReverse, ILocation, TCP Client, TCP/UDP Server, Plugin DLL.
  • Transfer data to GPSDirect, GPSReverse, TCP Server, Location, Plugin DLL, Set PC Time.

All drivers

  • No reboot install/uninstall.
  • Command line API.
  • Sensor Testing Tools.
  • Automatic updates.

Download

Windows 10/11 x64 (New Interface)

Download Windows 10/11 x64

Windows 7-11 x64

Download Windows 7-11 x64

Windows 7-11 x86

Download Windows 7-11 x86



The drivers come with an evaluation license (if you only use the Simulation or Fixed modes, you will be granted a license for free as long as you mention the driver in your site/blog). If you want a standard license, please select one of the two options below. Before purchasing, try the evaluation versions to verify that they work with your hardware. If they do not work with your hardware, do not purchase, but contact us instead.


License



PayPal Personal payments are usually instantly processed, so if you do not receive a mail from us in the next 24 hours, check your spam folder or contact me via the Business Contact.


GPSDirect + GPSReverse (Bundle)
EUR 14,99
convert excel to xrdml high quality
GPSDirect
EUR 9,99
convert excel to xrdml high quality
GPSReverse
EUR 9,99
convert excel to xrdml high quality


If you want to obtain a license that allows you to use GPSDirect or GPSReverse in your apps or redistribute it as a company or for mass redistribution or for C++ source code licensing, then contact me via the Business Support here.







Support

Errors with GPSDirect

Have I tested the COM port for actual GPS Data in NMEA format? You should see NMEA messages that start with $GPGGA, $GPRMC, $GPGSV etc.

Have I checked c:\windows\inf\setupapi.dev.log for installation errors?

Do I need the transfer tool in case where direct connection fails? (Install with Injection mode).

Errors with GPSReverse

Is GPSReverse correctly installed? Test with a COM port tool, you should see NMEA messages.

Have I checked c:\windows\inf\setupapi.dev.log for installation errors?

Do I need the transfer tool in case where direct connection fails? (Install with Client mode).

Am I trying to use the COM port from multiple applications. Install with the multithreading mode on.

Request a business license that allows you to use GPSDirect or GPSReverse in your apps or redistribute it as a company or for mass redistribution or for C++ source code licensing in the Business Support here.

Convert Excel To Xrdml High Quality [2021] < Windows >

Go to File > Save As and select from the dropdown list. 4. Quality Control: Validating Your Converted File

In the world of X-ray diffraction (XRD), data integrity is paramount. While Excel is the go-to tool for managing experimental data, proprietary software for analysis (like Malvern Panalytical’s HighScore Plus ) requires the format to function at its best.

import pandas as pd import xml.etree.ElementTree as ET from xml.dom import minidom def convert_excel_to_xrdml(excel_path, output_path): # 1. Read metadata and data from Excel meta_df = pd.read_excel(excel_path, nrows=5, header=None) data_df = pd.read_excel(excel_path, skiprows=10) # Assumes data starts at row 11 sample_id = str(meta_df.iloc[0, 1]) wavelength = str(meta_df.iloc[1, 1]) start_2theta = float(meta_df.iloc[2, 1]) end_2theta = float(meta_df.iloc[3, 1]) # Extract data columns twotheta = data_df.iloc[:, 0].tolist() intensities = data_df.iloc[:, 1].astype(int).astype(str).tolist() # 2. Build the XRDML XML Structure root = ET.Element("xrdMeasurement", "xmlns": "http://panalytical.com", "status": "Completed" ) # Sample Information sample = ET.SubElement(root, "sample") id_tag = ET.SubElement(sample, "id") id_tag.text = sample_id # Scan Setup scan = ET.SubElement(root, "scan", "scanAxis": "Gonio", "mode": "Continuous") # Explicitly define 2-Theta positions positions = ET.SubElement(scan, "positions", "axis": "2Theta", "unit": "deg") start_pos = ET.SubElement(positions, "startPosition") start_pos.text = f"start_2theta:.4f" end_pos = ET.SubElement(positions, "endPosition") end_pos.text = f"end_2theta:.4f" # Append Intensity Array data_points = ET.SubElement(scan, "dataPoints") intensities_tag = ET.SubElement(data_points, "intensities", "unit": "counts") intensities_tag.text = " ".join(intensities) # 3. Pretty-print and save with UTF-8 encoding xml_str = ET.tostring(root, encoding="utf-8") parsed_xml = minidom.parseString(xml_str) pretty_xml = parsed_xml.toprettyxml(indent=" ") with open(output_path, "w", encoding="utf-8") as f: f.write(pretty_xml) print(f"Success: High-quality XRDML file generated at output_path") # Example execution # convert_excel_to_xrdml("powder_pattern.xlsx", "output_pattern.xrdml") Use code with caution. 4. Method 2: Native Excel-to-XML Mapping (No-Code Approach)

Load the file into Malvern Panalytical HighScore Plus or Bruker EVA. If the software prompts an error regarding missing metadata, check that your wavelength and step size configurations match standard instrument definitions. Alternative: Using GUI-Based Converters

The core of your Excel data—usually 2-Theta positions and Intensity counts—resides here. convert excel to xrdml high quality

High-quality XRDML formats do not explicitly write the 2-Theta value for every single data point. Instead, they optimize data density by defining a start position, an end position, and the number of steps. The intensities are then written as a continuous, space-delimited string. 2. Preparing and Formatting Your Excel Sheet

: This is the most reliable method for "high quality" results as it preserves necessary metadata. You can configure it to recognize Excel files by navigating to Customize > Program Settings > Automatic Processing . Under "additionally supported file extensions," manually add .csv , .xlsx , or .xls . Once added, you can open the Excel file and "Save As" an .xrdml file.

| Column A (2θ) | Column B (Intensity) | |---------------|----------------------| | 10.0000 | 1254 | | 10.0050 | 1289 | | 10.0100 | 1301 | | ... | ... |

Refer to the XRD-Converter GitHub for existing scripts that automate these workflows. Why High-Quality Mapping Matters Go to File > Save As and select from the dropdown list

XRDML is an XML-based format that preserves raw intensities, instrument settings, and scan metadata. Converting data from spreadsheet cells to a highly structured XML schema requires precision. A poor conversion can result in corrupted files, lost metadata, or misaligned peaks.

If you need a or a VBA macro to convert directly from Excel without Python, let me know.

Before diving into the conversion process, it is essential to understand the target format. The XRDML file format, introduced by Malvern Panalytical (formerly PANalytical), is specifically designed to store X‑ray powder diffraction measurements. It is an XML‑based, open ASCII format, meaning the data is stored in plain text which is both human‑readable and machine‑readable. This structure allows an XRDML file to contain not only the measurement data (angles and intensities) but also the complete metadata required to reproduce the experiment, including the instrument type, settings, and sample information. For this reason, XRDML is considered a high‑fidelity format that facilitates data sharing and long‑term storage.

If you have a license for HighScore Plus, follow the steps in Section 2 to ensure your software can read CSV files. Once configured, open your .csv file directly from within HighScore Plus. While Excel is the go-to tool for managing

| Aspect | Low-Quality Conversion | High-Quality Conversion | |--------|----------------------|--------------------------| | 2θ values | Rounded, missing points | Full precision, original step size | | Intensity counts | Truncated integers | Preserved as measured | | Metadata | None or generic | Complete (tube, detector, scan speed, etc.) | | Compatibility | Errors in DIFFRAC.EVA, HighScore, Malvern Panalytical software | Seamless import, full analysis ready |

To ensure this conversion process integrates seamlessly with your current workflow, please let me know:

A newer, web-based platform developed by researchers at CVUT that allows users to batch-convert files like .xy directly into .xrdml for use in online diffraction calculations.


Our Clients



A lot of major-scale clients use our drivers.
Some of them:


Ponsse Plc
Natural Sesources Solutions
Evident Scientific
Shenandoah Valley Electric Cooperative
Arkansas Utility Protection Services
Arric's Propane
Ncc UAE
Fortress Technologies LLC
City of Irving
Taylor Electric
Eddyfi
Openrail
Probe Technologies
Brabant Water
Société de l’assurance automobile du Québec
NSPower
Orange and Rockland
Central Valley Ag
Western Australia Public Transport Authority
Beloeil Suburb
Southern States Cooperative
EOS GNSS
AGL Macquarie
ÖAMTC
Ads-Tec Industrial IT GmbH
CenterPoint Energy
Idaho Power
Oklahoma State University Police
NewFoundland Power
KaigaiSoft-DENSO CORP
Emergent Health Patterns
MarkWest Energy Partners
Compass Com
EnBridge Inc
New Mexico State LandOffice
Enterprise GIS
Koln-Bonn Flughafen
Royal Automobile Club
BSNF Railyway
MFA Oil
Denmark Ambulances
Wake Country
County Prairie
UMS
Mildura Rural City Council
Avitech GmbH
SAP Owner Networks
NOVARA GeoSolutions
Alnet Ltd
Nustar
Douglas Guardian
RAG Montan Immobilien
TECO Energy
Telematic GPS
GCR Inc
Forest Resource Division
Central County Emergency
Fagus Forest TASS
Tandler
State Line Propane LLC
Dap Technology
Xplorer Tech
Midwest Surveys
MapTek
sixData GmbH
Wireless Networks Surveying Software
ICF International