摘要
Excel 2007在日常办公方面应用较普遍,但是在合并多个单元格时,只能保留选择区域最左上角的单元格数据,其他单元格的数据将被丢弃。针对工作中在合并单元格时,需要保留选择区域所有单元格的数据,在此提出基于VBA对Excel 2007二次开发,结合Excel 2007对象模型Application对象的属性,设计合并单元格控件的方法。在Windows XPSP3+Office 2007环境下,设计并开发出控件,实现了合并多个单元格,保留选择区域数据,解决了工作中的实际问题。
Excel 2007 has been widely applied in peoptes daily life,but there are also some problems.When merging multiple cells,just the cells on the very top left can be maintained and all the other cells are deleted.However,All the data of the cells in the selected area need be kept during the mergence of cells.The re-development of Excel 2007 is proposed based on VBA.The control widget of merging the cells is designed in combination with Excel 2007 objective mode and application object′s properties.Under the condition of Windows XP SP3＋Office 2007,the merging of multiple cells and the keeping of data in the selecting area are implemented by designing and developing control widget.
出处
《现代电子技术》
2010年第10期55-57,62,共4页
Modern Electronics Technique
