data-colon-ENUM: Dataset: ENUM

In madlogos/asesmso: ASES Analytic Toolkit on MS Office

Description

Some of the common enumerations, majorly Micorsoft VBA Enums (for Word, Excel and PPT, etc) when applying mso-family functions in this package.

Details

It contains a named list nested with named lists.

• Office core (23): MsoAutoShape, MsoBackgroundStyleIndex, MsoBarPosition, MsoBaselineAlignment, MsoBulletType, MsoCharacterSet, MsoChartElementType, MsoDateTimeFormat, MsoFileType, MsoGradientStyle, MsoLineCapStyle, MsoLineStyle, MsoLineDashStyle, MsoOrientation, MsoParagraphAlignment, MsoPatternType, MsoSegmentType, MsoShapeType, MsoShapeStyleIndex, MsoTextDirection, MsoTextOrientation, MsoThemeColorIndex, MsoThemeColorSchemeInde

• Word (11): WdConstants, WdSaveFormat, WdApplyQuickStyleSets, WdBuiltInProperty, WdColor, WdColorIndex, WdCellColor, WdBuiltinStyle, WdCaptionNumberStyle, WdCharacterCase, WdCountry

• Excel (59): XlApplicationInternational, XlAxisCrosses, XlAxisGroup, XlAxisType, XlBackground, XlBarShape, XlBinsType, XlBorderWeight, XlCategoryLabelLevel, XlCategoryType, XlChartElementPosition, XlChartGallery, XlChartItem, XlChartPicturePlacement, XlChartPictureType, XlChartSplitType, XlChartType, XlColorIndex, XlConstants, XlDataBarAxisPosition, XlDataBarBorderType, XlDataBarFillType, XlDataBarNegativeColorType, XlDataLabelPosition, XlDataLabelsType, XlDataSeriesDate, XlDataSeriesType, XlDeleteShiftDirection, XlDisplayBlanksAs, XlDisplayUnit, XlEndStyleCap, XlErrorBarDirection, XlErrorBarInclude, XlErrorBarType, XlFileAccess, XlFileFormat, XlHAlign, XlIcon, XlLegendPosition, XlLineStyle, XlMarkerStyle, XlOLEType, XlOrientation, XlPattern, XlPieSliceLocation, XlRgbColor, XlRowCol, XlScaleType, XlSeriesNameLevel, XlSheetType, XlTableStyleElementType, XlThemeColor, XlTickLabelOrientation, XlTickLabelPosition, XlTickMark, XlTimeUnit, XlTrendlineType, XlUnderlineStyle, XlVAlign

• PowerPoint (18): PpBaselineAlignment, PpBorderType, PpBulletType, PpChangeCase, PpColorSchemeIndex, PpDateTimeFormat, PpEntryEffect, PpFollowColors, PpFrameColors, PpGuideOrientation, PpNumberedBulletStyle, PpParagraphAlignment, PpPlaceholderType, PpSaveAsFileType, PpSelectionType, PpSlideLayout, PpSlideSizeType, PpTextStyleType

You can use enum function to extract the enum values.

Author(s)

Yiying Wang [e-mail]

References

You can read the Microsoft official API document

• Office core: https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.core?view=office-pia

• Word: https://docs.microsoft.com/en-us/office/vba/api/word(enumerations)
  

• Excel: https://docs.microsoft.com/en-us/office/vba/api/excel(enumerations)
  

• PowerPoint: https://docs.microsoft.com/en-us/office/vba/api/Powerpoint(enumerations)

Examples

## Not run: 
data(ENUM)
ENUM$MsoShapeType$msoChart  # returns
# [1] 3

# or you can use
enum(msoChart)  # returns
# msoChart 
#        3 

## End(Not run)

madlogos/asesmso documentation built on June 26, 2019, 12:17 a.m.