Namespace: Consultingwerk.Utilities.Excel
Class 
ExcelStyleSheetUtility Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.Utilities.Excel.ExcelStyleSheetUtility

Inherits: Progress.Lang.Object
Inherited by: Consultingwerk.Utilities.Excel.ExcelUtility Consultingwerk.Utilities.Excel.ExcelWorksheetExporter Consultingwerk.Utilities.Excel.ExcelWorksheetImporter


Navigate to: Methods | Constructors | Events | Properties | ProDatasets | Temp-Tables



Top Method Summary
Options Name Purpose
AddStyleSheetElements (Stylesheet) Adds Stylesheet Elements into the Stylesheet
CloneCellFormats (Stylesheet) Clones the current Stylesheet Cell Formats and adds Date/DateTime formats for the Excel Stylesheet
DocumentFormat.OpenXml.Spreadsheet.BackgroundColor CreateBackgroundColor (character) Creates a BackgroundColor using RGB Hex Values
CreateDefaultCellFormats (Stylesheet) Creates the default Stylesheet Cell Formats for the Excel Stylesheet
DocumentFormat.OpenXml.Spreadsheet.ForegroundColor CreateForegroundColor (character) Creates a ForegroundColor using RGB Hex Values
DocumentFormat.OpenXml.Spreadsheet.Stylesheet CreateStyleSheet () Creates the Stylesheet for the Excel Worksheet
DocumentFormat.OpenXml.Spreadsheet.Borders CreateStyleSheetBorders () Creates the Stylesheet Borders for the Excel Stylesheet
DocumentFormat.OpenXml.Spreadsheet.CellFormats CreateStyleSheetCellFormatIndexing () Creates the Stylesheet Cell Formats for the Excel Stylesheet
DocumentFormat.OpenXml.Spreadsheet.Fills CreateStyleSheetFills (character) Creates the Stylesheet Fills for the Excel Stylesheet
DocumentFormat.OpenXml.Spreadsheet.Fonts CreateStyleSheetFonts () Creates the Stylesheet Fonts for the Excel Stylesheet
DocumentFormat.OpenXml.Spreadsheet.Stylesheet GetStyleSheet (WorkbookPart) Gets the existing Excel Worksheet Stylesheet
LOGICAL HasDateFormat (Stylesheet, integer) Checks if the Stylesheet has a Date Format
RemoveStyleSheetElements (Stylesheet) Removes all the existing Stylesheet Elements from the Stylesheet
DocumentFormat.OpenXml.Spreadsheet.Border SetBorderStyle (character) Sets the Border Style for the Excel Stylesheet
DocumentFormat.OpenXml.Spreadsheet.CellFormat SetCellFormatStyle (integer, integer, integer, integer, integer, logical) Sets the CellFormat Style for the Excel Stylesheet
DocumentFormat.OpenXml.Spreadsheet.Fill SetFillStyle (character) Sets the Fill Style for the Excel Stylesheet
DocumentFormat.OpenXml.Spreadsheet.Fill SetFillStyleWithColor (character, character, character) Sets the Fill Style with Color for the Excel Stylesheet
DocumentFormat.OpenXml.Spreadsheet.Font SetFontStyle (character, integer, logical) Sets the Font Style for the Excel Stylesheet
UpdateStyleSheet (Stylesheet) Updates the existing Excel Worksheet Stylesheet

Top Property Summary
Options Name Purpose
INTEGER DateStyleIndex
INTEGER DateTimeStyleIndex
CHARACTER DefaultBackColor
CHARACTER DefaultFont
INTEGER DefaultFontSize
CHARACTER DefaultForeColor
CHARACTER HeaderFont
LOGICAL HeaderFontBold
INTEGER HeaderFontSize
CHARACTER HeaderRowColor


Method Detail
Top

AddStyleSheetElements (Stylesheet)
Purpose: Adds Stylesheet Elements into the Stylesheet
Notes:

Parameters:
poStylesheet DocumentFormat.OpenXml.Spreadsheet.Stylesheet
Top

CloneCellFormats (Stylesheet)
Purpose: Clones the current Stylesheet Cell Formats and adds Date/DateTime formats for the Excel Stylesheet
Notes:

Parameters:
poStylesheet DocumentFormat.OpenXml.Spreadsheet.Stylesheet
Top

DocumentFormat.OpenXml.Spreadsheet.BackgroundColor CreateBackgroundColor (character)
Purpose: Creates a BackgroundColor using RGB Hex Values
Notes:

Parameters:
pcColor CHARACTER
Returns DocumentFormat.OpenXml.Spreadsheet.BackgroundColor
BackgroundColor Object
Top

CreateDefaultCellFormats (Stylesheet)
Purpose: Creates the default Stylesheet Cell Formats for the Excel Stylesheet
Notes:

Parameters:
poStylesheet DocumentFormat.OpenXml.Spreadsheet.Stylesheet
Top

DocumentFormat.OpenXml.Spreadsheet.ForegroundColor CreateForegroundColor (character)
Purpose: Creates a ForegroundColor using RGB Hex Values
Notes:

Parameters:
pcColor CHARACTER
Returns DocumentFormat.OpenXml.Spreadsheet.ForegroundColor
ForegroundColor Object
Top

DocumentFormat.OpenXml.Spreadsheet.Stylesheet CreateStyleSheet ()
Purpose: Creates the Stylesheet for the Excel Worksheet
Notes:

Returns DocumentFormat.OpenXml.Spreadsheet.Stylesheet
Stylesheet Object
Top

DocumentFormat.OpenXml.Spreadsheet.Borders CreateStyleSheetBorders ()
Purpose: Creates the Stylesheet Borders for the Excel Stylesheet
Notes:

Returns DocumentFormat.OpenXml.Spreadsheet.Borders
Borders Object
Top

DocumentFormat.OpenXml.Spreadsheet.CellFormats CreateStyleSheetCellFormatIndexing ()
Purpose: Creates the Stylesheet Cell Formats for the Excel Stylesheet
Notes:

Returns DocumentFormat.OpenXml.Spreadsheet.CellFormats
CellFormats Object
Top

DocumentFormat.OpenXml.Spreadsheet.Fills CreateStyleSheetFills (character)
Purpose: Creates the Stylesheet Fills for the Excel Stylesheet
Notes:

Parameters:
pcColor CHARACTER
Returns DocumentFormat.OpenXml.Spreadsheet.Fills
Fills Object
Top

DocumentFormat.OpenXml.Spreadsheet.Fonts CreateStyleSheetFonts ()
Purpose: Creates the Stylesheet Fonts for the Excel Stylesheet
Notes:

Returns DocumentFormat.OpenXml.Spreadsheet.Fonts
Fonts Object
Top

DocumentFormat.OpenXml.Spreadsheet.Stylesheet GetStyleSheet (WorkbookPart)
Purpose: Gets the existing Excel Worksheet Stylesheet
Notes:

Parameters:
poWorkbookPart DocumentFormat.OpenXml.Packaging.WorkbookPart
Returns DocumentFormat.OpenXml.Spreadsheet.Stylesheet
Stylesheet Object
Top

LOGICAL HasDateFormat (Stylesheet, integer)
Purpose: Checks if the Stylesheet has a Date Format
Notes:

Parameters:
poStylesSheet DocumentFormat.OpenXml.Spreadsheet.Stylesheet
piNumberFormatID INTEGER
Returns LOGICAL
logical
Top

RemoveStyleSheetElements (Stylesheet)
Purpose: Removes all the existing Stylesheet Elements from the Stylesheet
Notes:

Parameters:
poStylesheet DocumentFormat.OpenXml.Spreadsheet.Stylesheet
Top

DocumentFormat.OpenXml.Spreadsheet.Border SetBorderStyle (character)
/*
Purpose: Sets the Border Style for the Excel Stylesheet
Notes:

Parameters:
pcBorderStyles CHARACTER
Returns DocumentFormat.OpenXml.Spreadsheet.Border
: Border
Top

DocumentFormat.OpenXml.Spreadsheet.CellFormat SetCellFormatStyle (integer, integer, integer, integer, integer, logical)
Purpose: Sets the CellFormat Style for the Excel Stylesheet
Notes:

Parameters:
piFontID INTEGER
piFillID INTEGER
piBorderID INTEGER
piFormatID INTEGER
piNumberFormatID INTEGER
plApplyNumberFormat LOGICAL
Returns DocumentFormat.OpenXml.Spreadsheet.CellFormat
CellFormat Object
Top

DocumentFormat.OpenXml.Spreadsheet.Fill SetFillStyle (character)
/*
Purpose: Sets the Fill Style for the Excel Stylesheet
Notes:

Parameters:
pcPatternType CHARACTER
Returns DocumentFormat.OpenXml.Spreadsheet.Fill
: Fill
Top

DocumentFormat.OpenXml.Spreadsheet.Fill SetFillStyleWithColor (character, character, character)
Purpose: Sets the Fill Style with Color for the Excel Stylesheet
Notes:

Parameters:
pcPatternType CHARACTER
pcForeColor CHARACTER
pcBackColor CHARACTER
Returns DocumentFormat.OpenXml.Spreadsheet.Fill
Fill Object
Top

DocumentFormat.OpenXml.Spreadsheet.Font SetFontStyle (character, integer, logical)
/*
Purpose: Sets the Font Style for the Excel Stylesheet
Notes:

Parameters:
pcFontName CHARACTER
piFontSize INTEGER
plBold LOGICAL
Returns DocumentFormat.OpenXml.Spreadsheet.Font
: Font
Top

UpdateStyleSheet (Stylesheet)
Purpose: Updates the existing Excel Worksheet Stylesheet
Notes:

Parameters:
poStylesheet DocumentFormat.OpenXml.Spreadsheet.Stylesheet


Property Detail
Top

INTEGER DateStyleIndex

Returns INTEGER
Top

INTEGER DateTimeStyleIndex

Returns INTEGER
Top

CHARACTER DefaultBackColor

Returns CHARACTER
Top

CHARACTER DefaultFont

Returns CHARACTER
Top

INTEGER DefaultFontSize

Returns INTEGER
Top

CHARACTER DefaultForeColor

Returns CHARACTER
Top

CHARACTER HeaderFont

Returns CHARACTER
Top

LOGICAL HeaderFontBold

Returns LOGICAL
Top

INTEGER HeaderFontSize

Returns INTEGER
Top

CHARACTER HeaderRowColor

Returns CHARACTER


©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       03.05.2026 21:46:56