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: 15 years 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 engaging 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 someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is 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

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r2 - 2010-10-06 - PeterThoeny
 
  • 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-2026 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.