Twiki Tables HowTo

Plain Twiki tables

You can use a plain Twiki table with helper plugins:

• TablePlugin: for sorting and header/data formatting and color tweaking
• EditTablePlugin: for in-place editing on the web-page

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:

• https://twiki.cern.ch/twiki/pub/Sandbox/TablesInTwiki/Table1.htm
• https://twiki.cern.ch/twiki/pub/Sandbox/TablesInTwiki/Table1.xls

-- StefanStancu - 2015-01-26