DataSet导出Execl格式问题

Question

导出表中编号和数量两列，要求5列，先每列排10个，再换一列，比如有63条记录则导出后的样子为
编号  数量  编号  数量  编号  数量  编号  数量  编号  数量  
1            11          21           31          41
2            12          22           32          42
3            13          23           33          43
4            14          24           34          44
5            15          25           35          45
6            16          26           36          46
7            17          27           37          47
8            18          28           38          48
9            19          29           39          49
10           20          30           40          50
51           61                     
52           62          
53           63          
54            
55          
56          
67           
58
59
60

Answer 1

楼主求代码？这个只是逻辑问题，如果你知道怎么导出Excel，用判断很容易就搞定了，遇事多想想。