tips:xls2wiki
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
| tips:xls2wiki [2010-02-10 13:48] – 195.35.72.170 | tips:xls2wiki [2014-10-19 14:19] – old revision restored (2013-03-01 07:36) Aleksandr | ||
|---|---|---|---|
| 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 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=" | ||
| 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:// | ||
| + | |||
| + | ---- | ||
| ===== 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 311: | ||
| ----- | ----- | ||
| - | 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