日期:2014-05-18  浏览次数:21143 次

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.