Je souhaiterais savoir si il est possible de transformer ma facture HTLM (de iCompta) vers excel. Je veut faire sa car il m'est impossible de créer des bons de commande depuis iCompta et je voudrais que c'est document et le même modèle.
Code : Tout sélectionner
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<style type="text/css">
body
{
font-family: -apple-system;
font-size: 6pt;
font-weight: 200;
margin: 0pt;
}
.left
{
float: left;
margin-right: 20pt;
}
.right
{
float: right;
margin-left: 20pt;
}
.clear
{
clear: both;
}
table
{
width: 100%;
border-collapse: separate;
border-spacing: 0pt;
}
#border
{
height: 10pt;
margin-bottom: 20pt;
background-color: #80FF00;
}
#logo .title
{
display: inline;
margin-left: 10pt;
font-size: 28pt;
font-weight: 100;
}
#company
{
text-align: right;
}
#company .title
{
font-size: 14pt;
font-weight: 400;
text-transform: uppercase;
}
#company .value
{
font-size: 5pt;
font-weight: 100;
}
.separator
{
margin-top: 10pt;
margin-bottom: 10pt;
height:1pt;
background-color: #000000;
}
#invoice td
{
vertical-align: top;
}
#invoice tr.spacer td
{
padding-top: 10pt;
}
#invoice .title
{
font-size: 8pt;
font-weight: 400;
text-transform: uppercase;
}
#invoice .value
{
font-size: 8pt;
font-weight: 200;
}
#invoice .total
{
vertical-align: middle;
text-align: right;
}
#invoice .total div
{
display: inline;
}
#invoice .total .title
{
font-size: 14pt;
font-weight: 400;
}
#invoice .total .value
{
color: #80FF00;
font-size: 14pt;
font-weight: 400;
}
#content th
{
padding-left: 6pt;
color: #80FF00;
font-size: 8pt;
font-weight: 300;
text-transform: uppercase;
white-space: nowrap;
}
#content td
{
padding-left: 6pt;
padding-top: 6pt;
font-size: 6pt;
font-weight: 200;
white-space: nowrap;
}
#content th:first-child, #content td:first-child
{
padding-left: 0pt;
white-space: normal;
}
#content tr.total td
{
font-weight: 400;
}
.details
{
font-size: 4pt;
font-weight: 100;
}
.footer
{
margin-top: 20pt;
font-style: italic;
}
</style>
</head>
<body>
<div id="border"></div>
<div id="logo" class="left">
{% if company.logo %}<img src="data:image/png;base64,{{ company.logo }}" width="{{ company.logoWidth }}" height="{{ company.logoHeight }}">{% /if %}
<div class="title">{{ company.name }}</div>
</div>
<div id="company" class="right">
<div class="title">{{ type }}</div>
<br>
<div class="value">{{ company.phone }}</div>
<div class="value">{{ company.mail }}</div>
<div class="value">{{ company.webSite }}</div>
<div class="value">{{ company.address }}</div>
<br>
</div>
<div class="clear"></div>
<div class="separator"></div>
<div id="invoice">
<table>
<tr>
<td>
<table>
<tr>
<td>
<div class="title">Client</div>
<div class="value">{{ client.name }}</div>
<div class="value">{{ client.address }}</div>
</td>
<td>
<div class="title"># {{ type }}</div>
<div class="value">{{ number }}</div>
</td>
</tr>
<tr class="spacer">
<td>
<div class="title">Project</div>
<div class="value">{{ title }}</div>
</td>
<td>
<div class="title">Date</div>
<div class="value">{{ date | date_format: dd/MM/yyyy }}</div>
</td>
</tr>
</table>
</td>
<td class="total">
<div class="title">Total</div> <div class="value">{{ amount }}</div>
</td>
</tr>
</table>
</div>
<div class="separator"></div>
<div id="content">
<table>
<tr>
<th align="left">Item</th>
<th align="right">Price</th>
<th align="right">Qty</th>
<th align="right">ET Total</th>
<th align="right">Taxes</th>
<th align="right">Total</th>
</tr>
{% for item in items %}
<tr>
<td align="left">{{ item.title }}{% if item.details %}<br><span class="details">{{ item.details }}</span>{% /if %}</td>
<td align="right">{{ item.amount }}</td>
<td align="right">{{ item.quantity }}</td>
<td align="right">{{ item.totalWithoutTaxes }}</td>
<td align="right">{% if item.taxesRate %}{{ item.taxesRate }}{% /if %}</td>
<td align="right">{% if item.free %}<s>{% /if %}{{ item.total }}{% if item.free %}</s><br>FREE{% /if %}</td></tr>
{% /for %}
{% if discount %}
<tr>
<td colspan="5" align="right">Discount</td>
<td align="right">{{ discount }}</td>
</tr>
{% /if %}
<tr>
<td colspan="5" align="right">ET total</td>
<td align="right">{{ amountWithoutTaxes }}</td>
</tr>
{% for tax in taxesDetails %}
<tr>
<td colspan="5" align="right">{{ tax.name }} {{ tax.rate }}</td>
<td align="right">{{ tax.amount }}</td>
</tr>
{% /for %}
<tr class="total">
<td colspan="5" align="right">Total</td>
<td align="right">{{ amount }}</td>
</tr>
</table>
</div>
<div class="footer">{{ footer }}</div>
</body>
</html>