这种二维表头怎么做？

截图04.jpg (19.07 KB, 下载次数: 509)

2013-7-24 20:29 上传

点击文件名下载附件
这个二维表头怎么用代码写？

回复 1楼lypvc的帖子

参考代码如下：

1. 
   
2. [C#]
   
3. 
   
4. // Set the number of rows in the column header.
   
5. 
   
6. FpSpread1.ActiveSheet.ColumnHeader.RowCount = 3;
   
7. 
   
8. // Set the number of columns in the row header.
   
9. 
   
10. FpSpread1.ActiveSheet.RowHeader.ColumnCount = 2;
    
11. 
    
12.   
    
13. 
    
14. // Define the labels for the spanned column header cells.
    
15. 
    
16. FpSpread1.ActiveSheet.ColumnHeader.Cells[2, 0].Text = "East";
    
17. 
    
18. FpSpread1.ActiveSheet.ColumnHeader.Cells[2, 1].Text = "West";
    
19. 
    
20. FpSpread1.ActiveSheet.ColumnHeader.Cells[2, 2].Text = "East";
    
21. 
    
22. FpSpread1.ActiveSheet.ColumnHeader.Cells[2, 3].Text = "West";
    
23. 
    
24. FpSpread1.ActiveSheet.ColumnHeader.Cells[2, 4].Text = "East";
    
25. 
    
26. FpSpread1.ActiveSheet.ColumnHeader.Cells[2, 5].Text = "West";
    
27. 
    
28. FpSpread1.ActiveSheet.ColumnHeader.Cells[2, 6].Text = "East";
    
29. 
    
30. FpSpread1.ActiveSheet.ColumnHeader.Cells[2, 7].Text = "West";
    
31. 
    
32. FpSpread1.ActiveSheet.ColumnHeader.Cells[1, 0].Text = "1st Quarter";
    
33. 
    
34. FpSpread1.ActiveSheet.ColumnHeader.Cells[1, 2].Text = "2nd Quarter";
    
35. 
    
36. FpSpread1.ActiveSheet.ColumnHeader.Cells[1, 4].Text = "3rd Quarter";
    
37. 
    
38. FpSpread1.ActiveSheet.ColumnHeader.Cells[1, 6].Text = "4th Quarter";
    
39. 
    
40. FpSpread1.ActiveSheet.ColumnHeader.Cells[0, 0].Text = "Fiscal Year 2004";
    
41. 
    
42.   
    
43. 
    
44. // Define the column header cell spans.
    
45. 
    
46. FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 0, 1, 2);
    
47. 
    
48. FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 2, 1, 2);
    
49. 
    
50. FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 4, 1, 2);
    
51. 
    
52. FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 6, 1, 2);
    
53. 
    
54. FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(0, 0, 1, 8);
    
55. 
    
56.   
    
57. 
    
58. // Define the label for the spanned row header cells.
    
59. 
    
60. FpSpread1.ActiveSheet.RowHeader.Cells[0,0].Text ="Branch #";
    
61. 
    
62.   
    
63. 
    
64. // Define the row header cell span.
    
65. 
    
66. FpSpread1.ActiveSheet.AddRowHeaderSpanCell(0, 0, 12, 1);
    
67. 
    
68. [Visual Basic]
    
69. 
    
70. ' Set the number of rows in the column header.
    
71. 
    
72. FpSpread1.ActiveSheet.ColumnHeader.RowCount = 3
    
73. 
    
74. ' Set the number of columns in the row header.
    
75. 
    
76. FpSpread1.ActiveSheet.RowHeader.ColumnCount = 2
    
77. 
    
78.   
    
79. 
    
80. ' Define the labels for the spanned column header cells.
    
81. 
    
82. FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 0).Text = "East"
    
83. 
    
84. FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 1).Text = "West"
    
85. 
    
86. FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 2).Text = "East"
    
87. 
    
88. FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 3).Text = "West"
    
89. 
    
90. FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 4).Text = "East"
    
91. 
    
92. FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 5).Text = "West"
    
93. 
    
94. FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 6).Text = "East"
    
95. 
    
96. FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 7).Text = "West"
    
97. 
    
98. FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 0).Text = "1st Quarter"
    
99. 
    
100. FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 2).Text = "2nd Quarter"
     
101. 
     
102. FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 4).Text = "3rd Quarter"
     
103. 
     
104. FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 6).Text = "4th Quarter"
     
105. 
     
106. FpSpread1.ActiveSheet.ColumnHeader.Cells(0, 0).Text = "Fiscal Year 2004"
     
107. 
     
108.   
     
109. 
     
110. ' Define the column header cell spans.
     
111. 
     
112. FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 0, 1, 2)
     
113. 
     
114. FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 2, 1, 2)
     
115. 
     
116. FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 4, 1, 2)
     
117. 
     
118. FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 6, 1, 2)
     
119. 
     
120. FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(0, 0, 1, 8)
     
121. 
     
122.   
     
123. 
     
124. ' Define the label for the spanned row header cells.
     
125. 
     
126. FpSpread1.ActiveSheet.RowHeader.Cells(0,0).Text ="Branch #"
     
127. 
     
128.   
     
129. 
     
130. ' Define the row header cell span.
     
131. 
     
132. FpSpread1.ActiveSheet.AddRowHeaderSpanCell(0, 0, 12, 1)
     
133. 
     

复制代码