andre:konverter

<php>

<?php header(„Content-type: text/html; charset=UTF-8“); ?> <!DOCTYPE html PUBLIC „-W3CDTD XHTML 1.0 Transitional//EN“ „http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd“> <html xmlns=„http://www.w3.org/1999/xhtml“ xml:lang=„en“ lang=„en“ dir=„ltr“> <head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script type="text/javascript" charset="utf-8">
function selText()
  {
  document.getElementById("txt1").select()
  }
</script>

	body {
		font: .8em "Trebuchet MS", Verdana, Arial, Sans-Serif;
		text-align: center;
		color: #333;
		background-color: #fff;
		margin-top: 0em;
	}

h1 {

		font-size: 2em;
		padding: 0;
		margin: 0;
	}

h5 {

		font-size: 1em;
		color: #09c;
		font-weight: bold;
	}

form {

		background-color: #eee;
		border: 1px solid #ccc;
		margin-left: auto;
		margin-right: auto;
		padding: 1em;
	}

a {

		color: #09c;
		text-decoration: none;
		font-weight: bold;
	}

</style>

</head>

<?php
	$s = $_POST['s'];
	$fromto = $_POST['fromto'];

if ($fromto==„E2W“){

$s = str_replace(„\r\n“, „ |\n| “, $s);

		$s = str_replace("\t", " | ", $s);
		//$s = str_replace("|  |", "| . |", $s);

$s = „| “.$s;

		$s = substr($s,0,-2); //get rid of last newline conversion

explode the source by line $arrayS = preg_split („/[\n,]+/“, $s); $nb_lines = count ($arrayS)-1; $s = $s . $nb_lines; $s = „“; foreach ( $arrayS as $key ⇒ $lines ){ if ($key == 0) { $lines = str_replace(„|“, „^“, $lines); }end if

		$s = $s . $lines .  "\n";
		}//end for

$s = substr($s,0,-2); //get rid of last newline conversion

	}else{
		$s = str_replace("^", "|", $s);
		$s = str_replace("|\r\n|", "\r\n", $s);
		$s = str_replace("\r\n ", "\r\n", $s);
		$s = str_replace(" |", "|", $s);
		$s = str_replace("| ", "|", $s);
		$s = str_replace("|", "\t", $s);
		$s = substr($s,1); // get rid of first | without /r/n

}

?> <body onload=„selText()“> <center> <h5>WIKI2EXCEL converter</h5>

Copy and paste your Excel or Wiki table below and press [Convert!]<br/> Copier et coller votre Table Excel ou Wiki dans le cadre ci-dessous et cliquez sur [Convert!]<br/> Скопируйте и вcтавьте таблицу из Excel или Wiki и нажмите [Convert!] (конвертировать)

<form method=POST action="">
	<input type="radio" name="fromto" value="E2W" checked>Excel - Wiki<br>
	<input type="radio" name="fromto" value="W2E">Wiki - Excel<br>
	<INPUT TYPE=SUBMIT VALUE="Convert!"><br/> 
	<textarea id="txt1" name="s" wrap="off" cols=50 rows=50 style="width:400; height:450"><?=$s ?></textarea>
</form>

<strong>Version 0.1 : </strong> <ul> <li>Headers from wiki2excel will not be converted properly</li> <li>Links with alternative text (like <i>alt.text</i> ) will not convert properly</li> </ul> </center> </body></html>

</php>