Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

Forums » Features / Usability » Convert Excel worksheet into WIKI table
 
Thread actions
Print this page
  • Print all pages

    • Convert Excel worksheet into WIKI table

    Posted by akantro posts: 41

    There is one use case that i see my users over and over wanting to do. (and i never have a good answer. . )

    Take an excel worksheet and put this on a WIKI page as a WIKI table. Is there any easy way to do this? I was thinking about writing a VBA macro in Excel to take a worksheet and export WIKI table syntax. Before i did this, i wanted to see if there was any other way to getting data that is in an excel worksheet into a WIKI table.

    I have tried:

    1. Tikisheets: this didn't seem to help and i found the whole interface quite difficult to use and there was no easy way for a non tech person to simply take an excel sheet and bring in to a WIKI page with a small amount of steps.

    2. Export Excel sheet as HTML and then copy and paste HTML into WIKI page. This kind of worked but is still way to much manual work for my users. They are not tech savvy at all.

    3. Export excel as CSV file. Open up in Notepad. replace "," with "|" and copy from notepad into WIKI. Also quite manuall and too error prone for non tech users.

    my VBA macro idea was to export direct WIKI syntax to the clipboard so they can then go into a WIKI page and just paste this out. This solution has the overhead of having them to setup some Excel addin in their Excel instance.

    Any other thoughts . .

    Also, I hear that in version 1.10 there will be a WYSIWYG editor. Will this include editing tables (add row, delete row, add column, etc . .) ??

    thks,
    ak

    Reads: 4750
    Posted by Gary Cunningham-Lee posts: 4673 Japan

    > Also, I hear that in version 1.10 there will be a WYSIWYG editor. Will this include editing tables (add row, delete row, add column, etc . .) ??

    Can't help you on the other questions (search and replacing of commas with pipe characters is the only way I've done the conversion), but the WYSIWYG editor is FCKeditor - http://www.fckeditor.net/, and table creation and editing is listed as a feature.

    -- Gary


    Posted by fumphco posts: 30

    > There is one use case that i see my users over and over wanting to do. (and i never have a good answer. . )
    >

    I don't know what it would take to integrate with tikiwiki, but Dan Bricklin has written wikicalc. See http://www.softwaregarden.com/wkcalpha/


    Posted by Xavier de Pedro posts: 1817 Catalan Countries

    Wiki Calc would be excellent (however, it's written in perl, afaik)

    Tikisheets (in 1.10) IS the solution for newbies. Export from OOo or M$ Excel as csv (not the .xls-dev which doesn't work), and go ahead.
    I've been using it with (non-tech) students for a year with great success when tables where not bigger than aprox. 30 columns and rows.

    I made this short help page for this tasks (in catalan, but screenshots my help)

    http://uniwiki.aia06.ourproject.org/ComImportarATikiSheets

    Posted by akantro posts: 41

    when is 1.10 getting released?



    > Wiki Calc would be excellent (however, it's written in perl, afaik)
    >
    > Tikisheets (in 1.10) IS the solution for newbies. Export from OOo or M$ Excel as csv (not the .xls-dev which doesn't work), and go ahead.
    > I've been using it with (non-tech) students for a year with great success when tables where not bigger than aprox. 30 columns and rows.
    >
    > I made this short help page for this tasks (in catalan, but screenshots my help)
    >
    > http://uniwiki.aia06.ourproject.org/ComImportarATikiSheets