andre:konverter

<php>

<?php header(„Content-type: text/html; charset=UTF-8“); ?> <!DOCTYPE html PUBLIC „-W3CDTD XHTML 1.0 TransitionalEN“ „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> <style type=„text/css“> 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>