How do you open an xml with an Excel stylesheet (xsl) workbook in Calc?

[Xander]

Hi there

I am not an advanced user. I receive data from an instrument saved as xml and I view the data by opening it with MS Excel and a .xsl stylesheet provided with the instrument.

I prefer working in Calc. How do I proceed to retrieve the xml data in a format that is similar to that which I get by using the stylesheet? I think I might have to create a Calc type of “stylesheet” or format to interpret the XML data?

Thank you

This is the first few lines of the text, I had to remove the “<” sign at the start:

xml version=“1.0” encoding=“ISO-8859-1”?>
xsl:stylesheet version=“1.0”
xmlns:xsl=“http://www.w3.org/1999/XSL/Transform”>
xsl:output method=“html”/>x
sl:template match="/">’

HTML>
HEAD>
STYLE>
.HDR { background-color:#0b3568;font-weight:bold;color:#ffffff }
#table-alt tbody tr:nth-child(even) {
background-color:rgb(231, 235, 240);
}
#table-alt tbody tr:nth-child(odd) {
background-color: transparent;
}
.contRow { border-down:thin solid black }
.listRow { }
.smalllistRow { font-size:80%; }
.HR { page-break-before: always }
.listAvgRow { text-decoration: Overline }
/STYLE>
/HEAD>

[Regina]

Have you already tried to open the file using the filter “Microsoft Excel 2003 XML”. It is near the end of the list of spreadsheet filters.

[Xander]

Did not work sorry.

[Regina]

Tools > ‘XML Filter Settings’ gives access to filters. You might need to make your own new filter using the given XSL file. But I’m not familiar with that area. A search with “libreoffice xsl import filter” might result in some useful guides.