Seite 1 von 1

Problem mit dem html/xhtml Export aus Calc

Verfasst: Mi 15. Jun 2011, 16:44
von Muckel
Guten Tag zusammen,

mit LibreOffice Calc habe ich eine Tabelle erzeugt, in der ich am Anfang nur Blutwerte und deren Einheiten vergleichen möchte, später soll in einem zweiten Tabellen-Blatt die Werte gesammelt werden.

Um die Werte zu Vergleichen und diese Übersicht mit anderen zu teilen, wollte ich sie gerne online stellen, wozu ich eben eine HTML-Tabelle benötige. Der Export von Calc ist ziemlich aufgebläht:

Code: Alles auswählen

<html xmlns="http://www.w3.org/1999/xhtml">
<head profile="http://dublincore.org/documents/dcmi-terms/">
<!--This file was converted to xhtml by OpenOffice.org - see http://xml.openoffice.org/odf2xhtml for more info.-->
<meta http-equiv="Content-Type"
content="application/xhtml+xml; charset=utf-8" />
<title xml:lang="en-US">- no title specified</title>
<meta name="DCTERMS.title" content="" xml:lang="en-US" />
<meta name="DCTERMS.language" content="en-US" scheme="DCTERMS.RFC4646" />
<meta name="DCTERMS.source"
content="http://xml.openoffice.org/odf2xhtml" />
<meta name="DCTERMS.creator" content="Tobias Müller" />
<meta name="DCTERMS.issued" content="2011-06-15T11:11:38"
scheme="DCTERMS.W3CDTF" />
<meta name="DCTERMS.contributor" content="Tobias Müller" />
<meta name="DCTERMS.modified" content="2011-06-15T15:44:00"
scheme="DCTERMS.W3CDTF" />
<meta name="DCTERMS.provenance" content="" xml:lang="en-US" />
<meta name="DCTERMS.subject" content="," xml:lang="en-US" />
<link rel="schema.DC" href="http://purl.org/dc/elements/1.1/"
hreflang="en" />
<link rel="schema.DCTERMS" href="http://purl.org/dc/terms/"
hreflang="en" />
<link rel="schema.DCTYPE" href="http://purl.org/dc/dcmitype/"
hreflang="en" />
<link rel="schema.DCAM" href="http://purl.org/dc/dcam/" hreflang="en" />
<base href="." />
<style type="text/css">
@page { }
table { border-collapse:collapse; border-spacing:0; empty-cells:show }
td, th { vertical-align:top; font-size:10pt;}
h1, h2, h3, h4, h5, h6 { clear:both }
ol, ul { margin:0; padding:0;}
li { list-style: none; margin:0; padding:0;}
<!-- "li span.odfLiEnd" - IE 7 issue-->
li span. { clear: both; line-height:0; width:0; height:0; margin:0; padding:0; }
span.footnodeNumber { padding-right:1em; }
span.annotation_style_by_filter { font-size:95%; font-family:Arial; background-color:#fff000; margin:0; border:0; padding:0; }
* { margin:0;}
.ta1 { writing-mode:lr-tb; }
.Default { font-family:Arial; font-size:12pt; }
.ce10 { font-size:12pt; font-family:Arial; vertical-align:middle; text-align:center ! important; }
.ce11 { font-size:12pt; font-family:Georgia; background-color:transparent; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce12 { font-size:12pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce13 { font-size:12pt; font-family:Arial; }
.ce14 { font-size:10pt; font-family:Georgia; background-color:transparent; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce15 { font-size:10pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; text-decoration:none ! important; font-weight:normal; }
.ce16 { font-size:10pt; font-family:Georgia; background-color:transparent; vertical-align:middle; text-align:left ! important; font-weight:normal; }
.ce17 { font-size:10pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; text-decoration:none ! important; font-weight:bold; }
.ce18 { font-size:12pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce19 { font-size:20pt; font-family:Arial; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; font-weight:bold; }
.ce20 { font-size:12pt; font-family:Arial; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; }
.ce21 { font-size:12pt; font-family:Georgia; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; }
.ce22 { font-size:12pt; font-family:Arial; border-style:none; vertical-align:middle; text-align:center ! important; }
.ce23 { font-size:12pt; font-family:Arial; }
.ce24 { font-size:10pt; font-family:Georgia; background-color:transparent; border-style:none; vertical-align:middle; text-align:center ! important; font-weight:bold; }
.ce25 { font-size:10pt; font-family:Georgia; background-color:transparent; border-style:none; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce26 { font-size:10pt; font-family:Georgia; background-color:transparent; border-style:none; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce3 { font-size:20pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; text-decoration:none ! important; font-weight:bold; }
.ce4 { font-size:14pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; text-decoration:none ! important; font-weight:bold; }
.ce5 { font-size:12pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:left ! important; font-weight:bold; }
.ce6 { font-size:12pt; font-family:Arial; vertical-align:middle; text-align:left ! important; }
.ce7 { font-size:12pt; font-family:Georgia; background-color:transparent; vertical-align:middle; text-align:left ! important; font-weight:bold; }
.ce8 { font-size:12pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; text-decoration:none ! important; font-weight:normal; }
.ce9 { font-size:12pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; font-weight:bold; }
.co2 { width:5.001cm; }
.co3 { width:2.499cm; }
.co4 { width:4.001cm; }
.co5 { width:2.267cm; }
.co6 { width:3cm; }
.ro2 { height:0.536cm; }
.ro3 { height:1.499cm; }
.T1 { font-weight:normal; }
<!-- ODF styles with no properties representable as CSS -->
{ }
</style>
</head>
<body dir="ltr" style="margin: 1cm; max-width: 42cm;">
<table class="ta1" border="0" cellpadding="0" cellspacing="0">
<colgroup><col width="219" /><col width="109" /><col width="109" /><col
width="109" /><col width="109" /><col width="109" /><col width="109" /><col
width="109" /><col width="109" /><col width="109" /><col width="109" /><col
width="109" /><col width="109" /><col width="219" /><col width="175" /><col
width="131" /><col width="131" /><col width="131" /><col width="131" /><col
width="131" /><col width="99" /><col width="99" /><col width="99" /><col
width="99" /></colgroup><tbody>
<tr class="ro3">
<td colspan="2" style="text-align: left; width: 5.001cm;"
class="ce3">
<p>Laborwerte</p>
</td>
<td colspan="2" rowspan="2"
style="text-align: left; width: 2.499cm;" class="ce3">
<p>Einheiten aus Berichten</p>
</td>
<td colspan="4" style="text-align: left; width: 2.499cm;"
class="ce3">
<p>Einheiten aus dem Buch</p>
</td>
<td colspan="2" rowspan="2"
style="text-align: left; width: 2.499cm;" class="ce3">
<p>Normal-werte aus Berichten</p>
</td>
<td colspan="3" style="text-align: left; width: 2.499cm;"
class="ce3">
<p>Normalwerte aus dem Buch</p>
</td>
<td rowspan="2" style="text-align: left; width: 5.001cm;"
class="ce19">
<p>Notizen</p>
</td>
<td style="text-align: left; width: 4.001cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce26">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce26">&nbsp;</td>
</tr>
<tr class="ro3">
<td style="text-align: left; width: 5.001cm;" class="ce4">
<p>Name</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Kürzel</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Alte</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Alt in Neu</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Neue</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Neu in Alt</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Alter</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Alt in Neu</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Neuer</p>
</td>
<td style="text-align: left; width: 4.001cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce26">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce26">&nbsp;</td>
</tr>
<tr class="ro3">
<td style="text-align: left; width: 5.001cm;" class="ce5">
<p>ACE</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce9">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">
<p>U/l</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 5.001cm;" class="ce21">&nbsp;</td>
<td style="text-align: left; width: 4.001cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce14">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
</tr>
<!-- Hier waere mehr Inhalt... -->
<tr class="ro3">
<td style="text-align: left; width: 5.001cm;" class="ce5">
<p>TSH</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce9">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">
<p>mU/l</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">
<p>mcU/ml</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">
<p>0,4-4,0</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 5.001cm;" class="ce21">&nbsp;</td>
<td style="text-align: left; width: 4.001cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce14">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
</tr>
<tr class="ro3">
<td style="text-align: left; width: 5.001cm;" class="ce5">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce9">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 5.001cm;" class="ce21">&nbsp;</td>
<td style="text-align: left; width: 4.001cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce14">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
</tr>
</tbody>
</table>
Doch ich bevorzuge dies schlankere, reine xhtml-Tabelle:

Code: Alles auswählen

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="author" content="Tobias M&uuml;ller">
	<meta name="description" content="&Uuml;bersicht der Laborwerte mit den Einheiten und Normalwerten um sie Vergleichen und umrechnen zu k&ouml;nnen.">
	<meta name="keywords" lang="de" content="Labor,Laborwerte,Blut,Blutbild,Entzuendungswete">
	<meta http-equiv="content-language" content="de">
	<meta name="robots" content="all">
	<title>&Uuml;bersicht der Laborwerte mit den Einheiten und Normalwerten</title>
	<!-- Style-Sheet Anfang -->
		<!-- <link href="style.css" rel="stylesheet" type="text/css" /> -->
	<!-- Style Sheet Ende -->
</head>
<body>
<h1>&Uuml;bersicht der Laborwerte mit den Einheiten und Normalwerten</h1>
<p>Evtl. etwas Text...</p>
<table border="1" cellpadding="1" cellspacing="1" style="margin:0.5em;">
  <thead>
   <tr>
    <th colspan="2">Laborwerte</th>
    <th colspan="2" rowspan="2">Einheiten aus Berichten</th>
    <th colspan="4">Einheiten aus dem Buch</th>
    <th colspan="2">Normalwerte aus Berichten</th>
    <th colspan="3">Normalwerte aus dem Buch</th>
    <th rowspan="2">Notizen</th>
  </tr>
  <tr>
    <th>Name</th>
    <th>K&uuml;rzel</th>
    <th>Alte</th>
    <th>Alt in Neu</th>
    <th>Neue</th>
    <th>Neu in Alt</th>
    <th>Variante 1</th>
    <th>Variante 2</th>
    <th>Alter</th>
    <th>Alt in Neu</th>
    <th>Neuer</th>
  </tr>
  </thead> <tbody>
    <tr>
      <td>ACE</td>
      <td>&nbsp;</td>
      <td>U/l</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;8</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
    <td>Albumine</td>
    <td>&nbsp;</td>
    <td>%</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>55,8-66,1</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>alk. Phosph</td>
    <td>&nbsp;</td>
    <td>U/l</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>40-130</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
<!-- Hier waere noch mehr Inhalt -->
  <tr>
    <td>x</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</tbody>
<tfoot>
  <tr>
    <td colspan="14" align="center"><small>Diese Liste wurde von Tobias zusammengestellt und wird zur Zeit noch ergänzt.</small></td>
  </tr>
</tfoot>
</table>
<p>Evtl. nochmal Text...</p>
</body>
</html>
Hoffe ihr könnt mir einen Tipp geben, wie sich das anstellen lässt!

Lieben Gruß Tobias

Re: Problem mit dem html/xhtml Export aus Calc

Verfasst: Fr 17. Jun 2011, 09:50
von karolus
Hallo

Ich würde den Original-Html-Export aus Calc wegwerfen, und stattdessen dein xhtml_template per Script mit den Daten aus der Tabelle "befüllen".

Gruß Karo