简单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;