Copy one sheet from one workbook Microsoft Excel to another workbook Microsoft Excel C#

Jul 23, 2014 at 1:16 PM
Copy one sheet from one workbook Microsoft Excel to another workbook Microsoft Excel (using NPOI Library)

In COM Excel:

Excel.Application xlApp=null;
Excel.Workbook xlWbSource ,xlWbTarget;
try {    xlApp = new Excel.Application();
    xlWbSource = xlApp.Workbooks.Open(@"D:\\table_2014.xls");
    xlWbTarget = xlApp.Workbooks.Add();
    
    (xlWbSource.Worksheets[1] as Excel.Worksheet).Copy(Before: xlWbTarget.Worksheets[1]);
    xlApp.Visible = true;
}
catch (Exception) {
    if (xlApp != null)
        xlApp.Quit();
}
And how to use this library do not know. Help me please