tips:xls2wiki
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
tips:xls2wiki [2010-02-10 13:48] – 195.35.72.170 | tips:xls2wiki [2020-05-20 22:20] – [Installation] gero-gothe | ||
---|---|---|---|
Line 4: | Line 4: | ||
===== Abstract ===== | ===== Abstract ===== | ||
- | This is a simple script that converts copied data from xls to DokuWiki' | + | This is a simple script that converts copied data from xls to DokuWiki' |
Just copy cells in Excel and paste it, then press ' | Just copy cells in Excel and paste it, then press ' | ||
Line 92: | Line 92: | ||
< | < | ||
Copy and paste your Excel or Wiki table below and press [Convert!]< | Copy and paste your Excel or Wiki table below and press [Convert!]< | ||
- | Скопируйте и вÑтавьте таблицу из | + | Скопируйте и вставьте таблицу из |
<form method=POST action=""> | <form method=POST action=""> | ||
<input type=" | <input type=" | ||
Line 112: | Line 112: | ||
===== Comments Support Wiki header on first Line ===== | ===== Comments Support Wiki header on first Line ===== | ||
- | I have find this script | + | I have find this script |
- | I would like just to add this lines to put the first line like an header :\\ | + | I would like just to add this lines to put the first line like an header:\\ |
<code php> | <code php> | ||
Line 137: | Line 137: | ||
</ | </ | ||
- | finaly the code with english / french / russian translation, \\ | + | > This converts cell contents like ", " |
- | empty cells stay empty (no " . "), first line become header | + | |
- | <code php> | + | Finally, the code with English / French / Russian translations, |
+ | empty cells stay empty (no " . "), first line become header: | ||
+ | |||
+ | < | ||
<?php header(" | <?php header(" | ||
Line 194: | Line 196: | ||
</ | </ | ||
- | <? | + | <?php |
$s = $_POST[' | $s = $_POST[' | ||
$fromto = $_POST[' | $fromto = $_POST[' | ||
Line 212: | Line 214: | ||
$arrayS = preg_split ("/ | $arrayS = preg_split ("/ | ||
$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 240: | Line 242: | ||
Copy and paste your Excel or Wiki table below and press [Convert!]< | Copy and paste your Excel or Wiki table below and press [Convert!]< | ||
Copier et coller votre Table Excel ou Wiki dans le cadre ci-dessous et cliquez sur [Convert!]< | Copier et coller votre Table Excel ou Wiki dans le cadre ci-dessous et cliquez sur [Convert!]< | ||
- | Скопируйте и вÑтавьте таблицу из | + | Скопируйте и вcтавьте таблицу из Excel или |
<form method=POST action=""> | <form method=POST action=""> | ||
- | <input type=" | + | <input type=" |
- | <input type=" | + | <input type=" |
<INPUT TYPE=SUBMIT VALUE=" | <INPUT TYPE=SUBMIT VALUE=" | ||
- | < | + | < |
</ | </ | ||
<span style=" | <span style=" | ||
Line 258: | Line 260: | ||
</ | </ | ||
+ | |||
+ | There is a spell mistake here... | ||
+ | < | ||
+ | $nb_lines = count ($arrayS)-1; | ||
+ | $s = $s . $nb_lignes; | ||
+ | </ | ||
+ | |||
+ | nb_lignes should be **nb_lines**. | ||
+ | |||
===== Installation ===== | ===== Installation ===== | ||
Line 263: | Line 274: | ||
:?: Please forgive such a n00b question, but how does one install this helpful Trick? | :?: Please forgive such a n00b question, but how does one install this helpful Trick? | ||
- | My n00b answer : | + | My n00b answer: |
use iframe.... | use iframe.... | ||
- | create a php page somewhere into your website | + | create a PHP page somewhere into your website |
- | Use iframe to include this php page into a wiki page. | + | Use iframe to include this PHP page into a wiki page. |
- | Look to this plugins if you hate html :/ | + | Look to this plugins if you hate HTML: [[plugin: |
- | you can **not** try to include directly the code in a wiki page either : | + | You can **not** try to include directly the code in a wiki page either: |
- | something like : | + | something like: |
< | < | ||
Line 280: | Line 291: | ||
</ | </ | ||
</ | </ | ||
- | Because the page use little | + | Because the page use little |
---- | ---- | ||
+ | More simple. Save xls2wiki.php to your dokuwiki\www\ folder and click this link: http:// | ||
+ | |||
+ | ---- | ||
+ | |||
+ | > 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:// | ||
===== 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? Thx in adv. | + | 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 |
- | Resp.: I've found a way creating a wikipage and adding {{url> | + | Resp.: I've found a way creating a wikipage and adding {{url> |
===== Remarks ===== | ===== Remarks ===== | ||
- | If you like this you probably love this HTML converter as well : [[http:// | + | If you like this you probably love this HTML converter as well: [[http:// |
Bad link! | Bad link! | ||
Line 297: | Line 313: | ||
----- | ----- | ||
- | Does not work for me, keep seeing " <? echo $s; ?> " in the input field, and convert does not do a thing, neither on IE nor on firefox.. | + | Does not work for me, keep seeing " <? echo $s; ?> " in the input field, and convert does not do a thing, neither on IE nor on Firefox. |
+ | |||
+ | Perhaps I'm doing something wrong?? | ||
+ | |||
+ | -Theo | ||
+ | |||
+ | ----- | ||
+ | |||
+ | @theo: It's a " | ||
- | Perhaps i'm doing something wrong?? | + | -Steven |
- | Grtz Theo | + | Changing the ini files worked for me - you also need to restart your Apache server before it will work. --- [[user> |
tips/xls2wiki.txt · Last modified: 2024-01-31 20:26 by 69.11.54.89