发表于 2009-1-5 19:48
| 
鍦‥xcel涓皢杩炵画澶氬垪鐩稿悓鏁版嵁椤瑰悎骞
鍙戝竷: 2008-6-30 10:11 | 浣滆: admin | 鏌ョ湅: 31娆
鏁堟灉鍥惧涓嬶細
浠ｇ爜濡備笅锛
/**////
/// 鍚堝苟宸ヤ綔琛ㄤ腑鎸囧畾琛屾暟鍜屽垪鏁版暟鎹浉鍚岀殑鍗曞厓鏍
///
/// 宸ヤ綔琛ㄧ储寮
/// 寮濮嬭绱㈠紩
/// 寮濮嬪垪绱㈠紩
/// 瑕佸悎骞剁殑琛屾暟
/// 瑕佸悎骞剁殑鍒楁暟
public void MergeWorkSheet(int sheetIndex,int beginRowIndex,int beginColumnIndex,int rowCount,int columnCount)
{
//妫鏌ュ弬鏁
if ( columnCount < 1 || rowCount < 1)
return ;
for(int col=0;col { int mark = 0; //鏍囪姣旇緝鏁版嵁涓涓鏉¤褰曚綅缃 int mergeCount = 1; //鐩稿悓璁板綍鏁帮紝鍗宠鍚堝苟鐨勮鏁 string text = ""; for(int row=0;row { string prvName = ""; string nextName = ""; //鏈鍚庝竴琛屼笉鐢ㄦ瘮杈 if( row + 1 < rowCount) { for(int n=0;n<=col;n++) { range = (Excel.Range)workSheet.Cells[row + beginRowIndex,n + beginColumnIndex]; range = (Excel.Range)range.MergeArea.get_Item(1,1); text = range.Text.ToString(); prvName = prvName + text; range = (Excel.Range)workSheet.Cells[row + 1 + beginRowIndex,n + beginColumnIndex]; range = (Excel.Range)range.MergeArea.get_Item(1,1); nextName = nextName + range.Text.ToString();
