怎么实现合并表头

1.怎么等效的将这句代码转换到 ASP.NET中
this._activeSheetView.AddColumnHeaderSpanCell(0, 1, 2, 1);//WinForm代码
2.在ASP.net中是否有 与下面一句代码相等效的方法？
this._activeSheetView.AddRangeGroup(i + 4, groupCount, false);//WinForm代码

回复 1楼cqtk的帖子

1.ASP.NET 中合并代码如下：

1. 
   
2. FpSpread1.Sheets[0].ColumnCount = 8;
   
3. 
   
4. FpSpread1.Sheets[0].RowCount = 8;
   
5. 
   
6. // Set the number or rows and columns in the headers.
   
7. 
   
8. FpSpread1.Sheets[0].ColumnHeader.RowCount = 3;
   
9. 
   
10. FpSpread1.Sheets[0].RowHeader.ColumnCount = 2;
    
11. 
    
12. 
    
13. 
    
14. 
    
15. 
    
16. // Span the header cells as needed.
    
17. 
    
18. FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 1, 8);
    
19. 
    
20. FpSpread1.Sheets[0].RowHeaderSpanModel.Add(0,0,12,1);
    
21. 
    
22. 
    
23. 
    
24. 
    
25. 
    
26. FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 0, 1, 2);
    
27. 
    
28. FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 2, 1, 2);
    
29. 
    
30. FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 4, 1, 2);
    
31. 
    
32. FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 6, 1, 2);
    
33. 
    
34. FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 8, 1, 2);
    
35. 
    
36. 
    
37. 
    
38. 
    
39. 
    
40. // Set the labels as needed --
    
41. 
    
42. // using the Label property or the cell Text property.
    
43. 
    
44. FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "Fiscal Year 2005";
    
45. 
    
46. FpSpread1.Sheets[0].RowHeader.Cells[0, 0].Text = "Branch #";
    
47. 
    
48. 
    
49. 
    
50. 
    
51. 
    
52. 
    
53. FpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].Text = "1st Quarter";
    
54. 
    
55. FpSpread1.Sheets[0].ColumnHeader.Cells[1, 2].Text = "2nd Quarter";
    
56. 
    
57. FpSpread1.Sheets[0].ColumnHeader.Cells[1, 4].Text = "3rd Quarter";
    
58. 
    
59. FpSpread1.Sheets[0].ColumnHeader.Cells[1, 6].Text = "4th Quarter";
    
60. 
    
61. 
    
62. 
    
63. 
    
64. 
    
65. FpSpread1.Sheets[0].ColumnHeader.Cells[2, 0].Text = "East";
    
66. 
    
67. FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Text = "West";
    
68. 
    
69. FpSpread1.Sheets[0].ColumnHeader.Cells[2, 2].Text = "East";
    
70. 
    
71. FpSpread1.Sheets[0].ColumnHeader.Cells[2, 3].Text = "West";
    
72. 
    
73. FpSpread1.Sheets[0].ColumnHeader.Cells[2, 4].Text = "East";
    
74. 
    
75. FpSpread1.Sheets[0].ColumnHeader.Cells[2, 5].Text = "West";
    
76. 
    
77. FpSpread1.Sheets[0].ColumnHeader.Cells[2, 6].Text = "East";
    
78. 
    
79. FpSpread1.Sheets[0].ColumnHeader.Cells[2, 7].Text = "West";
    
80. 
    
81. 
    

复制代码

2.Spread ASP.NET 当前还无法实现这个功能。