//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();
}
