Tags:
create new tag
, view all tags

SID-00944: Excel to Wiki-Table: selecting rows by parameter?

Status: Unanswered Unanswered TWiki version: 4.1.1 Perl version:
Category: CategoryAddOns Server OS: Last update: 1 year ago

Hello everyone,

I have an excel sheet with interface descriptions: each row describes one interface. Each column is therefore an attribute. The first column contains a unique name of a row.

Example:

Name Attribute1 Attribute2 Attribute3
ABC werqwer tzz 1
DEF sdffsd werttr 4
GHIJ gge gfg 5
KLMN 45345 fffgfg 68

What I need to do now is this:

On certain pages (topics) I need to include a table such as this one:

Name DEF
Attribute2 werttr
Attribute3 4
Attribute1 sdffsd

As you can see, this table shows the attributes of ONLY 1 row of the source table. Not only that, this table also provides this information in a vertical manner.

I hope to find a plugin that lets me do this by passing a parameter. So in the topic in which want to include the "vertical" table, I'd like to write something like

%SOMEPLUGIN{"DEF"}%

Do you know of any plugin that can do that?

Naturally, I have experimented with plugins such as EXCEL2TABLE or the EXCELIMPORTEXPORTPLUGIN - but they don't seem to allow parameters to select a row OR to render a "vertical" table.

Any suggestion would be greatly appreciated

Thank you very much

Sincerely Matt

-- TWikiGuest - 2010-08-12

Discussion and Answer

Closing this question after more than 30 days of inactivity. Feel free to reopen if needed. Consider a subscription for support or engage one of the TWiki consultants if you need timely help. We invite you to get involved with the community, it is more likely you get community support if you support the open source project!

-- PeterThoeny - 2010-10-06

Change status to:

ALERT! If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.
SupportForm
Status Unanswered
Title Excel to Wiki-Table: selecting rows by parameter?
SupportCategory CategoryAddOns
TWiki version 4.1.1
Server OS

Web server

Perl version

Topic revision: r2 - 2010-10-06 - PeterThoeny
 
Twitter Delicious Facebook Digg Google Bookmarks E-mail LinkedIn Reddit StumbleUpon    
  • Download TWiki
TWiki logo Powered by PerlIdeas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2012 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.