I am trying to convert a .xls file containing several worksheets (the first worksheets is a table of contents with links to the other worksheets) into a .html file using the soffice utility from LibreOffice on RedHat 6.
I do as follows: soffice --invisible --convert-to html -outdir TestFile.xls
This creates TestFile.html. However the table of contents does not work in the generated .html page (the links are not generated correctly - they are changed into “./#LINKNAME”, as a result when I click on it, it looks for a file called “./#LINKNAME”). Also, all the worksheets on the generated html are displayed one below the other. Ideally, I would like to generate a html page looking similar to the original Excel file, with individual clickable tabs for each worksheet.