<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Headless conversion of HTML to XLS or XLSX not working"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132558">132558</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Headless conversion of HTML to XLS or XLSX not working
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kaktus.w.h@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
I try to batch convert HTML files to XLS or XLSX Excel files.
Using the GUI it works fine to import the HTML and then save it as any type.
However, via the terminal I ran into issues.
I tried following multiple suggestions
(<a href="https://stackoverflow.com/questions/30349542/command-libreoffice-headless-convert-to-pdf-test-docx-outdir-pdf-is-not">https://stackoverflow.com/questions/30349542/command-libreoffice-headless-convert-to-pdf-test-docx-outdir-pdf-is-not</a>,
<a href="https://stackoverflow.com/questions/22062973/libreoffice-convert-to-not-working">https://stackoverflow.com/questions/22062973/libreoffice-convert-to-not-working</a>,
<a href="https://stackoverflow.com/questions/52277264/convert-doc-to-docx-using-soffice-not-working">https://stackoverflow.com/questions/52277264/convert-doc-to-docx-using-soffice-not-working</a>),
but it does not work.
The commands I use:
`libreoffice6.4 --headless --convert-to xlsx:"Calc MS Excel 2007 XML"
filename.html`, which returns an "Application Error".
Similarly for libreoffice 6.0:
`soffice --headless --convert-to xlsx:"Calc MS Excel 2007 XML" filename.html`
If I try to convert to xls with any of the specified export filters
(<a href="https://cgit.freedesktop.org/libreoffice/core/tree/filter/source/config/fragments/filters">https://cgit.freedesktop.org/libreoffice/core/tree/filter/source/config/fragments/filters</a>):
`libreoffice6.4 --headless --convert-to xls:"MS Excel 95" filename.html`
`libreoffice6.4 --headless --convert-to xls:"MS Excel 97" filename.html`
`libreoffice6.4 --headless --convert-to xls:"MS Excel 2003 XML" filename.html`
`libreoffice6.4 --headless --convert-to xls:"MS Excel 2003 XML 0rcus"
filename.html`
It will throw "Error: Please verify input parameters...
(SfxBaseModel::impl_store [..]"
Other conversion such as CSV to HTML or CSV to XLS work just fine:
`libreoffice6.4 --headless --convert-to html hardware_tutorial_gold.csv`
`libreoffice6.4 --headless --convert-to xlsx hardware_tutorial_gold.csv`
I have additionally tried to use the in-filter `--infilter="HTML Document"`.
Reinstall libreoffice, update it, and several other hints. Nothing has solved
it. It seems to be related to the HTML input format. However, as it works over
the GUI, it should be possible via the CL.
Steps to Reproduce:
1. I have uploaded one HTML file for reproduction here:
<a href="https://ufile.io/zh40nkdb">https://ufile.io/zh40nkdb</a>, but for me it happened with any. Download an HTML
file.
2. Open a terminal in the folder where the file is stored
3. Run "libreoffice6.4 --headless --convert-to xlsx:"Calc MS Excel 2007 XML"
hardware_tutorial_gold.html"
Actual Results:
The console prints "Application Error".
Expected Results:
A new file in the current directory is created with the converted xlsx format
of the HTML file. Similarly to using the GUI.
Reproducible: Always
User Profile Reset: No
Additional Info:
Convert the file and not crash.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>