如何使用OpenXML复制行并将其粘贴到Excel工作表的末尾 [英] How to copy rows and paste at the end of the Excel sheet using OpenXML

问题描述

大家好，

我的项目中有一个要求，我需要复制excel工作表的几部分并将其粘贴到同一工作表的另一部分中.

任何人都可以帮助我实现这一目标吗?
例如，我需要复制第1到25行并将其粘贴到第40行.

谢谢和问候，
YKK Reddy

Hi All,

I have a requirement in my project that i need to copy few parts of my excel sheet and paste it in another part of the same sheet.

Can anyone help me in achieving this ?
For example, i need to copy rows 1 through 25 and paste them at Row number 40.

Thanks and Regards,
YKK Reddy

推荐答案

解决方案可以在
找到 http://products.e-dbxml.net/openxml-spreadsheet/post/openxml-spreadsheet-copy-inser [ ^ ]

获取单元格行索引，列索引等的方法很少，这些方法必须单独编写.

The solution can be found at
http://products.e-dbxml.net/openxml-spreadsheet/post/openxml-spreadsheet-copy-inser[^]

There are few methods for getting cell row index, column index etc which has to be written separately.

这篇关于如何使用OpenXML复制行并将其粘贴到Excel工作表的末尾的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！