You must Sign In to post a response.
  • Category: ASP.NET

    Copy one Excel column which is having values to another excel by C#

    Copy one Excel column which is having values to another excel by C#. For example

    Excel 1

    EmployeeId EmployeeFirstName EmployeeLastName
    1000 David Anotony
    1002 Robert

    Expected result in Excel 2

    EmployeeId EmployeeFirstName EmployeeLastName EmployeeSalary EmployeeAddress
    1000 David Anotony
    1002 Robert

    Compare the columnname and if its have value, then copy it into Excel1 to Excel 2
  • #757824
    i will do it Like this

    i will read the Excel data into Dataset and bind it Grid
    and Convert that Grid into Excel. Converting the Grid to Excel is easy and you will find numerous examples in google search

    You can take the Dyanmic GridView to bind the First Excel

    SRI RAMA PHANI BHUSHAN KAMBHAMPATI

  • #757941
    Dear Jayaraj,

    Kindly go through the below mentioned links. It may guide you lot.

    1.http://www.dnzone.com/forum/topic/924/

    2.http://stackoverflow.com/questions/25463453/copying-of-specific-range-of-excel-cells-from-one-worksheet-to-another-worksheet

    3.http://stackoverflow.com/questions/23538780/how-to-copy-one-worksheet-to-another-worksheet-on-within-workbook-using-aspose-c


  • Sign In to post your comments