当前位置: 代码迷 >> ASP.NET >> 怎么循环复制excel文件中的一行
  详细解决方案

怎么循环复制excel文件中的一行

热度:3210   发布时间:2013-02-26 00:00:00.0
如何循环复制excel文件中的一行
我想把excel文件的第一行循环复制到第3,5,7。。。。行
请问有没有什么办法   谢谢先

------解决方案--------------------------------------------------------
protected void Page_Load(object sender, EventArgs e)
{
ApplicationClass oExcel = new ApplicationClass();
Workbook oBook;
Worksheet oSheet;
Range originalRange, destinationRange;
string path = Server.MapPath( "../documents/test.xls ");
int i = 3;

oBook = oExcel.Workbooks.Open(path, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
oSheet = (Worksheet)oBook.Worksheets[1];

originalRange = (Range)oSheet.Rows[1, Type.Missing];

while (i < 10)
{
destinationRange = (Range)oSheet.Rows[i, Type.Missing];
i = i + 2;
originalRange.Copy(destinationRange);
}

oExcel.DisplayAlerts = false;
oBook.Save();
oExcel.Quit();

}
  相关解决方案