Copy Excel sheet1 data into another Excelsheet2

Posted by Mahendrabasutkar under C# on 6/22/2011 | Points: 10 | Views : 16288 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

How to copy Excel sheet1 data into another Excelsheet2 using C#.
Excelsheet2 does not exist initially, we need to create it.But how to do both the scenarios.

Thanks&Regards
mahendrabasutkar

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Lakn2 on: 6/22/2011 [Member] Starter | Points: 25

0	try this http://support.microsoft.com/kb/306023 Thanks&Regards LakshmiNarayana Nalluri. Mahendrabasutkar, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Naimishforu on: 6/22/2011 [Member] [MVP] Bronze | Points: 25

0	Dim objExcelApplication As New Microsoft.Office.Interop.Excel.Application Dim objWorkBook As Microsoft.Office.Interop.Excel.Workbook Dim objWorkSheet As Microsoft.Office.Interop.Excel.Worksheet Dim objRange As Microsoft.Office.Interop.Excel.Range objWorkBook.Sheets(1).Copy(After:=objWorkBook.Sheets(2)) Mahendrabasutkar, if this helps please login to Mark As Answer. \| Alert Moderator

        Dim objExcelApplication As New Microsoft.Office.Interop.Excel.Application

        Dim objWorkBook As Microsoft.Office.Interop.Excel.Workbook

        Dim objWorkSheet As Microsoft.Office.Interop.Excel.Worksheet

        Dim objRange As Microsoft.Office.Interop.Excel.Range



        objWorkBook.Sheets(1).Copy(After:=objWorkBook.Sheets(2))

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Susanthampy on: 6/22/2011 [Member] [MVP] Bronze | Points: 25

0	Hi, http://blogs.tech-recipes.com/shamanstears/2007/10/19/excel-copy-or-move-worksheets-from-one-workbook-to-another/ http://en.allexperts.com/q/Excel-1059/2011/5/Sheet2-Sheet1-1.htm http://en.allexperts.com/q/Excel-1059/2011/5/Sheet2-Sheet1.htm Regards, Susan Mahendrabasutkar, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Karthikanbarasan on: 6/22/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

0	try these links http://support.microsoft.com/kb/306023 http://support.microsoft.com/kb/306022 Thanks Karthik www.f5Debug.net Mahendrabasutkar, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts