eyoder at gmail
Oct 27, 2009, 5:12 PM
Post #9 of 9
(1109 views)
Permalink
|
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 [at] bytesmiths> wrote:
> > From: "Sandy Rozhon" <srozhon [at] oh>
> >
> > 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 [at] lists
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
|
