我在VC里嵌入的Excel,当鼠标选中单元格时,如何得到选中的起始行列?POSITION_INFO ob;//存储起始行列的自定义结构
IDispatch* pIDispatch;
_Workbook workbook;
_Worksheet worksheet;
Range range,Cell;pIDispatch = g_pCntrItem->GetIDispatch();
workbook.AttachDispatch(pIDispatch);
worksheet = workbook.GetActiveSheet();
range = worksheet.GetUsedRange();
Cell = range.GetColumns();
ob.icol = Cell.GetColumn();
ob.icolc = Cell.GetCount();
Cell = range.GetRows();
ob.irow = Cell.GetRow();
ob.irowc = Cell.GetCount(); 为什么得到的结果都是1??该怎么做啊????????????????????????
IDispatch* pIDispatch;
_Workbook workbook;
_Worksheet worksheet;
Range range,Cell;pIDispatch = g_pCntrItem->GetIDispatch();
workbook.AttachDispatch(pIDispatch);
worksheet = workbook.GetActiveSheet();
range = worksheet.GetUsedRange();
Cell = range.GetColumns();
ob.icol = Cell.GetColumn();
ob.icolc = Cell.GetCount();
Cell = range.GetRows();
ob.irow = Cell.GetRow();
ob.irowc = Cell.GetCount(); 为什么得到的结果都是1??该怎么做啊????????????????????????
解决方案 »
- 派生类虚函数调用基类版本时,为什么必须显式使用作用域操作符?
- 定义了类型,却提示错误的疑问
- 求救:mfc下复制文件夹!!!
- TreeItem 如何在指定位置添加节点?
- LoadIcon 第二个参数怎么换了之后不起作用呢
- vista 下用户快速切换的问题
- 抄表程序,文本框显示上下行通信数据帧问题,求思路::
- ListView上实现ToolTip怎么ToolTip一闪就没掉了
- [学习]用静态变量得到已经创建变量个数
- 请问要将一个程序作成服务有何要求?
- VC中嵌入Excel,要在Excel中时时得到选中的起始行列,如何捕捉这个消息???????????????????????
- 急等……怎么没人回答?一共300分哦
http://community.csdn.net/Expert/topic/3220/3220812.xml?temp=.830929
没人会吗????
_Application app;
_Workbook workbook;
_Worksheet worksheet;
Range range,Cell;workbook.AttachDispatch(pIDispatch);
worksheet = workbook.GetActiveSheet();
app =workbook.GetApplication();
range.AttachDispatch(app.GetSelection());
Storm 01:47:44
Cell = range.GetRows();
irow = Cell.GetRow();
irowc = Cell.GetCount();
strRowSta.Format("%d",irow);
strRowEnd.Format("%d",irow + irowc -1);
Cell = range.GetColumns();
icol = Cell.GetColumn();
icolc = Cell.GetCount();
strColSta.Format("%d",icol);
strColEnd.Format("%d",icol + icolc -1);