Loading...
 
Features / Usability

Features / Usability

Forum List Topic List

Forums » Features / Usability » Excel file in a wiki-page?
 
Thread actions
PDF Print this page
  • Print all pages

    • Excel file in a wiki-page?

    Posted by kwancho posts: 1

    Hi,
    I have a Excel spreadsheet which is too large to conviently retype into a wiki table format. What's the best way to convert it into a useable format? If I save it in mhtml format, how can I display it in a wikipage? Thanks!

    Reads: 1009
    Link
    Posted by Spyros Kroustalakis posts: 32 Greece

    At first you can Tikisheet. It's a new module and very interesting too.

    There is also the hard way:

    1. Save the EXCEL file as CSV.
    2. Open it with an editor like Notepad and replace ";" with "~|~".
    3. Copy and Paste all the contents of the new file into a Wiki page.

    If there is no merging cells or other special formats everything will be fine!!!

    Maybe you 'll have a problem viewing all of the Wiki page if the rows of your file are too many. Try and check.

    Spyk

    Link
    Posted by Spyros Kroustalakis posts: 32 Greece

    I forgot that you must use also the appropriate strings for FANCYTABLE (see at the related Wiki page).

    Spyk

    Link