DokuWiki

It's better when it's simple

User Tools

Site Tools


tips:xls2wiki

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revision
tips:xls2wiki [2010-02-10 19:00]
74.93.99.97
tips:xls2wiki [2014-10-19 14:19]
Aleksandr old revision restored (2013-03-01 07:36)
Line 92: Line 92:
 <h5>WIKI2EXCEL converter</h5> <h5>WIKI2EXCEL converter</h5>
 Copy and paste your Excel or Wiki table below and press [Convert!]<br/> Copy and paste your Excel or Wiki table below and press [Convert!]<br/>
-Скопируйте и вставьте таблицу из  Excel Ð¸Ð»Ð¸ Wiki Ð¸ нажмите [Convert!] (конвертировать)+Скопируйте и вставьте таблицу из  Excel или Wiki и нажмите [Convert!] (конвертировать)
  <form method=POST action="">  <form method=POST action="">
  <input type="radio" name="fromto" value="E2W" checked>Excel » Wiki<br>  <input type="radio" name="fromto" value="E2W" checked>Excel » Wiki<br>
Line 136: Line 136:
  
 </code> </code>
 +
 +> This converts cell contents like ", " (aka. ''<comma><space>'') into a ''\n''. Couldn't figure out why (code dyslexia)...
  
 Finally, the code with English / French / Russian translations, \\ Finally, the code with English / French / Russian translations, \\
 empty cells stay empty (no " . "), first line become header: empty cells stay empty (no " . "), first line become header:
  
-<code php>+<code php xls2wiki.php>
  
 <?php header("Content-type: text/html; charset=UTF-8"); ?> <?php header("Content-type: text/html; charset=UTF-8"); ?>
Line 240: Line 242:
 Copy and paste your Excel or Wiki table below and press [Convert!]<br/> 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/> Copier et coller votre Table Excel ou Wiki dans le cadre ci-dessous et cliquez sur [Convert!]<br/>
-Скопируйте и вставьте таблицу из  Excel Ð¸Ð»Ð¸ Wiki Ð¸ нажмите [Convert!] (конвертировать)+Скопируйте и вcтавьте таблицу из Excel или Wiki и нажмите [Convert!] (конвертировать)
  <form method=POST action="">  <form method=POST action="">
  <input type="radio" name="fromto" value="E2W" checked>Excel » Wiki<br>  <input type="radio" name="fromto" value="E2W" checked>Excel » Wiki<br>
Line 258: Line 260:
  
 </code> </code>
 +
 +There is a spell mistake here...
 +<code>
 +$nb_lines = count ($arrayS)-1;
 +$s = $s . $nb_lignes;
 +</code>
 +
 +nb_lignes should be **nb_lines**.
 +
  
 ===== Installation ===== ===== Installation =====
Line 284: Line 295:
 ---- ----
  
 +More simple. Save xls2wiki.php to your dokuwiki\www\ folder and click this link: http://localhost/xls2wiki.php. For net security set file attributes 600.
 +
 +----
 ===== Discussion ===== ===== Discussion =====
 I've installed iframe, but I'm kind of stuck how can I add the PHP file on the page I want to embed an excel spreadsheet. Can anyone help? Thanks in advance. I've installed iframe, but I'm kind of stuck how can I add the PHP file on the page I want to embed an excel spreadsheet. Can anyone help? Thanks in advance.
Line 302: Line 316:
  
 -Theo -Theo
 +
 +-----
 +
 +@theo: It's a "new" setting in current php versions which disables the php short tags, so you either have to replace the: <code><?</code> with: <code><?php</code> in the php script, **or** in your php.ini set the following parameter: <code>short_open_tag = on</code>
 +
 +-Steven
 +
 +Changing the ini files worked for me - you also need to restart your Apache server before it will work. --- [[user>gymnophoria|gymnophoria]] //2013/01/10 16:58//
tips/xls2wiki.txt · Last modified: 2020-05-20 22:20 by gero-gothe