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
Both sides next revision
tips:xls2wiki [2010-07-29 12:34]
84.44.162.3 [Comments Support Wiki header on first Line] Bug with comma and new line
tips:xls2wiki [2020-05-20 22:20]
gero-gothe [Installation]
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 196: Line 196:
    
 </head> </head>
- <?+ <?php
  $s = $_POST['s'];  $s = $_POST['s'];
  $fromto = $_POST['fromto'];  $fromto = $_POST['fromto'];
Line 214: Line 214:
  $arrayS = preg_split ("/[\n,]+/", $s);  $arrayS = preg_split ("/[\n,]+/", $s);
  $nb_lines = count ($arrayS)-1;  $nb_lines = count ($arrayS)-1;
- $s = $s . $nb_lignes;+ $s = $s . $nb_lines;
  $s = "";  $s = "";
  foreach ( $arrayS as $key => $lines ){  foreach ( $arrayS as $key => $lines ){
Line 242: 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> 
- <input type="radio" name="fromto" value="W2E">Wiki Â» Excel<br>+ <input type="radio" name="fromto" value="W2E">Wiki Excel<br>
  <INPUT TYPE=SUBMIT VALUE="Convert!"><br/>   <INPUT TYPE=SUBMIT VALUE="Convert!"><br/> 
- <textarea id="txt1" name="s" wrap="off" cols=50 rows=50 style="width:400; height:450"><? echo $s?></textarea>+ <textarea id="txt1" name="s" wrap="off" cols=50 rows=50 style="width:400; height:450"><?=$s ?></textarea>
  </form>  </form>
 <span style="font-size:80%"> <span style="font-size:80%">
Line 260: 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 286: 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.
 +
 +----
 +
 +> I integrated the code from the beginning into a simple plugin. I also added a few helping functions for cleaning up markup resulting from pandoc conversion of docx-files into dokuwiki markup. \\ See: https://github.com/practical-solutions/dokuwiki-xlsconv
 ===== 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 304: Line 318:
  
 -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