sheet.get_range(cell1,cell2)的问题
sheet.getrange(cell1,cell2)当cell1和cell2相同的时候,给他赋值也就是sheet.get_range(cell1,cell1).Value2=str_name,这个是什么意思啊?range.value2是表示range中的第二个单元格吗?
------解决方案--------------------
当cell1和cell2相同的时候,就是只操作一个格子!
------解决方案--------------------
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.range.value2(office.11).aspx
Excel Primary Interop Assembly Reference
Range.Value2 Property
Returns or sets the cell value.
Remarks The only difference between this property and the
Value property is that the
Value2 property doesn’t use the
Currency and
Date data types. You can return values formatted with these data types as floating-point numbers by using the
Double data type.