public void ConvertFile(string file, string folderSave) { var loader = new ElectroExcelProjectLoader { FieldsToCaptions = new Dictionary<Field, string> { {Field.ParentDesignation, "КодПП"}, {Field.ParentName, "НаимПП"}, {Field.NumberBySpec, "Поз"}, {Field.Designation, "Код"}, {Field.Name, "Наимен."}, {Field.CountByOne, "На 1 едПП"}, {Field.CountByAll, "КолЕИ по ветке"}, {Field.Size, "pardimstd"}, {Field.InfoAboutZag, "Наимен."}, {Field.ClearWeigthDetail, "чистый вес"}, {Field.WeigthByAll, "КолЕИ по ветке"}, {Field.WeigthByOne, "На 1 едПП"} } }; var sss = new RollUpElectroExcelProject { IncludeDebugInfo = WriteDebugColumn, Normalizer = new FieldsNormalizer() }; var excelProject = loader.LoadStructureProject(file); if (WriteDebugFiles) ExportToExcel(excelProject, folderSave, file, "без изм. "); sss.FilterExcelProject(excelProject); if (WriteDebugFiles) ExportToExcel(excelProject, folderSave, file, "фильтр. "); var rolled = sss.ConvertElectoExcelToDkExcel(excelProject); if (WriteDebugFiles) ExportToExcel(rolled, folderSave, file, "без изм. конв. "); sss.ConvertInfoAbooutZagToAll(rolled); if (WriteDebugFiles) ExportToExcel(rolled, folderSave, file, "конв. мат. "); sss.ClearUnusableInfoAll(rolled); if (WriteDebugFiles) ExportToExcel(rolled, folderSave, file, "чист. ст. "); sss.RecalculateWeigthsAll(rolled); sss.RecalculateWeigtsWithAllChildrens(rolled); if (WriteDebugFiles) ExportToExcel(rolled, folderSave, file, "перес. вес "); sss.ConvertSize(rolled); ExportToExcel(rolled, folderSave, file, "оконч. "); }
public void MergeFiles(List<string> files, string folder) { var excelProjects = files.Select(file => new ExcelProjectLoaderWithoutHeader(new FileGetter() {FileName = file})).Select(excelLoader => excelLoader.LoadStructureProject()).ToList(); var mergedExcelProject = new ExcelProject { Row = new object[18], Positions = excelProjects }; mergedExcelProject.Row[13] = 1; mergedExcelProject.Row[14] = 1; ExportToExcel(mergedExcelProject, folder, "Объединённый файл.xlsx", string.Empty); var sss = new RollUpElectroExcelProject(); sss.RecalculateWeigtsWithAllChildrens(mergedExcelProject); ExportToExcel(mergedExcelProject, folder, "Пересчитанный объединённый файл.xlsx", string.Empty); }