Topic: Excel table to wiki  (Read 85 times)


tedomedo

« on: August 03, 2017, 11:33:33 AM »
Hi. How can i add my excel table to a wiki and to keep everything (colors, borderings, row/column sizes...)?

Ametsala

« Reply #1 on: August 04, 2017, 03:21:19 PM »
First of all, especially if your table has complex information (like the ones in the wiki's Plants page), make sure your table's wikicode is legible after conversion. The point of a wiki is that anyone can edit it at anytime so everyone needs to be able to understand the wikicode now and in the future.

I created the week calendar for the wiki using OpenOffice. Saved as html and copy pasted the contents of the html file to http://bmanolov.free.fr/html2wiki-tables.php#wiki. This created a lot of chaff though (IIRC, all formatting was saved individually for each cell and there were some completely unnecessary tidbits I removed manually), and the resulting wikicode is hard to read.

Can't remember if I've used this method for another table that doesn't change bg color in the middle of rows/columns, so don't know how it handles such tables. For such, I might just use a simpler widget like the Copy and Paste Excel-to-Wiki Converter and add colors etc. manually afterwards.

There's also a VBA-Macro for EXCEL table conversion, but I haven't played with that. (Haven't had excel in years)

See also:
Wikipedia's tool page
Wikimedia Commons: Convert tables and charts to wiki code or image files


tedomedo

« Reply #2 on: August 06, 2017, 10:56:41 AM »
After some experiments I do this: paste excel table to .rtf in word, sometimes i have to resize rows and columns because pasted table has not the same size as in excel, then i save this as filtered html. There's no need to convert html to wiki - at least not on http://unrealworld.wikia.com, where i updated Cultures 2 days ago for version 3.30.
« Last Edit: August 06, 2017, 11:02:51 AM by tedomedo »