Copy rows from 1 sheet to another

[Paul Meems]

I'm trying to merge several Excel files into 1 cleanup file.

I have this code:

        private void ProcessWorksheet(IWorksheet worksheet)

        {

            worksheet.UsedRangeIncludesFormatting = false;

            var range = worksheet.UsedRange;

            var migrantRange = worksheet.MigrantRange;

            var regex = new Regex(@"\d{8,9}");

            for (var i = 0; i < range.LastRow; i++)

            {

                migrantRange.ResetRowColumn(i, 1);

                if (migrantRange.HasNumber && regex.Match(migrantRange.Number.ToString(CultureInfo.InvariantCulture)).Success)

                {

                    // Correct row

                    Debug.WriteLine(migrantRange.Number);

                    --> How to copy complete row to new sheet called _workSheetResult

                }

            }

        }

I know when I have the row I need to copy, but how do I copy a whole row or range?

Do I need to do it cell by cell?

[Sivaneswaran Amsu]

Hi Paul, 

Thank you for contacting Syncfusion support. 

We have shared the sample for copy from range one worksheet to another worksheet which can be downloaded from the following link. 

Sample link : http://www.syncfusion.com/downloads/support/forum/144614/ze/CopyRange-1016025253.zip  

To know more about the copy option please refer the following UG documentation link. 

UG link : https://help.syncfusion.com/file-formats/xlsio/worksheet-cells-manipulation#copy-or-move-a-range  

Please let us know if this helpful for your requirement. 

Regards, 

Sivaneswaran . A