日期:2014-05-20  浏览次数:20793 次

简单EXCEL问题,送分
如何获取EXCEL单个单元格的坐标,如1行1列的:   A1

------解决方案--------------------
objSheet = (Excel._Worksheet)(objSheets.get_Item(1));
objRange = objSheet.get_Range( "A1 ", objOpt);
objRange.set_Value(objOpt, "Last Name ");
objRange = objSheet.get_Range( "B1 ", objOpt);
objRange.set_Value(objOpt, "First Name ");
objRange = objSheet.get_Range( "A2 ", objOpt);
objRange.set_Value(objOpt, "shao ");
objRange = objSheet.get_Range( "B2 ", objOpt);
objRange.set_Value(objOpt, "zhidong ");

// Apply bold to cells A1:B1.
objRange = objSheet.get_Range( "A1 ", "B1 ");
objFont = objRange.Font;
objFont.Bold=true;