Package: xlcharts 0.0.2

xlcharts: Create Native 'Excel' Charts and Work with Microsoft 'Excel' Files

An R interface to the 'OpenPyXL' 'Python' library to create native 'Excel' charts and work with Microsoft 'Excel' files.

Authors:Felix Luginbuhl [aut, cre, cph], Eric Gazoni [ctb, cph], Charlie Clark [ctb, cph], openpyxl authors [ctb, cph]

xlcharts_0.0.2.tar.gz
xlcharts_0.0.2.zip(r-4.5)xlcharts_0.0.2.zip(r-4.4)xlcharts_0.0.2.zip(r-4.3)
xlcharts_0.0.2.tgz(r-4.4-any)xlcharts_0.0.2.tgz(r-4.3-any)
xlcharts_0.0.2.tar.gz(r-4.5-noble)xlcharts_0.0.2.tar.gz(r-4.4-noble)
xlcharts_0.0.2.tgz(r-4.4-emscripten)xlcharts_0.0.2.tgz(r-4.3-emscripten)
xlcharts.pdf |xlcharts.html
xlcharts/json (API)
NEWS

# Install 'xlcharts' in R:
install.packages('xlcharts', repos = c('https://lgnbhl.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/lgnbhl/xlcharts/issues

On CRAN:

excel

4.30 score 10 stars 4 scripts 553 downloads 389 exports 13 dependencies

Last updated 2 months agofrom:1a7dfaef73. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKNov 11 2024
R-4.5-winOKNov 11 2024
R-4.5-linuxOKNov 11 2024
R-4.4-winOKNov 11 2024
R-4.4-macOKNov 11 2024
R-4.3-winOKNov 11 2024
R-4.3-macOKNov 11 2024

Exports:absolute_coordinateAbsoluteAnchoractiveadd_chartadd_dataadd_tableAdjPoint2DAdjustHandleListAlignmentAlphaBiLevelEffectAlphaCeilingEffectAlphaFloorEffectAlphaInverseEffectAlphaModulateEffectAlphaModulateFixedEffectAlphaReplaceEffectAnchorClientDataAnchorMarkerangle_to_degreesAreaChartAreaChart3DArrayDescriptorArrayFormulaAuthorListAutoFilterAutonumberBulletavoid_duplicate_nameAxDataSourceBackdropBandFormatBandFormatListBarChartBarChart3DBevelBiLevelEffectBlipBlipFillPropertiesBlurEffectBookViewBorderBreakBubbleChartbuiltin_format_codebuiltin_format_idCalcPropertiesCameracast_numericcast_percentagecast_timeCellCellIsRuleCellRangeCellSmartTagCellSmartTagPrCellSmartTagsCellStyleCellStyleListCellWatchCellWatchesCharacterPropertiesChartContainerChartLinesChartRelationChartsheetChartsheetPropertiesChartsheetProtectionChartsheetViewChartsheetViewListChartSpacecm_to_dxacm_to_EMUColBreakColorColorChangeEffectColorChoiceColorFilterColorListColorMappingColorReplaceEffectColorScaleColorScaleRuleColRangecolumn_index_from_stringColumnDimensionCommentCommentRecordCommentSheetConditionalFormattingConditionalFormattingListConnectionConnectionSiteConnectionSiteListConnectorLockingControlControlPropertyControlscoordinate_from_stringcoordinate_to_tupleCustomFilterCustomFiltersCustomGeometry2DCustomPropertiesCustomPropertyCustomSplitDashStopDashStopListDataBarDataBarRuleDataLabelDataLabelListDataPointDataTableDataTableFormulaDataValidationDataValidationListDateAxisDateGroupItemdeepcopyDefinedNameDefinedNameListdegrees_to_angleDifferentialStyleDifferentialStyleListDimensionDimensionHolderDisplayUnitsLabelDisplayUnitsLabelListDocumentPropertiesDocumentSecurityDoughnutChartDrawingDrawingHFDummyWorksheetDuotoneEffectdxa_to_cmDynamicFilterEffectContainerEffectListEmbeddedWAVAudioFileEmptyCellEMU_to_cmEMU_to_inchEMU_to_pixelsErrorBarsExcelReaderExcelWriterexpand_cell_rangesExtensionExtensionListExternalBookExternalCellExternalDataExternalDefinedNameExternalLinkExternalReferenceExternalSheetDataSetExternalSheetNamesFileSharingFileVersionFillFillOverlayEffectFilterColumnFiltersFontFontReferenceFormatObjectFormulaRuleFunctionGroupFunctionGroupListGeomGuideGeomGuideListGeomRectget_column_intervalget_column_letterget_typeGlowEffectGradientFillGradientFillPropertiesGradientStopGraphicalPropertiesGraphicDataGraphicFrameLockingGraphicObjectGrayscaleEffectGroupLockingGroupShapePropertiesGroupTransform2Dhash_passwordHeaderFooterHeaderFooterItemHSLColorHSLEffectHyperlinkHyperlinkListiaddIconFilterIconSetIconSetRuleIgnoredErrorIgnoredErrorsImageinch_to_dxainch_to_EMUInlineFontInnerShadowEffectInputCellsinstall_openpyxlinstall_pillowLayoutLegendLegendEntryLevelLightRigLinearShadePropertiesLineBreakLineChartLineChart3DLineEndPropertiesLinePropertiesListStyleload_workbookLuminanceEffectManualLayoutMarkerMergeCellMergeCellsMergedCellMergedCellRangeMultiCellRangeMultiLevelStrDataMultiLevelStrRefNamedStyleNamedStyleListNestedGapAmountNestedOverlapNonVisualConnectorPropertiesNonVisualDrawingShapePropsNonVisualGraphicFramePropertiesNonVisualPicturePropertiesNumDataNumDataSourceNumericAxisNumFmtNumRefNumValObjectAnchorOneCellAnchorOutlinePageBreakPageMarginsPageSetupPropertiesPaneParagraphParagraphPropertiesPath2DPath2DListPathShadePropertiesPatternFillPatternFillPropertiesPhoneticPropertiesPhoneticTextPieChartPieChart3DPivotFormatPivotSourcepixels_to_EMUpixels_to_pointsPlotAreaPoint2DPoint3Dpoints_to_pixelsPositiveSize2DPresetGeometry2DPresetShadowEffectPrintAreaPrintOptionsPrintPageSetupPrintSettingsPrintTitlesProjectedPieChartProtectionquote_sheetnameRadarChartrange_boundariesrange_to_tupleReadOnlyCellReferenceRegularTextRunRelatedRelativeRectRichTextPropertiesRowBreakRowDimensionRowRangerows_from_rangeRuleRuleTypesave_workbookScalingScatterChartScenarioScenarioListScene3DSchemeColorSelectionSeriesSeriesAxisSeriesFactorySeriesLabelset_categoriesShapeShape3DShapeStyleSheetBackgroundPictureSheetDimensionSheetFormatPropertiesSheetProtectionSheetViewSheetViewListshort_colorSideSmartTagSmartTagListSmartTagPropertiesSmartTagsSoftEdgesEffectSolidColorFillPropertiesSortConditionSortStateSpacingSphereCoordsSpreadsheetDrawingStockChartStopStopListStrDataStretchInfoPropertiesStrRefStrValStyleArrayStyleMatrixReferenceStylesheetSurfaceChartSurfaceChart3DSystemColorTableTableColumnTableFormulaTableNameDescriptorTablePartListTableStyleTableStyleElementTableStyleInfoTableStyleListTextAxisTextBlockTextFieldTextNormalAutofitTintEffectTitletitle_makerTitleDescriptorTransform2DTrendlineTrendlineLabelTwoCellAnchorUpDownBarsValueDescriptorVector3DWebPublishingWebPublishItemWebPublishObjectWebPublishObjectListWorkbookWorkbookParserWorkbookPropertiesWorkbookProtectionWorksheetCopyWorksheetPropertieswrite_stylesheetwrite_xlsxWriteOnlyCellx_axisXDRPoint2DXDRPositiveSize2DXDRTransform2DXMLColumnPropsXYSeriesy_axis

Dependencies:herejsonlitelatticeMatrixpngrappdirsRcppRcppTOMLreticulaterlangrprojrootwithrwritexl

Readme and manuals

Help Manual

Help pageTopics
absolute_coordinateabsolute_coordinate
AbsoluteAnchorAbsoluteAnchor
activeactive
Add a chart to the sheetadd_chart
Add a range of data in a single pass.add_data
Check for duplicate name in definedNames and other worksheet tables before adding table.add_table
AdjPoint2DAdjPoint2D
AdjustHandleListAdjustHandleList
AlignmentAlignment
AlphaBiLevelEffectAlphaBiLevelEffect
AlphaCeilingEffectAlphaCeilingEffect
AlphaFloorEffectAlphaFloorEffect
AlphaInverseEffectAlphaInverseEffect
AlphaModulateEffectAlphaModulateEffect
AlphaModulateFixedEffectAlphaModulateFixedEffect
AlphaReplaceEffectAlphaReplaceEffect
AnchorClientDataAnchorClientData
AnchorMarkerAnchorMarker
angle_to_degreesangle_to_degrees
AreaChartAreaChart
AreaChart3DAreaChart3D
ArrayDescriptorArrayDescriptor
ArrayFormulaArrayFormula
AuthorListAuthorList
AutoFilterAutoFilter
AutonumberBulletAutonumberBullet
avoid_duplicate_nameavoid_duplicate_name
AxDataSourceAxDataSource
BackdropBackdrop
BandFormatBandFormat
BandFormatListBandFormatList
BarChartBarChart
BarChart3DBarChart3D
BevelBevel
BiLevelEffectBiLevelEffect
BlipBlip
BlipFillPropertiesBlipFillProperties
BlurEffectBlurEffect
BookViewBookView
BorderBorder
BreakBreak
BubbleChartBubbleChart
builtin_format_codebuiltin_format_code
builtin_format_idbuiltin_format_id
CalcPropertiesCalcProperties
CameraCamera
cast_numericcast_numeric
cast_percentagecast_percentage
cast_timecast_time
CellCell
CellIsRuleCellIsRule
CellRangeCellRange
CellSmartTagCellSmartTag
CellSmartTagPrCellSmartTagPr
CellSmartTagsCellSmartTags
CellStyleCellStyle
CellStyleListCellStyleList
CellWatchCellWatch
CellWatchesCellWatches
CharacterPropertiesCharacterProperties
ChartContainerChartContainer
ChartLinesChartLines
ChartRelationChartRelation
ChartsheetChartsheet
ChartsheetPropertiesChartsheetProperties
ChartsheetProtectionChartsheetProtection
ChartsheetViewChartsheetView
ChartsheetViewListChartsheetViewList
ChartSpaceChartSpace
cm_to_dxacm_to_dxa
cm_to_EMUcm_to_EMU
ColBreakColBreak
ColorColor
ColorChangeEffectColorChangeEffect
ColorChoiceColorChoice
ColorFilterColorFilter
ColorListColorList
ColorMappingColorMapping
ColorReplaceEffectColorReplaceEffect
ColorScaleColorScale
ColorScaleRuleColorScaleRule
ColRangeColRange
column_index_from_stringcolumn_index_from_string
ColumnDimensionColumnDimension
CommentComment
CommentRecordCommentRecord
CommentSheetCommentSheet
ConditionalFormattingConditionalFormatting
ConditionalFormattingListConditionalFormattingList
ConnectionConnection
ConnectionSiteConnectionSite
ConnectionSiteListConnectionSiteList
ConnectorLockingConnectorLocking
ControlControl
ControlPropertyControlProperty
ControlsControls
coordinate_from_stringcoordinate_from_string
coordinate_to_tuplecoordinate_to_tuple
CustomFilterCustomFilter
CustomFiltersCustomFilters
CustomGeometry2DCustomGeometry2D
CustomPropertiesCustomProperties
CustomPropertyCustomProperty
CustomSplitCustomSplit
DashStopDashStop
DashStopListDashStopList
DataBarDataBar
DataBarRuleDataBarRule
DataLabelDataLabel
DataLabelListDataLabelList
DataPointDataPoint
DataTableDataTable
DataTableFormulaDataTableFormula
DataValidationDataValidation
DataValidationListDataValidationList
DateAxisDateAxis
DateGroupItemDateGroupItem
Deep copy operation from deepcopy Python moduledeepcopy
DefinedNameDefinedName
DefinedNameListDefinedNameList
degrees_to_angledegrees_to_angle
DifferentialStyleDifferentialStyle
DifferentialStyleListDifferentialStyleList
DimensionDimension
DimensionHolderDimensionHolder
DisplayUnitsLabelDisplayUnitsLabel
DisplayUnitsLabelListDisplayUnitsLabelList
DocumentPropertiesDocumentProperties
DocumentSecurityDocumentSecurity
DoughnutChartDoughnutChart
DrawingDrawing
DrawingHFDrawingHF
DummyWorksheetDummyWorksheet
DuotoneEffectDuotoneEffect
dxa_to_cmdxa_to_cm
DynamicFilterDynamicFilter
EffectContainerEffectContainer
EffectListEffectList
EmbeddedWAVAudioFileEmbeddedWAVAudioFile
EmptyCellEmptyCell
EMU_to_cmEMU_to_cm
EMU_to_inchEMU_to_inch
EMU_to_pixelsEMU_to_pixels
ErrorBarsErrorBars
ExcelReaderExcelReader
ExcelWriterExcelWriter
expand_cell_rangesexpand_cell_ranges
ExtensionExtension
ExtensionListExtensionList
ExternalBookExternalBook
ExternalCellExternalCell
ExternalDataExternalData
ExternalDefinedNameExternalDefinedName
ExternalLinkExternalLink
ExternalReferenceExternalReference
ExternalSheetDataSetExternalSheetDataSet
ExternalSheetNamesExternalSheetNames
FileSharingFileSharing
FileVersionFileVersion
FillFill
FillOverlayEffectFillOverlayEffect
FilterColumnFilterColumn
FiltersFilters
FontFont
FontReferenceFontReference
FormatObjectFormatObject
FormulaRuleFormulaRule
FunctionGroupFunctionGroup
FunctionGroupListFunctionGroupList
GeomGuideGeomGuide
GeomGuideListGeomGuideList
GeomRectGeomRect
get_column_intervalget_column_interval
get_column_letterget_column_letter
get_typeget_type
GlowEffectGlowEffect
GradientFillGradientFill
GradientFillPropertiesGradientFillProperties
GradientStopGradientStop
GraphicalPropertiesGraphicalProperties
GraphicDataGraphicData
GraphicFrameLockingGraphicFrameLocking
GraphicObjectGraphicObject
GrayscaleEffectGrayscaleEffect
GroupLockingGroupLocking
GroupShapePropertiesGroupShapeProperties
GroupTransform2DGroupTransform2D
hash_passwordhash_password
HeaderFooterHeaderFooter
HeaderFooterItemHeaderFooterItem
HSLColorHSLColor
HSLEffectHSLEffect
HyperlinkHyperlink
HyperlinkListHyperlinkList
iadd from operator Python moduleiadd
IconFilterIconFilter
IconSetIconSet
IconSetRuleIconSetRule
IgnoredErrorIgnoredError
IgnoredErrorsIgnoredErrors
ImageImage
inch_to_dxainch_to_dxa
inch_to_EMUinch_to_EMU
InlineFontInlineFont
InnerShadowEffectInnerShadowEffect
InputCellsInputCells
Install openpyxl Python moduleinstall_openpyxl
Install pillow Python moduleinstall_pillow
LayoutLayout
LegendLegend
LegendEntryLegendEntry
LevelLevel
LightRigLightRig
LinearShadePropertiesLinearShadeProperties
LineBreakLineBreak
LineChartLineChart
LineChart3DLineChart3D
LineEndPropertiesLineEndProperties
LinePropertiesLineProperties
ListStyleListStyle
load_workbookload_workbook
LuminanceEffectLuminanceEffect
ManualLayoutManualLayout
MarkerMarker
MergeCellMergeCell
MergeCellsMergeCells
MergedCellMergedCell
MergedCellRangeMergedCellRange
MultiCellRangeMultiCellRange
MultiLevelStrDataMultiLevelStrData
MultiLevelStrRefMultiLevelStrRef
NamedStyleNamedStyle
NamedStyleListNamedStyleList
NestedGapAmountNestedGapAmount
NestedOverlapNestedOverlap
NonVisualConnectorPropertiesNonVisualConnectorProperties
NonVisualDrawingShapePropsNonVisualDrawingShapeProps
NonVisualGraphicFramePropertiesNonVisualGraphicFrameProperties
NonVisualPicturePropertiesNonVisualPictureProperties
NumDataNumData
NumDataSourceNumDataSource
NumericAxisNumericAxis
NumFmtNumFmt
NumRefNumRef
NumValNumVal
ObjectAnchorObjectAnchor
OneCellAnchorOneCellAnchor
OutlineOutline
PageBreakPageBreak
PageMarginsPageMargins
PageSetupPropertiesPageSetupProperties
PanePane
ParagraphParagraph
ParagraphPropertiesParagraphProperties
Path2DPath2D
Path2DListPath2DList
PathShadePropertiesPathShadeProperties
PatternFillPatternFill
PatternFillPropertiesPatternFillProperties
PhoneticPropertiesPhoneticProperties
PhoneticTextPhoneticText
PieChartPieChart
PieChart3DPieChart3D
PivotFormatPivotFormat
PivotSourcePivotSource
pixels_to_EMUpixels_to_EMU
pixels_to_pointspixels_to_points
PlotAreaPlotArea
Point2DPoint2D
Point3DPoint3D
points_to_pixelspoints_to_pixels
PositiveSize2DPositiveSize2D
PresetGeometry2DPresetGeometry2D
PresetShadowEffectPresetShadowEffect
PrintAreaPrintArea
PrintOptionsPrintOptions
PrintPageSetupPrintPageSetup
PrintSettingsPrintSettings
PrintTitlesPrintTitles
ProjectedPieChartProjectedPieChart
ProtectionProtection
quote_sheetnamequote_sheetname
RadarChartRadarChart
range_boundariesrange_boundaries
range_to_tuplerange_to_tuple
ReadOnlyCellReadOnlyCell
ReferenceReference
RegularTextRunRegularTextRun
RelatedRelated
RelativeRectRelativeRect
RichTextPropertiesRichTextProperties
RowBreakRowBreak
RowDimensionRowDimension
RowRangeRowRange
rows_from_rangerows_from_range
RuleRule
RuleTypeRuleType
save_workbooksave_workbook
ScalingScaling
ScatterChartScatterChart
ScenarioScenario
ScenarioListScenarioList
Scene3DScene3D
SchemeColorSchemeColor
SelectionSelection
SeriesSeries
SeriesAxisSeriesAxis
SeriesFactorySeriesFactory
SeriesLabelSeriesLabel
set_categoriesset_categories
ShapeShape
Shape3DShape3D
ShapeStyleShapeStyle
SheetBackgroundPictureSheetBackgroundPicture
SheetDimensionSheetDimension
SheetFormatPropertiesSheetFormatProperties
SheetProtectionSheetProtection
SheetViewSheetView
SheetViewListSheetViewList
short_colorshort_color
SideSide
SmartTagSmartTag
SmartTagListSmartTagList
SmartTagPropertiesSmartTagProperties
SmartTagsSmartTags
SoftEdgesEffectSoftEdgesEffect
SolidColorFillPropertiesSolidColorFillProperties
SortConditionSortCondition
SortStateSortState
SpacingSpacing
SphereCoordsSphereCoords
SpreadsheetDrawingSpreadsheetDrawing
StockChartStockChart
StopStop
StopListStopList
StrDataStrData
StretchInfoPropertiesStretchInfoProperties
StrRefStrRef
StrValStrVal
StyleArrayStyleArray
StyleMatrixReferenceStyleMatrixReference
StylesheetStylesheet
SurfaceChartSurfaceChart
SurfaceChart3DSurfaceChart3D
SystemColorSystemColor
TableTable
TableColumnTableColumn
TableFormulaTableFormula
TableNameDescriptorTableNameDescriptor
TablePartListTablePartList
TableStyleTableStyle
TableStyleElementTableStyleElement
TableStyleInfoTableStyleInfo
TableStyleListTableStyleList
TextAxisTextAxis
TextBlockTextBlock
TextFieldTextField
TextNormalAutofitTextNormalAutofit
TintEffectTintEffect
TitleTitle
title_makertitle_maker
TitleDescriptorTitleDescriptor
Transform2DTransform2D
TrendlineTrendline
TrendlineLabelTrendlineLabel
TwoCellAnchorTwoCellAnchor
UpDownBarsUpDownBars
ValueDescriptorValueDescriptor
Vector3DVector3D
WebPublishingWebPublishing
WebPublishItemWebPublishItem
WebPublishObjectWebPublishObject
WebPublishObjectListWebPublishObjectList
WorkbookWorkbook
WorkbookParserWorkbookParser
WorkbookPropertiesWorkbookProperties
WorkbookProtectionWorkbookProtection
WorksheetCopyWorksheetCopy
WorksheetPropertiesWorksheetProperties
write_stylesheetwrite_stylesheet
WriteOnlyCellWriteOnlyCell
x_axisx_axis
XDRPoint2DXDRPoint2D
XDRPositiveSize2DXDRPositiveSize2D
XDRTransform2DXDRTransform2D
XMLColumnPropsXMLColumnProps
XYSeriesXYSeries
y_axisy_axis