forums.lyricapps.fr

Bonjour,

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>

Vous pouvez sélectionner et copier des lignes d'une facture d'iCompta (cmd - C) et les coller dans une feuille Excel (cmd - V).

oui mais sa me copie le code pas la mise en forme .

forums.lyricapps.fr

Convertir facture HTLM en .xls

Convertir facture HTLM en .xls

Re: Convertir facture HTLM en .xls

Re: Convertir facture HTLM en .xls