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?