//validate excel schema by given json public bool ValidateSchema() { var helper = new ExcelFileContext(Workbook.Path); var sheetPresents = helper.PrepareAndGetSheetsPresent(Workbook.Sheets); var context = new WorkBookSchemaContext(); return(context.ValidateSchema(sheetPresents, Workbook)); }
/// <summary> /// Заполнить лист данными /// </summary> /// <param name="progress"></param> /// <param name="worksheet"></param> /// <param name="table"></param> private void FillWorksheet(ExcelExportProgressCommand progress, dynamic worksheet, object[,] table) { var rangeTo = string.Format("{0}:{1}", (table.GetLength(0) + 1), (table.GetLength(1) + 1)); var r = worksheet.Range["1:1", rangeTo]; r.NumberFormat = "@"; var colors = new Color[Rows, Columns]; ThreadUtils.SafeCall(() => MixCellWithRowColors(colors)); DecorateWorksheetCells(progress, worksheet, colors); progress.CurrentStep = 3; using (var context = new ExcelFileContext(worksheet)) context.Sign(); }