Page History

          //--- Open theExcelApplication workbookxla and= worksheet from which we will copy cells.
          new ExcelApplication();
            Workbook sourceWb = xla.Open(ExcelApplication.FileFormat.Xlsx)Page.MapPath("myfile.xlsx"));
                      Worksheet sourceWs = sourceWb[0];

                      //--- Create the workbook and and get the worksheet
                      //--- into which we will paste cells.
                      Workbook destWb = xla.Create("MyNewWorkbook"ExcelApplication.FileFormat.Xlsx);
                      Worksheet destWs = destWb[0];

                      //--- Define the area of cells to copy.
                      Area srcArea = sourceWs.CreateArea("A1:F20");

                      //--- Copy cell values, formulas and cell and number formatting.
                      CopyPasteProperties copyPasteProps =
                                sourceWb.CreateCopyPasteProperties(
                                CopyPasteProperties.CopyPasteType.ValuesFormulasAndFormattingValuesAndFormatting);

                      //--- Paste the data onto the destination worksheet.
                      destWs.CopyPaste(0, 0, srcArea, copyPasteProps);

            xla.Save(destWb, Page.Response, "copypasteoutput.xlsx", false);
        

          '--- Open the workbook and worksheet from which we will copy cells.
          Dim sourceWb As Workbook = xla.Open("MyDataSource.xls")
          Dim sourceWs As Worksheet = sourceWb(0)

          '--- Create the workbook and and get the worksheet
          '--- into which we will paste cells.
          Dim destWb As Workbook = xla.Create("MyNewWorkbook")
          Dim destWs As Worksheet = destWb(0)

          '--- Define the area of cells to copy.
          Dim srcArea As Area = sourceWs.CreateArea("A1:F20")

          '--- Copy cell values, formulas and cell and number formatting.
          Dim copyPasteProps As CopyPasteProperties = _
               sourceWb.CreateCopyPasteProperties( _
               CopyPasteProperties.CopyPasteType.ValueFormulasAndFormatting)

          '--- Paste the data onto the destination worksheet.
          destWs.CopyPaste(0, 0, srcArea, copyPasteProps)