private static void GenerateTableDefinitionPartContent(TableDefinitionPart tableDefinitionPart, XLTable xlTable,
SaveContext context)
{
context.TableId++;
var reference = xlTable.RangeAddress.FirstAddress + ":" + xlTable.RangeAddress.LastAddress;
var tableName = GetTableName(xlTable.Name, context);
var table = new Table
{
Id = context.TableId,
Name = tableName,
DisplayName = tableName,
Reference = reference
};
if (!xlTable.ShowHeaderRow)
table.HeaderRowCount = 0;
if (xlTable.ShowTotalsRow)
table.TotalsRowCount = 1;
else
table.TotalsRowShown = false;
var tableColumns1 = new TableColumns {Count = (UInt32)xlTable.ColumnCount()};
UInt32 columnId = 0;
foreach (var fieldName in xlTable.FieldNames.Keys)
{
columnId++;
var xlField = xlTable.Field(fieldName);
var tableColumn1 = new TableColumn
{
Id = columnId,
Name = fieldName.Replace("_x000a_", "_x005f_x000a_").Replace(Environment.NewLine, "_x000a_")
};
if (xlTable.ShowTotalsRow)
{
if (xlField.TotalsRowFunction != XLTotalsRowFunction.None)
{
tableColumn1.TotalsRowFunction = xlField.TotalsRowFunction.ToOpenXml();
if (xlField.TotalsRowFunction == XLTotalsRowFunction.Custom)
tableColumn1.TotalsRowFormula = new TotalsRowFormula(xlField.TotalsRowFormulaA1);
}
if (!XLHelper.IsNullOrWhiteSpace(xlField.TotalsRowLabel))
tableColumn1.TotalsRowLabel = xlField.TotalsRowLabel;
}
tableColumns1.AppendChild(tableColumn1);
}
var tableStyleInfo1 = new TableStyleInfo
{
ShowFirstColumn = xlTable.EmphasizeFirstColumn,
ShowLastColumn = xlTable.EmphasizeLastColumn,
ShowRowStripes = xlTable.ShowRowStripes,
ShowColumnStripes = xlTable.ShowColumnStripes
};
if (xlTable.Theme != XLTableTheme.None)
tableStyleInfo1.Name = Enum.GetName(typeof(XLTableTheme), xlTable.Theme);
if (xlTable.ShowAutoFilter)
{
var autoFilter1 = new AutoFilter();
if (xlTable.ShowTotalsRow)
{
xlTable.AutoFilter.Range = xlTable.Worksheet.Range(
xlTable.RangeAddress.FirstAddress.RowNumber, xlTable.RangeAddress.FirstAddress.ColumnNumber,
xlTable.RangeAddress.LastAddress.RowNumber - 1, xlTable.RangeAddress.LastAddress.ColumnNumber);
}
else
xlTable.AutoFilter.Range = xlTable.Worksheet.Range(xlTable.RangeAddress);
PopulateAutoFilter(xlTable.AutoFilter, autoFilter1);
table.AppendChild(autoFilter1);
}
table.AppendChild(tableColumns1);
table.AppendChild(tableStyleInfo1);
tableDefinitionPart.Table = table;
}
/// <summary>
/// Create an instance of OpenXmlPart according to the given relationship type.
/// </summary>
/// <param name="openXmlPackage">The container OpenXmlPackage.</param>
/// <param name="relationshipType">The relationship type of the target part.</param>
/// <param name="openXmlPart">The created instance of OpenXmlPart.</param>
/// <remarks>This partial method will be generated by code generaotr.</remarks>
static partial void CreatePartCore(OpenXmlPackage openXmlPackage, string relationshipType, ref OpenXmlPart openXmlPart)
{
if (openXmlPackage == null)
{
throw new ArgumentNullException("openXmlPackage");
}
if (relationshipType == null)
{
throw new ArgumentNullException("relationshipType");
}
if (openXmlPackage is WordprocessingDocument)
{
switch (relationshipType)
{
case MainDocumentPart.RelationshipTypeConstant:
openXmlPart = new MainDocumentPart();
return;
case CustomXmlPart.RelationshipTypeConstant:
openXmlPart = new CustomXmlPart();
return;
case CustomXmlPropertiesPart.RelationshipTypeConstant:
openXmlPart = new CustomXmlPropertiesPart();
return;
case GlossaryDocumentPart.RelationshipTypeConstant:
openXmlPart = new GlossaryDocumentPart();
return;
case WordprocessingCommentsPart.RelationshipTypeConstant:
openXmlPart = new WordprocessingCommentsPart();
return;
case AlternativeFormatImportPart.RelationshipTypeConstant:
openXmlPart = new AlternativeFormatImportPart();
return;
case ChartPart.RelationshipTypeConstant:
openXmlPart = new ChartPart();
return;
case ChartDrawingPart.RelationshipTypeConstant:
openXmlPart = new ChartDrawingPart();
return;
case ImagePart.RelationshipTypeConstant:
openXmlPart = new ImagePart();
return;
case EmbeddedPackagePart.RelationshipTypeConstant:
openXmlPart = new EmbeddedPackagePart();
return;
case ThemeOverridePart.RelationshipTypeConstant:
openXmlPart = new ThemeOverridePart();
return;
case ChartStylePart.RelationshipTypeConstant:
openXmlPart = new ChartStylePart();
return;
case ChartColorStylePart.RelationshipTypeConstant:
openXmlPart = new ChartColorStylePart();
return;
case DiagramColorsPart.RelationshipTypeConstant:
openXmlPart = new DiagramColorsPart();
return;
case DiagramDataPart.RelationshipTypeConstant:
openXmlPart = new DiagramDataPart();
return;
case SlidePart.RelationshipTypeConstant:
openXmlPart = new SlidePart();
return;
case DiagramPersistLayoutPart.RelationshipTypeConstant:
openXmlPart = new DiagramPersistLayoutPart();
return;
case DiagramLayoutDefinitionPart.RelationshipTypeConstant:
openXmlPart = new DiagramLayoutDefinitionPart();
return;
case DiagramStylePart.RelationshipTypeConstant:
openXmlPart = new DiagramStylePart();
return;
case EmbeddedObjectPart.RelationshipTypeConstant:
openXmlPart = new EmbeddedObjectPart();
return;
case VmlDrawingPart.RelationshipTypeConstant:
openXmlPart = new VmlDrawingPart();
return;
case LegacyDiagramTextPart.RelationshipTypeConstant:
openXmlPart = new LegacyDiagramTextPart();
return;
case EmbeddedControlPersistenceBinaryDataPart.RelationshipTypeConstant:
openXmlPart = new EmbeddedControlPersistenceBinaryDataPart();
return;
case NotesSlidePart.RelationshipTypeConstant:
openXmlPart = new NotesSlidePart();
return;
case NotesMasterPart.RelationshipTypeConstant:
openXmlPart = new NotesMasterPart();
return;
case ThemePart.RelationshipTypeConstant:
openXmlPart = new ThemePart();
return;
case UserDefinedTagsPart.RelationshipTypeConstant:
openXmlPart = new UserDefinedTagsPart();
return;
case SlideLayoutPart.RelationshipTypeConstant:
openXmlPart = new SlideLayoutPart();
return;
case SlideMasterPart.RelationshipTypeConstant:
openXmlPart = new SlideMasterPart();
return;
case EmbeddedControlPersistencePart.RelationshipTypeConstant:
openXmlPart = new EmbeddedControlPersistencePart();
return;
case SlideSyncDataPart.RelationshipTypeConstant:
openXmlPart = new SlideSyncDataPart();
return;
case WorksheetPart.RelationshipTypeConstant:
openXmlPart = new WorksheetPart();
return;
case DrawingsPart.RelationshipTypeConstant:
openXmlPart = new DrawingsPart();
return;
case WebExtensionPart.RelationshipTypeConstant:
openXmlPart = new WebExtensionPart();
return;
case PivotTablePart.RelationshipTypeConstant:
openXmlPart = new PivotTablePart();
return;
case PivotTableCacheDefinitionPart.RelationshipTypeConstant:
openXmlPart = new PivotTableCacheDefinitionPart();
return;
case PivotTableCacheRecordsPart.RelationshipTypeConstant:
openXmlPart = new PivotTableCacheRecordsPart();
return;
case SingleCellTablePart.RelationshipTypeConstant:
openXmlPart = new SingleCellTablePart();
return;
case TableDefinitionPart.RelationshipTypeConstant:
openXmlPart = new TableDefinitionPart();
return;
case QueryTablePart.RelationshipTypeConstant:
openXmlPart = new QueryTablePart();
return;
case ControlPropertiesPart.RelationshipTypeConstant:
openXmlPart = new ControlPropertiesPart();
return;
case CustomPropertyPart.RelationshipTypeConstant:
openXmlPart = new CustomPropertyPart();
return;
case WorksheetSortMapPart.RelationshipTypeConstant:
openXmlPart = new WorksheetSortMapPart();
return;
case SlicersPart.RelationshipTypeConstant:
openXmlPart = new SlicersPart();
return;
case TimeLinePart.RelationshipTypeConstant:
openXmlPart = new TimeLinePart();
return;
case DocumentSettingsPart.RelationshipTypeConstant:
openXmlPart = new DocumentSettingsPart();
return;
case MailMergeRecipientDataPart.RelationshipTypeConstant:
openXmlPart = new MailMergeRecipientDataPart();
return;
case EndnotesPart.RelationshipTypeConstant:
openXmlPart = new EndnotesPart();
return;
case FontTablePart.RelationshipTypeConstant:
openXmlPart = new FontTablePart();
return;
case FontPart.RelationshipTypeConstant:
openXmlPart = new FontPart();
return;
case FootnotesPart.RelationshipTypeConstant:
openXmlPart = new FootnotesPart();
return;
case NumberingDefinitionsPart.RelationshipTypeConstant:
openXmlPart = new NumberingDefinitionsPart();
return;
case StyleDefinitionsPart.RelationshipTypeConstant:
openXmlPart = new StyleDefinitionsPart();
return;
case StylesWithEffectsPart.RelationshipTypeConstant:
openXmlPart = new StylesWithEffectsPart();
return;
case WebSettingsPart.RelationshipTypeConstant:
openXmlPart = new WebSettingsPart();
return;
case FooterPart.RelationshipTypeConstant:
openXmlPart = new FooterPart();
return;
case HeaderPart.RelationshipTypeConstant:
openXmlPart = new HeaderPart();
return;
case WordprocessingPrinterSettingsPart.RelationshipTypeConstant:
openXmlPart = new WordprocessingPrinterSettingsPart();
return;
case CustomizationPart.RelationshipTypeConstant:
openXmlPart = new CustomizationPart();
return;
case WordAttachedToolbarsPart.RelationshipTypeConstant:
openXmlPart = new WordAttachedToolbarsPart();
return;
case VbaProjectPart.RelationshipTypeConstant:
openXmlPart = new VbaProjectPart();
return;
case VbaDataPart.RelationshipTypeConstant:
openXmlPart = new VbaDataPart();
return;
case WordprocessingCommentsExPart.RelationshipTypeConstant:
openXmlPart = new WordprocessingCommentsExPart();
return;
case WordprocessingPeoplePart.RelationshipTypeConstant:
openXmlPart = new WordprocessingPeoplePart();
return;
case ThumbnailPart.RelationshipTypeConstant:
openXmlPart = new ThumbnailPart();
return;
case CoreFilePropertiesPart.RelationshipTypeConstant:
openXmlPart = new CoreFilePropertiesPart();
return;
case ExtendedFilePropertiesPart.RelationshipTypeConstant:
openXmlPart = new ExtendedFilePropertiesPart();
return;
case CustomFilePropertiesPart.RelationshipTypeConstant:
openXmlPart = new CustomFilePropertiesPart();
return;
case DigitalSignatureOriginPart.RelationshipTypeConstant:
openXmlPart = new DigitalSignatureOriginPart();
return;
case XmlSignaturePart.RelationshipTypeConstant:
openXmlPart = new XmlSignaturePart();
return;
case QuickAccessToolbarCustomizationsPart.RelationshipTypeConstant:
openXmlPart = new QuickAccessToolbarCustomizationsPart();
return;
case RibbonExtensibilityPart.RelationshipTypeConstant:
openXmlPart = new RibbonExtensibilityPart();
return;
case RibbonAndBackstageCustomizationsPart.RelationshipTypeConstant:
openXmlPart = new RibbonAndBackstageCustomizationsPart();
return;
case WebExTaskpanesPart.RelationshipTypeConstant:
openXmlPart = new WebExTaskpanesPart();
return;
}
}
else if (openXmlPackage is SpreadsheetDocument)
{
switch (relationshipType)
{
case WorkbookPart.RelationshipTypeConstant:
openXmlPart = new WorkbookPart();
return;
case CustomXmlPart.RelationshipTypeConstant:
openXmlPart = new CustomXmlPart();
return;
case CustomXmlPropertiesPart.RelationshipTypeConstant:
openXmlPart = new CustomXmlPropertiesPart();
return;
case CalculationChainPart.RelationshipTypeConstant:
openXmlPart = new CalculationChainPart();
return;
case CellMetadataPart.RelationshipTypeConstant:
openXmlPart = new CellMetadataPart();
return;
case ConnectionsPart.RelationshipTypeConstant:
openXmlPart = new ConnectionsPart();
return;
case CustomXmlMappingsPart.RelationshipTypeConstant:
openXmlPart = new CustomXmlMappingsPart();
return;
case SharedStringTablePart.RelationshipTypeConstant:
openXmlPart = new SharedStringTablePart();
return;
case WorkbookRevisionHeaderPart.RelationshipTypeConstant:
openXmlPart = new WorkbookRevisionHeaderPart();
return;
case WorkbookRevisionLogPart.RelationshipTypeConstant:
openXmlPart = new WorkbookRevisionLogPart();
return;
case WorkbookUserDataPart.RelationshipTypeConstant:
openXmlPart = new WorkbookUserDataPart();
return;
case WorkbookStylesPart.RelationshipTypeConstant:
openXmlPart = new WorkbookStylesPart();
return;
case ThemePart.RelationshipTypeConstant:
openXmlPart = new ThemePart();
return;
case ImagePart.RelationshipTypeConstant:
openXmlPart = new ImagePart();
return;
case ThumbnailPart.RelationshipTypeConstant:
openXmlPart = new ThumbnailPart();
return;
case VolatileDependenciesPart.RelationshipTypeConstant:
openXmlPart = new VolatileDependenciesPart();
return;
case ChartsheetPart.RelationshipTypeConstant:
openXmlPart = new ChartsheetPart();
return;
case SpreadsheetPrinterSettingsPart.RelationshipTypeConstant:
openXmlPart = new SpreadsheetPrinterSettingsPart();
return;
case DrawingsPart.RelationshipTypeConstant:
openXmlPart = new DrawingsPart();
return;
case ChartPart.RelationshipTypeConstant:
openXmlPart = new ChartPart();
return;
case ChartDrawingPart.RelationshipTypeConstant:
openXmlPart = new ChartDrawingPart();
return;
case EmbeddedPackagePart.RelationshipTypeConstant:
openXmlPart = new EmbeddedPackagePart();
return;
case ThemeOverridePart.RelationshipTypeConstant:
openXmlPart = new ThemeOverridePart();
return;
case ChartStylePart.RelationshipTypeConstant:
openXmlPart = new ChartStylePart();
return;
case ChartColorStylePart.RelationshipTypeConstant:
openXmlPart = new ChartColorStylePart();
return;
case DiagramColorsPart.RelationshipTypeConstant:
openXmlPart = new DiagramColorsPart();
return;
case DiagramDataPart.RelationshipTypeConstant:
openXmlPart = new DiagramDataPart();
return;
case SlidePart.RelationshipTypeConstant:
openXmlPart = new SlidePart();
return;
case DiagramPersistLayoutPart.RelationshipTypeConstant:
openXmlPart = new DiagramPersistLayoutPart();
return;
case DiagramLayoutDefinitionPart.RelationshipTypeConstant:
openXmlPart = new DiagramLayoutDefinitionPart();
return;
case DiagramStylePart.RelationshipTypeConstant:
openXmlPart = new DiagramStylePart();
return;
case EmbeddedObjectPart.RelationshipTypeConstant:
openXmlPart = new EmbeddedObjectPart();
return;
case VmlDrawingPart.RelationshipTypeConstant:
openXmlPart = new VmlDrawingPart();
return;
case LegacyDiagramTextPart.RelationshipTypeConstant:
openXmlPart = new LegacyDiagramTextPart();
return;
case EmbeddedControlPersistenceBinaryDataPart.RelationshipTypeConstant:
openXmlPart = new EmbeddedControlPersistenceBinaryDataPart();
return;
case NotesSlidePart.RelationshipTypeConstant:
openXmlPart = new NotesSlidePart();
return;
case NotesMasterPart.RelationshipTypeConstant:
openXmlPart = new NotesMasterPart();
return;
case UserDefinedTagsPart.RelationshipTypeConstant:
openXmlPart = new UserDefinedTagsPart();
return;
case SlideLayoutPart.RelationshipTypeConstant:
openXmlPart = new SlideLayoutPart();
return;
case SlideMasterPart.RelationshipTypeConstant:
openXmlPart = new SlideMasterPart();
return;
case EmbeddedControlPersistencePart.RelationshipTypeConstant:
openXmlPart = new EmbeddedControlPersistencePart();
return;
case SlideSyncDataPart.RelationshipTypeConstant:
openXmlPart = new SlideSyncDataPart();
return;
case WorksheetPart.RelationshipTypeConstant:
openXmlPart = new WorksheetPart();
return;
case WorksheetCommentsPart.RelationshipTypeConstant:
openXmlPart = new WorksheetCommentsPart();
return;
case PivotTablePart.RelationshipTypeConstant:
openXmlPart = new PivotTablePart();
return;
case PivotTableCacheDefinitionPart.RelationshipTypeConstant:
openXmlPart = new PivotTableCacheDefinitionPart();
return;
case PivotTableCacheRecordsPart.RelationshipTypeConstant:
openXmlPart = new PivotTableCacheRecordsPart();
return;
case SingleCellTablePart.RelationshipTypeConstant:
openXmlPart = new SingleCellTablePart();
return;
case TableDefinitionPart.RelationshipTypeConstant:
openXmlPart = new TableDefinitionPart();
return;
case QueryTablePart.RelationshipTypeConstant:
openXmlPart = new QueryTablePart();
return;
case ControlPropertiesPart.RelationshipTypeConstant:
openXmlPart = new ControlPropertiesPart();
return;
case CustomPropertyPart.RelationshipTypeConstant:
openXmlPart = new CustomPropertyPart();
return;
case WorksheetSortMapPart.RelationshipTypeConstant:
openXmlPart = new WorksheetSortMapPart();
return;
case SlicersPart.RelationshipTypeConstant:
openXmlPart = new SlicersPart();
return;
case TimeLinePart.RelationshipTypeConstant:
openXmlPart = new TimeLinePart();
return;
case WebExtensionPart.RelationshipTypeConstant:
openXmlPart = new WebExtensionPart();
return;
case DialogsheetPart.RelationshipTypeConstant:
openXmlPart = new DialogsheetPart();
return;
case ExternalWorkbookPart.RelationshipTypeConstant:
openXmlPart = new ExternalWorkbookPart();
return;
case ExcelAttachedToolbarsPart.RelationshipTypeConstant:
openXmlPart = new ExcelAttachedToolbarsPart();
return;
case VbaProjectPart.RelationshipTypeConstant:
openXmlPart = new VbaProjectPart();
return;
case VbaDataPart.RelationshipTypeConstant:
openXmlPart = new VbaDataPart();
return;
case MacroSheetPart.RelationshipTypeConstant:
openXmlPart = new MacroSheetPart();
return;
case InternationalMacroSheetPart.RelationshipTypeConstant:
openXmlPart = new InternationalMacroSheetPart();
return;
case CustomDataPropertiesPart.RelationshipTypeConstant:
openXmlPart = new CustomDataPropertiesPart();
return;
case CustomDataPart.RelationshipTypeConstant:
openXmlPart = new CustomDataPart();
return;
case SlicerCachePart.RelationshipTypeConstant:
openXmlPart = new SlicerCachePart();
return;
case TimeLineCachePart.RelationshipTypeConstant:
openXmlPart = new TimeLineCachePart();
return;
case CoreFilePropertiesPart.RelationshipTypeConstant:
openXmlPart = new CoreFilePropertiesPart();
return;
case ExtendedFilePropertiesPart.RelationshipTypeConstant:
openXmlPart = new ExtendedFilePropertiesPart();
return;
case CustomFilePropertiesPart.RelationshipTypeConstant:
openXmlPart = new CustomFilePropertiesPart();
return;
case DigitalSignatureOriginPart.RelationshipTypeConstant:
openXmlPart = new DigitalSignatureOriginPart();
return;
case XmlSignaturePart.RelationshipTypeConstant:
openXmlPart = new XmlSignaturePart();
return;
case QuickAccessToolbarCustomizationsPart.RelationshipTypeConstant:
openXmlPart = new QuickAccessToolbarCustomizationsPart();
return;
case RibbonExtensibilityPart.RelationshipTypeConstant:
openXmlPart = new RibbonExtensibilityPart();
return;
case RibbonAndBackstageCustomizationsPart.RelationshipTypeConstant:
openXmlPart = new RibbonAndBackstageCustomizationsPart();
return;
case WebExTaskpanesPart.RelationshipTypeConstant:
openXmlPart = new WebExTaskpanesPart();
return;
}
}
else if (openXmlPackage is PresentationDocument)
{
switch (relationshipType)
{
case PresentationPart.RelationshipTypeConstant:
openXmlPart = new PresentationPart();
return;
case CustomXmlPart.RelationshipTypeConstant:
openXmlPart = new CustomXmlPart();
return;
case CustomXmlPropertiesPart.RelationshipTypeConstant:
openXmlPart = new CustomXmlPropertiesPart();
return;
case FontPart.RelationshipTypeConstant:
openXmlPart = new FontPart();
return;
case PresentationPropertiesPart.RelationshipTypeConstant:
openXmlPart = new PresentationPropertiesPart();
return;
case TableStylesPart.RelationshipTypeConstant:
openXmlPart = new TableStylesPart();
return;
case ThemePart.RelationshipTypeConstant:
openXmlPart = new ThemePart();
return;
case ImagePart.RelationshipTypeConstant:
openXmlPart = new ImagePart();
return;
case ViewPropertiesPart.RelationshipTypeConstant:
openXmlPart = new ViewPropertiesPart();
return;
case SlidePart.RelationshipTypeConstant:
openXmlPart = new SlidePart();
return;
case ChartPart.RelationshipTypeConstant:
openXmlPart = new ChartPart();
return;
case ChartDrawingPart.RelationshipTypeConstant:
openXmlPart = new ChartDrawingPart();
return;
case EmbeddedPackagePart.RelationshipTypeConstant:
openXmlPart = new EmbeddedPackagePart();
return;
case ThemeOverridePart.RelationshipTypeConstant:
openXmlPart = new ThemeOverridePart();
return;
case ChartStylePart.RelationshipTypeConstant:
openXmlPart = new ChartStylePart();
return;
case ChartColorStylePart.RelationshipTypeConstant:
openXmlPart = new ChartColorStylePart();
return;
case DiagramColorsPart.RelationshipTypeConstant:
openXmlPart = new DiagramColorsPart();
return;
case DiagramDataPart.RelationshipTypeConstant:
openXmlPart = new DiagramDataPart();
return;
case WorksheetPart.RelationshipTypeConstant:
openXmlPart = new WorksheetPart();
return;
case DrawingsPart.RelationshipTypeConstant:
openXmlPart = new DrawingsPart();
return;
case DiagramPersistLayoutPart.RelationshipTypeConstant:
openXmlPart = new DiagramPersistLayoutPart();
return;
case DiagramLayoutDefinitionPart.RelationshipTypeConstant:
openXmlPart = new DiagramLayoutDefinitionPart();
return;
case DiagramStylePart.RelationshipTypeConstant:
openXmlPart = new DiagramStylePart();
return;
case WebExtensionPart.RelationshipTypeConstant:
openXmlPart = new WebExtensionPart();
return;
case VmlDrawingPart.RelationshipTypeConstant:
openXmlPart = new VmlDrawingPart();
return;
case LegacyDiagramTextPart.RelationshipTypeConstant:
openXmlPart = new LegacyDiagramTextPart();
return;
case PivotTablePart.RelationshipTypeConstant:
openXmlPart = new PivotTablePart();
return;
case PivotTableCacheDefinitionPart.RelationshipTypeConstant:
openXmlPart = new PivotTableCacheDefinitionPart();
return;
case PivotTableCacheRecordsPart.RelationshipTypeConstant:
openXmlPart = new PivotTableCacheRecordsPart();
return;
case SingleCellTablePart.RelationshipTypeConstant:
openXmlPart = new SingleCellTablePart();
return;
case TableDefinitionPart.RelationshipTypeConstant:
openXmlPart = new TableDefinitionPart();
return;
case QueryTablePart.RelationshipTypeConstant:
openXmlPart = new QueryTablePart();
return;
case EmbeddedControlPersistencePart.RelationshipTypeConstant:
openXmlPart = new EmbeddedControlPersistencePart();
return;
case EmbeddedControlPersistenceBinaryDataPart.RelationshipTypeConstant:
openXmlPart = new EmbeddedControlPersistenceBinaryDataPart();
return;
case ControlPropertiesPart.RelationshipTypeConstant:
openXmlPart = new ControlPropertiesPart();
return;
case EmbeddedObjectPart.RelationshipTypeConstant:
openXmlPart = new EmbeddedObjectPart();
return;
case CustomPropertyPart.RelationshipTypeConstant:
openXmlPart = new CustomPropertyPart();
return;
case WorksheetSortMapPart.RelationshipTypeConstant:
openXmlPart = new WorksheetSortMapPart();
return;
case SlicersPart.RelationshipTypeConstant:
openXmlPart = new SlicersPart();
return;
case TimeLinePart.RelationshipTypeConstant:
openXmlPart = new TimeLinePart();
return;
case SlideCommentsPart.RelationshipTypeConstant:
openXmlPart = new SlideCommentsPart();
return;
case NotesSlidePart.RelationshipTypeConstant:
openXmlPart = new NotesSlidePart();
return;
case NotesMasterPart.RelationshipTypeConstant:
openXmlPart = new NotesMasterPart();
return;
case UserDefinedTagsPart.RelationshipTypeConstant:
openXmlPart = new UserDefinedTagsPart();
return;
case SlideLayoutPart.RelationshipTypeConstant:
openXmlPart = new SlideLayoutPart();
return;
case SlideMasterPart.RelationshipTypeConstant:
openXmlPart = new SlideMasterPart();
return;
case SlideSyncDataPart.RelationshipTypeConstant:
openXmlPart = new SlideSyncDataPart();
return;
case CommentAuthorsPart.RelationshipTypeConstant:
openXmlPart = new CommentAuthorsPart();
return;
case HandoutMasterPart.RelationshipTypeConstant:
openXmlPart = new HandoutMasterPart();
return;
case LegacyDiagramTextInfoPart.RelationshipTypeConstant:
openXmlPart = new LegacyDiagramTextInfoPart();
return;
case VbaProjectPart.RelationshipTypeConstant:
openXmlPart = new VbaProjectPart();
return;
case VbaDataPart.RelationshipTypeConstant:
openXmlPart = new VbaDataPart();
return;
case CoreFilePropertiesPart.RelationshipTypeConstant:
openXmlPart = new CoreFilePropertiesPart();
return;
case ExtendedFilePropertiesPart.RelationshipTypeConstant:
openXmlPart = new ExtendedFilePropertiesPart();
return;
case CustomFilePropertiesPart.RelationshipTypeConstant:
openXmlPart = new CustomFilePropertiesPart();
return;
case ThumbnailPart.RelationshipTypeConstant:
openXmlPart = new ThumbnailPart();
return;
case DigitalSignatureOriginPart.RelationshipTypeConstant:
openXmlPart = new DigitalSignatureOriginPart();
return;
case XmlSignaturePart.RelationshipTypeConstant:
openXmlPart = new XmlSignaturePart();
return;
case QuickAccessToolbarCustomizationsPart.RelationshipTypeConstant:
openXmlPart = new QuickAccessToolbarCustomizationsPart();
return;
case RibbonExtensibilityPart.RelationshipTypeConstant:
openXmlPart = new RibbonExtensibilityPart();
return;
case RibbonAndBackstageCustomizationsPart.RelationshipTypeConstant:
openXmlPart = new RibbonAndBackstageCustomizationsPart();
return;
case WebExTaskpanesPart.RelationshipTypeConstant:
openXmlPart = new WebExTaskpanesPart();
return;
}
}
else
{
System.Diagnostics.Debug.Assert(false);
}
return;
}
// Generates content of tableDefinitionPart2.
private void GenerateTableDefinitionPart2Content(TableDefinitionPart tableDefinitionPart2)
{
Table table2 = new Table(){ Id = (UInt32Value)1U, Name = "Table1", DisplayName = "Table1", Reference = "A1:C4", TotalsRowShown = false };
AutoFilter autoFilter2 = new AutoFilter(){ Reference = "A1:C4" };
TableColumns tableColumns2 = new TableColumns(){ Count = (UInt32Value)3U };
TableColumn tableColumn4 = new TableColumn(){ Id = (UInt32Value)1U, Name = "Column1" };
TableColumn tableColumn5 = new TableColumn(){ Id = (UInt32Value)2U, Name = "Column2" };
TableColumn tableColumn6 = new TableColumn(){ Id = (UInt32Value)3U, Name = "Column3" };
tableColumns2.Append(tableColumn4);
tableColumns2.Append(tableColumn5);
tableColumns2.Append(tableColumn6);
TableStyleInfo tableStyleInfo2 = new TableStyleInfo(){ Name = "TableStyleMedium2", ShowFirstColumn = false, ShowLastColumn = false, ShowRowStripes = true, ShowColumnStripes = false };
table2.Append(autoFilter2);
table2.Append(tableColumns2);
table2.Append(tableStyleInfo2);
tableDefinitionPart2.Table = table2;
}
/// <summary>
/// Method for adding a new table definition part
/// </summary>
/// <param name="worksheet">Worksheet to add the table to</param>
/// <param name="tableStyle">Style to be assigned to the table</param>
/// <param name="useHeaders">Set a header row</param>
/// <param name="fromColumn">Initial column for table</param>
/// <param name="toColumn">Final column for table</param>
/// <param name="fromRow">Intial row for table</param>
/// <param name="toRow">Final row for table</param>
public void Add(OpenXmlSDK.WorksheetPart worksheet, string tableStyle, bool useHeaders, short fromColumn, short toColumn, int fromRow, int toRow)
{
//Getting the id for this table
int tableId = GetNextTableId();
//Set the table cell range
string tableRange = string.Format("{0}{1}:{2}{3}", WorksheetAccessor.GetColumnId(fromColumn),
fromRow,
WorksheetAccessor.GetColumnId(toColumn),
toRow);
//Creating a new id for the relationship between the table definition part and the worksheet
string tableRelationShipId = "rId" + Guid.NewGuid();
//Create a new table definition part
OpenXmlSDK.TableDefinitionPart table = worksheet.AddNewPart <OpenXmlSDK.TableDefinitionPart>(tableRelationShipId);
//string tableColumns = string.Empty;
XElement tableColumnsXElement = new XElement(ns + "tableColumns", new XAttribute("count", (toColumn - fromColumn) + 1));
//Get the name for table column elements from the first table row
string[] tableHeaders = GetTableHeaders(worksheet, fromRow, fromColumn, toColumn);
for (int i = 0; i <= (toColumn - fromColumn); i++)
{
//Create the markup for the SpreadsheetML table column elements
tableColumnsXElement.Add(
new XElement(ns + "tableColumn", new XAttribute("id", i + 1), new XAttribute("name", tableHeaders[i])));
}
XElement tableXElement =
new XElement(ns + "table",
new XAttribute("xmlns", ns), //default namespace
new XAttribute("id", tableId),
new XAttribute("name", "Table" + tableId.ToString()),
new XAttribute("displayName", "Table" + tableId.ToString()),
new XAttribute("ref", tableRange),
new XAttribute("totalsRowShown", "0"));
if (useHeaders)
{
tableXElement.Add(
new XElement(ns + "autoFilter", new XAttribute("ref", tableRange)));
}
tableXElement.Add(tableColumnsXElement);
tableXElement.Add(
new XElement(ns + "tableStyleInfo",
new XAttribute("name", tableStyle),
new XAttribute("showFirstColumn", "0"),
new XAttribute("showLastColumn", "0"),
new XAttribute("showRowStripes", "0"),
new XAttribute("showColumnStripes", "0")));
//Write the markup to the Table Definition Part Stream
XmlWriter tablePartStreamWriter = XmlWriter.Create(table.GetStream());
tableXElement.WriteTo(tablePartStreamWriter);
tablePartStreamWriter.Flush();
tablePartStreamWriter.Close();
//Create or modify the table parts definition at worksheet (for setting the relationship id with the new table)
XDocument worksheetMarkup = parentDocument.GetXDocument(worksheet);
//Look for the tableParts element at worksheet markup
XElement tablePartsElement = worksheetMarkup.Root.Element(ns + "tableParts");
if (tablePartsElement != null)
{
//tableParts elements does exist at worksheet markup
//increment the tableParts count attribute value
short tableCount = System.Convert.ToInt16(tablePartsElement.Attribute("count").Value);
tablePartsElement.SetAttributeValue("count", tableCount++.ToString());
}
else
{
//tableParts does not exist at worksheet markup
//create a new tableParts element
tablePartsElement = new XElement(ns + "tableParts",
new XAttribute(ns + "count", "1"));
worksheetMarkup.Root.Add(tablePartsElement);
}
//create the tablePart element
XElement tablePartEntryElement = new XElement(ns + "tablePart",
new XAttribute(relationshipns + "id", tableRelationShipId));
//add the new tablePart element to the worksheet tableParts element
tablePartsElement.Add(tablePartEntryElement);
}
// Generates content of tableDefinitionPart6.
private void GenerateTableDefinitionPart6Content(TableDefinitionPart tableDefinitionPart6)
{
Table table6 = new Table(){ Id = (UInt32Value)1U, Name = "DataTable1", DisplayName = "DataTable1", Reference = "A1:F5", TotalsRowShown = false };
AutoFilter autoFilter6 = new AutoFilter(){ Reference = "A1:F5" };
SortState sortState2 = new SortState(){ Reference = "A2:F2001" };
SortCondition sortCondition2 = new SortCondition(){ Reference = "A2:A2001" };
sortState2.Append(sortCondition2);
TableColumns tableColumns6 = new TableColumns(){ Count = (UInt32Value)6U };
TableColumn tableColumn13 = new TableColumn(){ Id = (UInt32Value)1U, Name = "Date", DataFormatId = (UInt32Value)13U };
TableColumn tableColumn14 = new TableColumn(){ Id = (UInt32Value)2U, Name = "Product" };
TableColumn tableColumn15 = new TableColumn(){ Id = (UInt32Value)3U, Name = "Quantity" };
TableColumn tableColumn16 = new TableColumn(){ Id = (UInt32Value)4U, Name = "Price" };
TableColumn tableColumn17 = new TableColumn(){ Id = (UInt32Value)5U, Name = "DeliveryDate", DataFormatId = (UInt32Value)12U };
TableColumn tableColumn18 = new TableColumn(){ Id = (UInt32Value)6U, Name = "Employee" };
tableColumns6.Append(tableColumn13);
tableColumns6.Append(tableColumn14);
tableColumns6.Append(tableColumn15);
tableColumns6.Append(tableColumn16);
tableColumns6.Append(tableColumn17);
tableColumns6.Append(tableColumn18);
TableStyleInfo tableStyleInfo6 = new TableStyleInfo(){ Name = "TableStyleMedium2", ShowFirstColumn = false, ShowLastColumn = false, ShowRowStripes = true, ShowColumnStripes = false };
table6.Append(autoFilter6);
table6.Append(sortState2);
table6.Append(tableColumns6);
table6.Append(tableStyleInfo6);
tableDefinitionPart6.Table = table6;
}
// Generates content of tableDefinitionPart1.
private void GenerateTableDefinitionPart1Content(TableDefinitionPart tableDefinitionPart1)
{
Table table1 = new Table(){ Id = (UInt32Value)2U, Name = "Table2", DisplayName = "Table2", Reference = "E1:G4", TotalsRowShown = false };
AutoFilter autoFilter1 = new AutoFilter(){ Reference = "E1:G4" };
TableColumns tableColumns1 = new TableColumns(){ Count = (UInt32Value)3U };
TableColumn tableColumn1 = new TableColumn(){ Id = (UInt32Value)1U, Name = "Column1" };
TableColumn tableColumn2 = new TableColumn(){ Id = (UInt32Value)2U, Name = "Column2" };
TableColumn tableColumn3 = new TableColumn(){ Id = (UInt32Value)3U, Name = "Column3" };
tableColumns1.Append(tableColumn1);
tableColumns1.Append(tableColumn2);
tableColumns1.Append(tableColumn3);
TableStyleInfo tableStyleInfo1 = new TableStyleInfo(){ Name = "TableStyleMedium2", ShowFirstColumn = false, ShowLastColumn = false, ShowRowStripes = true, ShowColumnStripes = false };
table1.Append(autoFilter1);
table1.Append(tableColumns1);
table1.Append(tableStyleInfo1);
tableDefinitionPart1.Table = table1;
}
// Generates content of tableDefinitionPart4.
private void GenerateTableDefinitionPart4Content(TableDefinitionPart tableDefinitionPart4)
{
Table table4 = new Table(){ Id = (UInt32Value)3U, Name = "SalesTable1", DisplayName = "SalesTable1", Reference = "K1:K11", TotalsRowShown = false, HeaderRowFormatId = (UInt32Value)9U };
AutoFilter autoFilter4 = new AutoFilter(){ Reference = "K1:K11" };
TableColumns tableColumns4 = new TableColumns(){ Count = (UInt32Value)1U };
TableColumn tableColumn10 = new TableColumn(){ Id = (UInt32Value)1U, Name = "Employee" };
tableColumns4.Append(tableColumn10);
TableStyleInfo tableStyleInfo4 = new TableStyleInfo(){ Name = "TableStyleMedium2", ShowFirstColumn = false, ShowLastColumn = false, ShowRowStripes = true, ShowColumnStripes = false };
table4.Append(autoFilter4);
table4.Append(tableColumns4);
table4.Append(tableStyleInfo4);
tableDefinitionPart4.Table = table4;
}
// Generates content of tableDefinitionPart5.
private void GenerateTableDefinitionPart5Content(TableDefinitionPart tableDefinitionPart5)
{
Table table5 = new Table(){ Id = (UInt32Value)2U, Name = "ProductTable1", DisplayName = "ProductTable1", Reference = "H1:I11", TotalsRowShown = false, HeaderRowFormatId = (UInt32Value)11U };
AutoFilter autoFilter5 = new AutoFilter(){ Reference = "H1:I11" };
TableColumns tableColumns5 = new TableColumns(){ Count = (UInt32Value)2U };
TableColumn tableColumn11 = new TableColumn(){ Id = (UInt32Value)1U, Name = "ProductName" };
TableColumn tableColumn12 = new TableColumn(){ Id = (UInt32Value)2U, Name = "Price", DataFormatId = (UInt32Value)10U };
tableColumns5.Append(tableColumn11);
tableColumns5.Append(tableColumn12);
TableStyleInfo tableStyleInfo5 = new TableStyleInfo(){ Name = "TableStyleMedium2", ShowFirstColumn = false, ShowLastColumn = false, ShowRowStripes = true, ShowColumnStripes = false };
table5.Append(autoFilter5);
table5.Append(tableColumns5);
table5.Append(tableStyleInfo5);
tableDefinitionPart5.Table = table5;
}
// Generates content of tableDefinitionPart3.
private void GenerateTableDefinitionPart3Content(TableDefinitionPart tableDefinitionPart3)
{
Table table3 = new Table(){ Id = (UInt32Value)4U, Name = "DataTable2", DisplayName = "DataTable2", Reference = "A1:F6", TotalsRowShown = false };
AutoFilter autoFilter3 = new AutoFilter(){ Reference = "A1:F6" };
SortState sortState1 = new SortState(){ Reference = "A2:F2001" };
SortCondition sortCondition1 = new SortCondition(){ Reference = "A2" };
sortState1.Append(sortCondition1);
TableColumns tableColumns3 = new TableColumns(){ Count = (UInt32Value)6U };
TableColumn tableColumn4 = new TableColumn(){ Id = (UInt32Value)1U, Name = "Date", DataFormatId = (UInt32Value)8U };
TableColumn tableColumn5 = new TableColumn(){ Id = (UInt32Value)2U, Name = "Product", DataFormatId = (UInt32Value)7U };
TableColumn tableColumn6 = new TableColumn(){ Id = (UInt32Value)3U, Name = "Quantity", DataFormatId = (UInt32Value)6U };
TableColumn tableColumn7 = new TableColumn(){ Id = (UInt32Value)4U, Name = "Price", DataFormatId = (UInt32Value)5U };
TableColumn tableColumn8 = new TableColumn(){ Id = (UInt32Value)5U, Name = "DeliveryDate", DataFormatId = (UInt32Value)4U };
TableColumn tableColumn9 = new TableColumn(){ Id = (UInt32Value)6U, Name = "Employee", DataFormatId = (UInt32Value)3U };
tableColumns3.Append(tableColumn4);
tableColumns3.Append(tableColumn5);
tableColumns3.Append(tableColumn6);
tableColumns3.Append(tableColumn7);
tableColumns3.Append(tableColumn8);
tableColumns3.Append(tableColumn9);
TableStyleInfo tableStyleInfo3 = new TableStyleInfo(){ Name = "TableStyleMedium2", ShowFirstColumn = false, ShowLastColumn = false, ShowRowStripes = true, ShowColumnStripes = false };
table3.Append(autoFilter3);
table3.Append(sortState1);
table3.Append(tableColumns3);
table3.Append(tableStyleInfo3);
tableDefinitionPart3.Table = table3;
}
// Generates content of tableDefinitionPart2.
private void GenerateTableDefinitionPart2Content(TableDefinitionPart tableDefinitionPart2)
{
Table table2 = new Table(){ Id = (UInt32Value)5U, Name = "ProductTable2", DisplayName = "ProductTable2", Reference = "H1:I11", TotalsRowShown = false, HeaderRowFormatId = (UInt32Value)2U };
AutoFilter autoFilter2 = new AutoFilter(){ Reference = "H1:I11" };
TableColumns tableColumns2 = new TableColumns(){ Count = (UInt32Value)2U };
TableColumn tableColumn2 = new TableColumn(){ Id = (UInt32Value)1U, Name = "ProductName" };
TableColumn tableColumn3 = new TableColumn(){ Id = (UInt32Value)2U, Name = "Price", DataFormatId = (UInt32Value)1U };
tableColumns2.Append(tableColumn2);
tableColumns2.Append(tableColumn3);
TableStyleInfo tableStyleInfo2 = new TableStyleInfo(){ Name = "TableStyleMedium2", ShowFirstColumn = false, ShowLastColumn = false, ShowRowStripes = true, ShowColumnStripes = false };
table2.Append(autoFilter2);
table2.Append(tableColumns2);
table2.Append(tableStyleInfo2);
tableDefinitionPart2.Table = table2;
}
// Generates content of tableDefinitionPart1.
private void GenerateTableDefinitionPart1Content(TableDefinitionPart tableDefinitionPart1)
{
Table table1 = new Table(){ Id = (UInt32Value)1U, Name = "Table_Query", DisplayName = "Table_Query", Reference = "B2:I13", TableType = TableValues.QueryTable, TotalsRowShown = false };
AutoFilter autoFilter1 = new AutoFilter(){ Reference = "B2:I13" };
TableColumns tableColumns1 = new TableColumns(){ Count = (UInt32Value)8U };
TableColumn tableColumn1 = new TableColumn(){ Id = (UInt32Value)1U, UniqueName = "1", Name = "account_id", QueryTableFieldId = (UInt32Value)1U };
TableColumn tableColumn2 = new TableColumn(){ Id = (UInt32Value)2U, UniqueName = "2", Name = "account_parent", QueryTableFieldId = (UInt32Value)2U };
TableColumn tableColumn3 = new TableColumn(){ Id = (UInt32Value)3U, UniqueName = "3", Name = "account_description", QueryTableFieldId = (UInt32Value)3U };
TableColumn tableColumn4 = new TableColumn(){ Id = (UInt32Value)4U, UniqueName = "4", Name = "account_type", QueryTableFieldId = (UInt32Value)4U };
TableColumn tableColumn5 = new TableColumn(){ Id = (UInt32Value)5U, UniqueName = "5", Name = "account_rollup", QueryTableFieldId = (UInt32Value)5U };
TableColumn tableColumn6 = new TableColumn(){ Id = (UInt32Value)6U, UniqueName = "6", Name = "Custom Members", QueryTableFieldId = (UInt32Value)6U };
TableColumn tableColumn7 = new TableColumn(){ Id = (UInt32Value)7U, UniqueName = "7", Name = "CurrentUser", QueryTableFieldId = (UInt32Value)7U };
TableColumn tableColumn8 = new TableColumn(){ Id = (UInt32Value)8U, UniqueName = "8", Name = "RefreshTime", QueryTableFieldId = (UInt32Value)8U, DataFormatId = (UInt32Value)0U };
tableColumns1.Append(tableColumn1);
tableColumns1.Append(tableColumn2);
tableColumns1.Append(tableColumn3);
tableColumns1.Append(tableColumn4);
tableColumns1.Append(tableColumn5);
tableColumns1.Append(tableColumn6);
tableColumns1.Append(tableColumn7);
tableColumns1.Append(tableColumn8);
TableStyleInfo tableStyleInfo1 = new TableStyleInfo(){ Name = "TableStyleMedium2", ShowFirstColumn = false, ShowLastColumn = false, ShowRowStripes = true, ShowColumnStripes = false };
table1.Append(autoFilter1);
table1.Append(tableColumns1);
table1.Append(tableStyleInfo1);
tableDefinitionPart1.Table = table1;
}
/// <summary>
/// Generates content of tableDefinitionPart1.
/// </summary>
/// <param name="tableDefinitionPart">Table definition part.</param>
/// <param name="hasFileLevelMetadata">Has file level metadata.</param>
private static void GenerateParameterTablePartContent(TableDefinitionPart tableDefinitionPart, bool hasFileLevelMetadata)
{
string reference = hasFileLevelMetadata ? "D1:I44" : "A1:F44";
Table table1 = new Table() { Id = (UInt32Value)6U, Name = Constants.ParaMetadataRangeName, DisplayName = Constants.ParaMetadataRangeName, Reference = reference, TotalsRowShown = false };
AutoFilter autoFilter1 = new AutoFilter() { Reference = reference };
TableColumns tableColumns1 = new TableColumns() { Count = (UInt32Value)6U };
tableColumns1.Append(new TableColumn() { Id = (UInt32Value)1U, Name = Statics.TableName });
tableColumns1.Append(new TableColumn() { Id = (UInt32Value)2U, Name = Statics.TableDescription });
tableColumns1.Append(new TableColumn() { Id = (UInt32Value)3U, Name = Statics.FieldName });
tableColumns1.Append(new TableColumn() { Id = (UInt32Value)4U, Name = Statics.FieldDescription });
tableColumns1.Append(new TableColumn() { Id = (UInt32Value)5U, Name = Statics.DataType });
tableColumns1.Append(new TableColumn() { Id = (UInt32Value)6U, Name = Statics.Units });
TableStyleInfo tableStyleInfo1 = new TableStyleInfo() { Name = Constants.MetadataTableStyleName, ShowFirstColumn = false, ShowLastColumn = false, ShowRowStripes = true, ShowColumnStripes = false };
table1.Append(autoFilter1);
table1.Append(tableColumns1);
table1.Append(tableStyleInfo1);
tableDefinitionPart.Table = table1;
}
/// <summary>
/// Generates content of tableDefinitionPart1.
/// </summary>
/// <param name="tableDefinitionPart">Table definition.</param>
private static void GenerateTableDefinitionPartContent(TableDefinitionPart tableDefinitionPart)
{
Table table1 = new Table() { Id = (UInt32Value)5U, Name = Constants.MetadataRangeName, DisplayName = Constants.MetadataRangeName, Reference = "A1:B44", TotalsRowShown = false };
AutoFilter autoFilter1 = new AutoFilter() { Reference = "A1:B44" };
TableColumns tableColumns1 = new TableColumns() { Count = (UInt32Value)2U };
TableColumn tableColumn1 = new TableColumn() { Id = (UInt32Value)1U, Name = "Name" };
TableColumn tableColumn2 = new TableColumn() { Id = (UInt32Value)2U, Name = "Value" };
tableColumns1.Append(tableColumn1);
tableColumns1.Append(tableColumn2);
TableStyleInfo tableStyleInfo1 = new TableStyleInfo() { Name = Constants.MetadataTableStyleName, ShowFirstColumn = false, ShowLastColumn = false, ShowRowStripes = true, ShowColumnStripes = false };
table1.Append(autoFilter1);
table1.Append(tableColumns1);
table1.Append(tableStyleInfo1);
tableDefinitionPart.Table = table1;
}
