private void CopyWayBill(WayBillDaily wayBillDaily) { int i = 0; foreach (WayBillDay item in wayBillDaily) { if (i > 0) { _excelDoc.CopyRange("A1", "CF46", "A" + ((47 * i) + 1).ToString()); } _excelDoc.setValue(6 + (47 * i), 15, item.Day); _excelDoc.setValue(4 + (47 * i), 39, GetWaBillFullNumber(i + 1)); _excelDoc.setValue(12 + (47 * i), 6, item.Driver.GetName(NameType.Full)); _excelDoc.setValue(44 + (47 * i), 16, item.Driver.GetName(NameType.Short)); _excelDoc.setValue(26 + (47 * i), 40, item.Driver.GetName(NameType.Short)); i++; } }