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

asked 2020-01-16 08:57:52 +0100

Xander gravatar image

updated 2020-01-16 15:45:55 +0100

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>

edit retag flag offensive close merge delete

Comments

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.

Regina gravatar imageRegina ( 2020-01-16 15:19:24 +0100 )edit

Did not work sorry.

Xander gravatar imageXander ( 2020-01-16 15:42:30 +0100 )edit
1

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.

Regina gravatar imageRegina ( 2020-01-16 16:40:10 +0100 )edit