private void FillData(IXLWorksheet worksheet, IList <string> columns, CompareFile compareData, ExcelReportConfigurationDocument config) { var rowId = config.SkipRow + HEADER_ROW_COUNT + 1; foreach (var item in compareData.CompareItems) { FillItem(worksheet, rowId++, columns, item, config); } worksheet.Range(config.SkipRow + HEADER_ROW_COUNT + 1, config.SkipColumn + 1, rowId - 1, config.SkipColumn + 1).SetStyle(config.BorderStyle); worksheet.Range(config.SkipRow + HEADER_ROW_COUNT + 1, config.SkipColumn + 2, rowId - 1, config.SkipColumn + 1 + columns.Count).SetStyle(config.BorderStyle); worksheet.Range(config.SkipRow + HEADER_ROW_COUNT + 1, config.SkipColumn + 1 + columns.Count + 1, rowId - 1, config.SkipColumn + 1 + columns.Count * 2).SetStyle(config.BorderStyle); }
public void NewSheet(CompareFile compareData, string path1, string path2, ExcelReportConfigurationDocument config) { Preconditions.NotNull(compareData, "compareData"); Preconditions.Check(compareData.CompareItems.Count > 0, "CompareData should not be empty."); Preconditions.NotNullOrWhiteSpace(path1, "path1"); Preconditions.NotNullOrWhiteSpace(path2, "path2"); Preconditions.Check(!path1.Equals(path2, StringComparison.OrdinalIgnoreCase), "Path1 should not be same as Path2"); var columns = compareData.CompareItems.First().Data.Select(x => x.Key).ToList(); var worksheet = workbook.Worksheets.Add(compareData.FileName); OutputHeader(worksheet, columns, path1, path2, config); FillData(worksheet, columns, compareData, config); UpdateWorksheetStyles(worksheet, compareData.CompareItems.Count, columns.Count, config); }
private void compareFile(object sender, EventArgs e) { if (listView1.SelectedItems.Count > 0) { var item = listView1.Items[listView1.SelectedItems[0].Index].Tag as FileEntry; if (item.Status == EntryStateEnum.Modified) { string beforeFilePath = Path.Combine(txtFileBefore.Text, item.FileName); string afterFilePath = Path.Combine(txtFileAfter.Text, item.FileName); CompareFile form = new CompareFile(File.ReadAllText(beforeFilePath), File.ReadAllText(afterFilePath)); form.Text = string.Format("Compare {0} with {1}", beforeFilePath, afterFilePath); form.Show(); } } }
/// <summary> /// sauvegarde les données du fichier en base, compare avec la BDD et créé un rapport /// </summary> public void WorkerMethod() { string result = new CompareFile(WorkSheets).CompareTwoSheet(columnsFile1, columnsFile2); OnWorkerComplete(result); }