create new tag
, view all tags

Import TWiki Tables Into Spread Sheets

I've only tried this with OpenOffice 1.1.3, but I presume it's duplicating functionality in Excel:

  1. Produce tables in a topic, however you like (eg. FORMATTEDSEARCH, plain table).
  2. Access the URL of the topic from OpenOffice as an external data source (eg. get tables from "AddOnPackage" topic):
    1. Insert->External Data...
    2. Click "..." (just entering a URL doesn't work for me, so...)
    3. Enter "http://twiki.org/cgi-bin/view/Plugins" as directory, hit ENTER.
    4. Enter "AddOnPackage" as file
    5. Click Open
    6. Select "HTML_1" from "Available tables/ranges".
    7. Click OK
  3. Voila! Table from web page appears in spreadsheet
  4. Table can be refreshed automatically (bad idea) or manually from Edit->Links.

-- WarwickAllison - 15 Apr 2005

Thanks Warwick - this is something I've had to do innumerable times myself, so it's obviously a common requirement! Yes, it works the same way with Excel.

I made this a change request so we can get it into standard documentation.

-- CrawfordCurrie - 15 Apr 2005

When I try this in Excel (Data -> Import External Data) I can import the entire topic into Excel but I am unable to import just a single table from within the topic.

-- EdYoung - 14 Aug 2007

Same problem I am also facing , Its importing entire Topic , Above thing works well with Old version of TWiki (Cairo Release ). Actually while importing in Cairo Rel , we get tabs to select rows or Columns but, that not happening with Dakar , any work around to get it done.

-- AnjaniKumar - 22 Oct 2007

I manage to get Tabs while importing data( edit table content from TWiki topics ) to excel after adding

in templates/body.pattern.tmpl template. But it disturbs the total look and feel of Site i,e webleft moves to down, images get scattered. So can suggest right location to add table tag to get importing to excel working.

-- AnjaniKumar - 11 Dec 2007

I missed tag

in body.pattern.tmpl

-- AnjaniKumar - 12 Dec 2007

Edit | Attach | Watch | Print version | History: r8 < r7 < r6 < r5 < r4 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r8 - 2007-12-12 - AnjaniKumar
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2018 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.