I have a solution. It's not pretty, but it works.
1 - From Excel, export the table as .CSV (comma-separated values)
2 - Open the file in Word (or another word processor), then do the
following:
- Find and replace all commas (,) with the pipe (|) character
- Find and replace all (^p) with the following string (^p|-^p|),
where ^p is CR-LF (carriage return-line feed, i.e. new line)
3 - copy and paste this into MediaWiki, add the first and last line of the
table format, and you're done
For example, starting with this csv file:
field 1, field 2, field 3
field 4, field 5, field 6
After applying the word processor magic, it becomes:
|field 1| field 2| field 3
|
|field 4| field 5| field 6
Copy and paste into the table format in mediawiki:
{| border="1" cellpadding="5" cellspacing="0"
|field 1| field 2| field 3
|
|field 4| field 5| field 6
|}
Evelyn Yoder
http://www.linkedin.com/in/evelynyoder
On Fri, Oct 23, 2009 at 11:03 AM, Jan Steinman <Jan(a)bytesmiths.com> wrote:
From:
"Sandy Rozhon" <srozhon(a)oh.rr.com>
I used this site with great success....very easy. All you do is copy
all the cells you want and paste them into their form, then it
regurgitates the code for your wiki.
http://excel2wiki.net/
Lovely! It properly converts Apple Numbers stuff, as well.
I guess the incorrect handling of delimited separators is not so
important as long as you only do copy/paste from Excel or Numbers,
which defaults to tab delimiters.
But be aware that this extension probably will not work properly with
arbitrary exported CSV data.
:::: MacOS X -- when you need today what Bill Gates has promised you
tomorrow. ::::
:::: Jan Steinman
http://www.VeggieVanGogh.com ::::
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l