Twiki Tables HowTo

Plain Twiki tables

You can use a plain Twiki table with helper plugins:

Some table caption
Line Part number Description SN Install order
1 ICX7750-48F SFP switch CRH3326K09K 1
1 ICX7750-48F SFP switch CRH3326K099 9
2 ICX7750-48C BaseT switch CRJ3319K004 17
2 ICX7750-48C BaseT switch CRJ3312K009 25
3 RPS9+I PSU CUA2V03K0FL 2
3 RPS9+I PSU CUA2V03K0JY 3
3 RPS9+I PSU CUA2V03K0CL 10

Excel based tables

If you have to do a lot of editing and/or manipulation to the table data, you can attach an excel spreadsheet, together with it's html export, and then include it in the page

Inline display of html table

If you include html files exported from Excel, you can't easily apply JavaScript (e.g. JQuery) plugins that perform filtering or sorting on the table data, because the Excel export only contains TD elements, and no TH (table headigns). Sample html attached to this page (exported from the Excel file attached to this page)
%INCLUDE{%ATTACHURL%/Table1.htm}%

Line Part number Description SN Install order
1 ICX7750-48F  SFP switch CRH3326K09K 1
1 ICX7750-48F  SFP switch CRH3326K099 9
2 ICX7750-48C  BaseT switch CRJ3319K004 17
2 ICX7750-48C  BaseT switch CRJ3312K009 25
3 RPS9+I  PSU CUA2V03K0FL 2
3 RPS9+I  PSU CUA2V03K0JY 3
3 RPS9+I  PSU CUA2V03K0CL 10
3 RPS9+I  PSU CUA2V03K0JR 11
3 RPS9+I  PSU CUA2V03K005 18
3 RPS9+I  PSU CUA2V03K0GJ 19
3 RPS9+I  PSU CUA2V03K0JT 26
3 RPS9+I  PSU CUA2V03K0HP 27
4 ICX7750-FAN-I  Fan box CYZ3305K018 4
4 ICX7750-FAN-I  Fan box CYZ3305K015 12
4 ICX7750-FAN-I  Fan box CYZ3305K01N 20
4 ICX7750-FAN-I  Fan box CYZ3305K016 28
5 10G-SFPP-TWX-0508  Twinax 8 pack box BCJ2531K004 33
5 10G-SFPP-TWX-0508  Twinax 8 pack box BCJ2531K00A 34
5 10G-SFPP-TWX-0508  Twinax 8 pack box BCJ2531K00B 35
5 10G-SFPP-TWX-0508  Twinax 8 pack box BCJ2531K00F 36
5 10G-SFPP-TWX-0508  Twinax 8 pack box BCJ2531K00H 37
5 10G-SFPP-TWX-0508  Twinax 8 pack box BCJ2531K00R 38
AUX 1 individual fan fan CYM3304K07P 5
AUX 1 individual fan fan CYM3304K053 6
AUX 1 individual fan fan CYM3304K04R 7
AUX 1 individual fan fan CYM3304K083 8
AUX 1 individual fan fan CYM3304K05X 13
AUX 1 individual fan fan CYM3304K06T 14
AUX 1 individual fan fan CYM3304K05B 15
AUX 1 individual fan fan CYM3304K001 16
AUX 1 individual fan fan CYM3304K06P 21
AUX 1 individual fan fan CYM3304K05S 22
AUX 1 individual fan fan CYM3304K05L 23
AUX 1 individual fan fan CYM3304K054 24
AUX 1 individual fan fan CYM3304K05A 29
AUX 1 individual fan fan CYM3304K05N 30
AUX 1 individual fan fan CYM3304K06S 31
AUX 1 individual fan fan CYM3304K05K 32
AUX 2 58-1000023-01 twinax 5m cable CCMD14110053YJ1 39
AUX 2 58-1000023-01 twinax 5m cable CCMD14110053YJE 40
AUX 2 58-1000023-01 twinax 5m cable CCMD1411005408M 41
AUX 2 58-1000023-01 twinax 5m cable CCMD1411005408R 42
AUX 2 58-1000023-01 twinax 5m cable CCMD141100540AN 43
AUX 2 58-1000023-01 twinax 5m cable CCMD141100540AU 44
AUX 2 58-1000023-01 twinax 5m cable CCMD141100540BU 45
AUX 2 58-1000023-01 twinax 5m cable CCMD141100540H8 46
AUX 2 58-1000023-01 twinax 5m cable CCMD141100540RH 47
AUX 2 58-1000023-01 twinax 5m cable CCMD141100540TD 48
AUX 2 58-1000023-01 twinax 5m cable CCMD141100540VL 49
AUX 2 58-1000023-01 twinax 5m cable CCMD141100542B7 50
AUX 2 58-1000023-01 twinax 5m cable CCMD141200545DV 51
AUX 2 58-1000023-01 twinax 5m cable CCMD141200545HC 52
AUX 2 58-1000023-01 twinax 5m cable CCMD1412005460U 53
AUX 2 58-1000023-01 twinax 5m cable CCMD1412005462K 54
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550KU 55
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550L1 56
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550N6 57
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550N7 58
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550PK 59
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550R0 60
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550R1 61
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550R3 62
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550R7 63
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550RB 64
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550RN 65
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550RR 66
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550TC 67
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550TF 68
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550TG 69
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550TL 70
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550TM 71
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550U0 72
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550U1 73
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550U8 74
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550U9 75
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550UA 76
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550UD 77
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550UE 78
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550UP 79
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550UT 80
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550UV 81
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550UY 82
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550VK 83
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550VR 84
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550VY 85
AUX 2 58-1000023-01 twinax 5m cable CCMD142200550W1 86

Inline display of excel file

Excel attachments cannot be displayed inline
%INCLUDE{%ATTACHURL%/Table1.xls}%

Links to attachments

You can have urls to the excle or html export of the excel:

-- StefanStancu - 2015-01-26

Topic attachments
I Attachment History Action Size Date Who Comment
HTMLhtm Table1.htm r3 r2 r1 manage 77.0 K 2015-01-26 - 10:32 StefanStancu  
Microsoft Excel Spreadsheetxls Table1.xls r1 manage 31.0 K 2007-12-07 - 19:44 StefanStancu Original excel Table
Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r2 - 2015-01-26 - StefanStancu
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Sandbox All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback