How copy range as an Excel workbook to another

Home ›

ASP.NET Forums » Advanced ASP.NET » Enterprise Services Integration » How copy range as an Excel workbook to another

Shortcuts

Previous Next

How copy range as an Excel workbook to another

Last post 11-01-2009 12:38 PM by atarim. 1 replies.

Sort Posts:

How copy range as an Excel workbook to another

11-01-2009, 9:44 AM

Contact

point Member
gpoliovei
Member since 10-29-2009, 2:29 AM
Posts 3

Hello everyone, I need help with the following problem

I have two files on the server to excel 2003 c:\book1.xls and c:\book2.xls

I need to copy the range A1: G8000 sheet3 of book1 to the sheet1 of Book2

I'm using vs2005 and asp net c #

I have searched far and I can not solve the problem please help

Tnx

Re: How copy range as an Excel workbook to another

11-01-2009, 12:38 PM

Contact

101 point Member
atarim
Member since 07-24-2006, 5:55 AM
Kuwait
Posts 25

You have ways to do this, read below ways

1- use a excel object to do it as below

Range("A1:D1").Select

Selection.Copy

Windows("Book2").Activate

ActiveSheet.Paste

2- SQL : select from sheet1 into datatable and Select from sheet 2 into other datatable and merge the two datatables

Mark as answer if you find this will help you
Best regards,

Mohammed Al-Atari
Sr. System Analyst - Team Leader
GSM Tel. : (965) 9 7150054
My Space: http://al-atari.spaces.live.com/
My Blog : http://www.al-atari.net

Page 1 of 1 (2 items)

RSS Available