Create Native 'Excel' Charts and Work with Microsoft 'Excel'
Files
![[R logo]](../../../doc/html/Rlogo.svg)
![[Up]](../../../doc/html/left.jpg)
![[Top]](../../../doc/html/up.jpg)
Documentation for package ‘xlcharts’ version 0.0.2
Help Pages
A B C D E F G H I L M N O P Q R S T U V W X Y
-- A --
| AbsoluteAnchor | AbsoluteAnchor |
| absolute_coordinate | absolute_coordinate |
| active | active |
| add_chart | Add a chart to the sheet |
| add_data | Add a range of data in a single pass. |
| add_table | Check for duplicate name in definedNames and other worksheet tables before adding table. |
| AdjPoint2D | AdjPoint2D |
| AdjustHandleList | AdjustHandleList |
| Alignment | Alignment |
| AlphaBiLevelEffect | AlphaBiLevelEffect |
| AlphaCeilingEffect | AlphaCeilingEffect |
| AlphaFloorEffect | AlphaFloorEffect |
| AlphaInverseEffect | AlphaInverseEffect |
| AlphaModulateEffect | AlphaModulateEffect |
| AlphaModulateFixedEffect | AlphaModulateFixedEffect |
| AlphaReplaceEffect | AlphaReplaceEffect |
| AnchorClientData | AnchorClientData |
| AnchorMarker | AnchorMarker |
| angle_to_degrees | angle_to_degrees |
| AreaChart | AreaChart |
| AreaChart3D | AreaChart3D |
| ArrayDescriptor | ArrayDescriptor |
| ArrayFormula | ArrayFormula |
| AuthorList | AuthorList |
| AutoFilter | AutoFilter |
| AutonumberBullet | AutonumberBullet |
| avoid_duplicate_name | avoid_duplicate_name |
| AxDataSource | AxDataSource |
-- B --
| Backdrop | Backdrop |
| BandFormat | BandFormat |
| BandFormatList | BandFormatList |
| BarChart | BarChart |
| BarChart3D | BarChart3D |
| Bevel | Bevel |
| BiLevelEffect | BiLevelEffect |
| Blip | Blip |
| BlipFillProperties | BlipFillProperties |
| BlurEffect | BlurEffect |
| BookView | BookView |
| Border | Border |
| Break | Break |
| BubbleChart | BubbleChart |
| builtin_format_code | builtin_format_code |
| builtin_format_id | builtin_format_id |
-- C --
| CalcProperties | CalcProperties |
| Camera | Camera |
| cast_numeric | cast_numeric |
| cast_percentage | cast_percentage |
| cast_time | cast_time |
| Cell | Cell |
| CellIsRule | CellIsRule |
| CellRange | CellRange |
| CellSmartTag | CellSmartTag |
| CellSmartTagPr | CellSmartTagPr |
| CellSmartTags | CellSmartTags |
| CellStyle | CellStyle |
| CellStyleList | CellStyleList |
| CellWatch | CellWatch |
| CellWatches | CellWatches |
| CharacterProperties | CharacterProperties |
| ChartContainer | ChartContainer |
| ChartLines | ChartLines |
| ChartRelation | ChartRelation |
| Chartsheet | Chartsheet |
| ChartsheetProperties | ChartsheetProperties |
| ChartsheetProtection | ChartsheetProtection |
| ChartsheetView | ChartsheetView |
| ChartsheetViewList | ChartsheetViewList |
| ChartSpace | ChartSpace |
| cm_to_dxa | cm_to_dxa |
| cm_to_EMU | cm_to_EMU |
| ColBreak | ColBreak |
| Color | Color |
| ColorChangeEffect | ColorChangeEffect |
| ColorChoice | ColorChoice |
| ColorFilter | ColorFilter |
| ColorList | ColorList |
| ColorMapping | ColorMapping |
| ColorReplaceEffect | ColorReplaceEffect |
| ColorScale | ColorScale |
| ColorScaleRule | ColorScaleRule |
| ColRange | ColRange |
| ColumnDimension | ColumnDimension |
| column_index_from_string | column_index_from_string |
| Comment | Comment |
| CommentRecord | CommentRecord |
| CommentSheet | CommentSheet |
| ConditionalFormatting | ConditionalFormatting |
| ConditionalFormattingList | ConditionalFormattingList |
| Connection | Connection |
| ConnectionSite | ConnectionSite |
| ConnectionSiteList | ConnectionSiteList |
| ConnectorLocking | ConnectorLocking |
| Control | Control |
| ControlProperty | ControlProperty |
| Controls | Controls |
| coordinate_from_string | coordinate_from_string |
| coordinate_to_tuple | coordinate_to_tuple |
| CustomFilter | CustomFilter |
| CustomFilters | CustomFilters |
| CustomGeometry2D | CustomGeometry2D |
| CustomProperties | CustomProperties |
| CustomProperty | CustomProperty |
| CustomSplit | CustomSplit |
-- D --
| DashStop | DashStop |
| DashStopList | DashStopList |
| DataBar | DataBar |
| DataBarRule | DataBarRule |
| DataLabel | DataLabel |
| DataLabelList | DataLabelList |
| DataPoint | DataPoint |
| DataTable | DataTable |
| DataTableFormula | DataTableFormula |
| DataValidation | DataValidation |
| DataValidationList | DataValidationList |
| DateAxis | DateAxis |
| DateGroupItem | DateGroupItem |
| deepcopy | Deep copy operation from deepcopy Python module |
| DefinedName | DefinedName |
| DefinedNameList | DefinedNameList |
| degrees_to_angle | degrees_to_angle |
| DifferentialStyle | DifferentialStyle |
| DifferentialStyleList | DifferentialStyleList |
| Dimension | Dimension |
| DimensionHolder | DimensionHolder |
| DisplayUnitsLabel | DisplayUnitsLabel |
| DisplayUnitsLabelList | DisplayUnitsLabelList |
| DocumentProperties | DocumentProperties |
| DocumentSecurity | DocumentSecurity |
| DoughnutChart | DoughnutChart |
| Drawing | Drawing |
| DrawingHF | DrawingHF |
| DummyWorksheet | DummyWorksheet |
| DuotoneEffect | DuotoneEffect |
| dxa_to_cm | dxa_to_cm |
| DynamicFilter | DynamicFilter |
-- E --
| EffectContainer | EffectContainer |
| EffectList | EffectList |
| EmbeddedWAVAudioFile | EmbeddedWAVAudioFile |
| EmptyCell | EmptyCell |
| EMU_to_cm | EMU_to_cm |
| EMU_to_inch | EMU_to_inch |
| EMU_to_pixels | EMU_to_pixels |
| ErrorBars | ErrorBars |
| ExcelReader | ExcelReader |
| ExcelWriter | ExcelWriter |
| expand_cell_ranges | expand_cell_ranges |
| Extension | Extension |
| ExtensionList | ExtensionList |
| ExternalBook | ExternalBook |
| ExternalCell | ExternalCell |
| ExternalData | ExternalData |
| ExternalDefinedName | ExternalDefinedName |
| ExternalLink | ExternalLink |
| ExternalReference | ExternalReference |
| ExternalSheetDataSet | ExternalSheetDataSet |
| ExternalSheetNames | ExternalSheetNames |
-- F --
| FileSharing | FileSharing |
| FileVersion | FileVersion |
| Fill | Fill |
| FillOverlayEffect | FillOverlayEffect |
| FilterColumn | FilterColumn |
| Filters | Filters |
| Font | Font |
| FontReference | FontReference |
| FormatObject | FormatObject |
| FormulaRule | FormulaRule |
| FunctionGroup | FunctionGroup |
| FunctionGroupList | FunctionGroupList |
-- G --
| GeomGuide | GeomGuide |
| GeomGuideList | GeomGuideList |
| GeomRect | GeomRect |
| get_column_interval | get_column_interval |
| get_column_letter | get_column_letter |
| get_type | get_type |
| GlowEffect | GlowEffect |
| GradientFill | GradientFill |
| GradientFillProperties | GradientFillProperties |
| GradientStop | GradientStop |
| GraphicalProperties | GraphicalProperties |
| GraphicData | GraphicData |
| GraphicFrameLocking | GraphicFrameLocking |
| GraphicObject | GraphicObject |
| GrayscaleEffect | GrayscaleEffect |
| GroupLocking | GroupLocking |
| GroupShapeProperties | GroupShapeProperties |
| GroupTransform2D | GroupTransform2D |
-- H --
| hash_password | hash_password |
| HeaderFooter | HeaderFooter |
| HeaderFooterItem | HeaderFooterItem |
| HSLColor | HSLColor |
| HSLEffect | HSLEffect |
| Hyperlink | Hyperlink |
| HyperlinkList | HyperlinkList |
-- I --
| iadd | iadd from operator Python module |
| IconFilter | IconFilter |
| IconSet | IconSet |
| IconSetRule | IconSetRule |
| IgnoredError | IgnoredError |
| IgnoredErrors | IgnoredErrors |
| Image | Image |
| inch_to_dxa | inch_to_dxa |
| inch_to_EMU | inch_to_EMU |
| InlineFont | InlineFont |
| InnerShadowEffect | InnerShadowEffect |
| InputCells | InputCells |
| install_openpyxl | Install openpyxl Python module |
| install_pillow | Install pillow Python module |
-- L --
| Layout | Layout |
| Legend | Legend |
| LegendEntry | LegendEntry |
| Level | Level |
| LightRig | LightRig |
| LinearShadeProperties | LinearShadeProperties |
| LineBreak | LineBreak |
| LineChart | LineChart |
| LineChart3D | LineChart3D |
| LineEndProperties | LineEndProperties |
| LineProperties | LineProperties |
| ListStyle | ListStyle |
| load_workbook | load_workbook |
| LuminanceEffect | LuminanceEffect |
-- M --
| ManualLayout | ManualLayout |
| Marker | Marker |
| MergeCell | MergeCell |
| MergeCells | MergeCells |
| MergedCell | MergedCell |
| MergedCellRange | MergedCellRange |
| MultiCellRange | MultiCellRange |
| MultiLevelStrData | MultiLevelStrData |
| MultiLevelStrRef | MultiLevelStrRef |
-- N --
| NamedStyle | NamedStyle |
| NamedStyleList | NamedStyleList |
| NestedGapAmount | NestedGapAmount |
| NestedOverlap | NestedOverlap |
| NonVisualConnectorProperties | NonVisualConnectorProperties |
| NonVisualDrawingShapeProps | NonVisualDrawingShapeProps |
| NonVisualGraphicFrameProperties | NonVisualGraphicFrameProperties |
| NonVisualPictureProperties | NonVisualPictureProperties |
| NumData | NumData |
| NumDataSource | NumDataSource |
| NumericAxis | NumericAxis |
| NumFmt | NumFmt |
| NumRef | NumRef |
| NumVal | NumVal |
-- O --
| ObjectAnchor | ObjectAnchor |
| OneCellAnchor | OneCellAnchor |
| Outline | Outline |
-- P --
| PageBreak | PageBreak |
| PageMargins | PageMargins |
| PageSetupProperties | PageSetupProperties |
| Pane | Pane |
| Paragraph | Paragraph |
| ParagraphProperties | ParagraphProperties |
| Path2D | Path2D |
| Path2DList | Path2DList |
| PathShadeProperties | PathShadeProperties |
| PatternFill | PatternFill |
| PatternFillProperties | PatternFillProperties |
| PhoneticProperties | PhoneticProperties |
| PhoneticText | PhoneticText |
| PieChart | PieChart |
| PieChart3D | PieChart3D |
| PivotFormat | PivotFormat |
| PivotSource | PivotSource |
| pixels_to_EMU | pixels_to_EMU |
| pixels_to_points | pixels_to_points |
| PlotArea | PlotArea |
| Point2D | Point2D |
| Point3D | Point3D |
| points_to_pixels | points_to_pixels |
| PositiveSize2D | PositiveSize2D |
| PresetGeometry2D | PresetGeometry2D |
| PresetShadowEffect | PresetShadowEffect |
| PrintArea | PrintArea |
| PrintOptions | PrintOptions |
| PrintPageSetup | PrintPageSetup |
| PrintSettings | PrintSettings |
| PrintTitles | PrintTitles |
| ProjectedPieChart | ProjectedPieChart |
| Protection | Protection |
-- Q --
| quote_sheetname | quote_sheetname |
-- R --
| RadarChart | RadarChart |
| range_boundaries | range_boundaries |
| range_to_tuple | range_to_tuple |
| ReadOnlyCell | ReadOnlyCell |
| Reference | Reference |
| RegularTextRun | RegularTextRun |
| Related | Related |
| RelativeRect | RelativeRect |
| RichTextProperties | RichTextProperties |
| RowBreak | RowBreak |
| RowDimension | RowDimension |
| RowRange | RowRange |
| rows_from_range | rows_from_range |
| Rule | Rule |
| RuleType | RuleType |
-- S --
| save_workbook | save_workbook |
| Scaling | Scaling |
| ScatterChart | ScatterChart |
| Scenario | Scenario |
| ScenarioList | ScenarioList |
| Scene3D | Scene3D |
| SchemeColor | SchemeColor |
| Selection | Selection |
| Series | Series |
| SeriesAxis | SeriesAxis |
| SeriesFactory | SeriesFactory |
| SeriesLabel | SeriesLabel |
| set_categories | set_categories |
| Shape | Shape |
| Shape3D | Shape3D |
| ShapeStyle | ShapeStyle |
| SheetBackgroundPicture | SheetBackgroundPicture |
| SheetDimension | SheetDimension |
| SheetFormatProperties | SheetFormatProperties |
| SheetProtection | SheetProtection |
| SheetView | SheetView |
| SheetViewList | SheetViewList |
| short_color | short_color |
| Side | Side |
| SmartTag | SmartTag |
| SmartTagList | SmartTagList |
| SmartTagProperties | SmartTagProperties |
| SmartTags | SmartTags |
| SoftEdgesEffect | SoftEdgesEffect |
| SolidColorFillProperties | SolidColorFillProperties |
| SortCondition | SortCondition |
| SortState | SortState |
| Spacing | Spacing |
| SphereCoords | SphereCoords |
| SpreadsheetDrawing | SpreadsheetDrawing |
| StockChart | StockChart |
| Stop | Stop |
| StopList | StopList |
| StrData | StrData |
| StretchInfoProperties | StretchInfoProperties |
| StrRef | StrRef |
| StrVal | StrVal |
| StyleArray | StyleArray |
| StyleMatrixReference | StyleMatrixReference |
| Stylesheet | Stylesheet |
| SurfaceChart | SurfaceChart |
| SurfaceChart3D | SurfaceChart3D |
| SystemColor | SystemColor |
-- T --
| Table | Table |
| TableColumn | TableColumn |
| TableFormula | TableFormula |
| TableNameDescriptor | TableNameDescriptor |
| TablePartList | TablePartList |
| TableStyle | TableStyle |
| TableStyleElement | TableStyleElement |
| TableStyleInfo | TableStyleInfo |
| TableStyleList | TableStyleList |
| TextAxis | TextAxis |
| TextBlock | TextBlock |
| TextField | TextField |
| TextNormalAutofit | TextNormalAutofit |
| TintEffect | TintEffect |
| Title | Title |
| TitleDescriptor | TitleDescriptor |
| title_maker | title_maker |
| Transform2D | Transform2D |
| Trendline | Trendline |
| TrendlineLabel | TrendlineLabel |
| TwoCellAnchor | TwoCellAnchor |
-- U --
| UpDownBars | UpDownBars |
-- V --
| ValueDescriptor | ValueDescriptor |
| Vector3D | Vector3D |
-- W --
| WebPublishing | WebPublishing |
| WebPublishItem | WebPublishItem |
| WebPublishObject | WebPublishObject |
| WebPublishObjectList | WebPublishObjectList |
| Workbook | Workbook |
| WorkbookParser | WorkbookParser |
| WorkbookProperties | WorkbookProperties |
| WorkbookProtection | WorkbookProtection |
| WorksheetCopy | WorksheetCopy |
| WorksheetProperties | WorksheetProperties |
| WriteOnlyCell | WriteOnlyCell |
| write_stylesheet | write_stylesheet |
-- X --
| XDRPoint2D | XDRPoint2D |
| XDRPositiveSize2D | XDRPositiveSize2D |
| XDRTransform2D | XDRTransform2D |
| XMLColumnProps | XMLColumnProps |
| XYSeries | XYSeries |
| x_axis | x_axis |
-- Y --
| y_axis | y_axis |