internal void FromConditionalFormatting(X14.ConditionalFormatting cf)
{
this.SetAllNull();
if (cf.Pivot != null)
{
this.Pivot = cf.Pivot.Value;
}
using (OpenXmlReader oxr = OpenXmlReader.Create(cf))
{
while (oxr.Read())
{
SLConditionalFormattingRule2010 cfr;
if (oxr.ElementType == typeof(X14.ConditionalFormattingRule))
{
cfr = new SLConditionalFormattingRule2010();
cfr.FromConditionalFormattingRule((X14.ConditionalFormattingRule)oxr.LoadCurrentElement());
this.Rules.Add(cfr);
}
else if (oxr.ElementType == typeof(Excel.ReferenceSequence))
{
Excel.ReferenceSequence refseq = (Excel.ReferenceSequence)oxr.LoadCurrentElement();
this.ReferenceSequence = SLTool.TranslateRefSeqToCellPointRange(refseq);
}
}
}
}
static void GenerateWorksheetPartContent(WorksheetPart worksheetPart, DataTable dataTable)
{
var worksheet = new Worksheet();
var sheetData = new SheetData();
ExportDataTable(sheetData, dataTable);
worksheet.Append(sheetData);
if (dataTable.TableName != "Дата")
{
var worksheetExtensionList = new WorksheetExtensionList();
var worksheetExtension = new WorksheetExtension {
Uri = WorksheetExtensionUri
};
var dataValidations = new X14.DataValidations {
Count = (UInt32Value)1U
};
var dataValidation = new X14.DataValidation {
Type = DataValidationValues.List, AllowBlank = true, ShowInputMessage = true, ShowErrorMessage = true
};
var dataValidationForumla1 = new X14.DataValidationForumla1();
var formula = new Excel.Formula {
Text = "Дата!$B$2:$B$4"
};
dataValidationForumla1.Append(formula);
var referenceSequence = new Excel.ReferenceSequence {
Text = "F2:F4"
};
dataValidation.Append(dataValidationForumla1);
dataValidation.Append(referenceSequence);
dataValidations.Append(dataValidation);
worksheetExtension.Append(dataValidations);
worksheetExtensionList.Append(worksheetExtension);
worksheet.Append(worksheetExtensionList);
}
worksheetPart.Worksheet = worksheet;
}
