| Problem | Likely Cause | Solution | |---------|--------------|----------| | "Invalid XML" | Missing XML declaration line | Add <?xml version="1.0"?> at top | | "No data points found" | Using commas instead of semicolons in data string | Replace commas with semicolons | | "Axis error" | First column not strictly increasing | Sort rows by 2θ in Excel before conversion | | "Negative intensity" | Background subtraction created negative values | Set negative values to 0 or add offset |
The converter must map Excel column A to <positions> and column B to <intensities> , formatting them as space-separated strings, not comma-separated lists. The number of values must match exactly. convert excel to xrdml
) and the intensity (counts)—are free of headers or non-numeric characters that could break a conversion script. | Problem | Likely Cause | Solution |