Package: writexl 2.0.0

Bill Denney

writexl: Export Data Frames to Excel 'xlsx' Format

Zero-dependency data frame to xlsx exporter based on 'libxlsxwriter' <https://libxlsxwriter.github.io>. Fast and no Java or Excel required.

Authors:Jeroen Ooms [aut], Bill Denney [aut, cre], John McNamara [cph]

writexl_2.0.0.tar.gz
writexl_2.0.0.zip(r-4.7-x86_64)writexl_2.0.0.zip(r-4.7-arm64)writexl_2.0.0.zip(r-4.6-x86_64)writexl_2.0.0.zip(r-4.6-arm64)writexl_2.0.0.zip(r-4.5-x86_64)
writexl_2.0.0.tgz(r-4.6-x86_64)writexl_2.0.0.tgz(r-4.6-arm64)writexl_2.0.0.tgz(r-4.5-x86_64)writexl_2.0.0.tgz(r-4.5-arm64)
writexl_2.0.0.tar.gz(r-4.7-arm64)writexl_2.0.0.tar.gz(r-4.7-x86_64)writexl_2.0.0.tar.gz(r-4.6-arm64)writexl_2.0.0.tar.gz(r-4.6-x86_64)
writexl_2.0.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
writexl/json (API)

# Install 'writexl' in R:
install.packages('writexl', repos = c('https://packages.ropensci.org', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/ropensci/writexl/issues

Pkgdown/docs site:https://docs.ropensci.org

Uses libs:
  • zlib– Compression library

On CRAN:

Conda:

excellibxlsxwriterxlsxzlib

17.75 score 214 stars 258 packages 18k scripts 256k downloads 7 mentions 50 exports 0 dependencies

Last updated from:4e95cf3866 (on master). Checks:2 WARNING, 14 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-arm64WARNING155
linux-devel-x86_64WARNING177
pkgdown docsOK177
source / vignettesOK193
linux-release-arm64OK200
linux-release-x86_64OK171
macos-release-arm64OK146
macos-release-x86_64OK222
macos-oldrel-arm64OK193
macos-oldrel-x86_64OK239
windows-devel-arm64OK275
windows-devel-x86_64OK217
windows-release-arm64OK298
windows-release-x86_64OK160
windows-oldrel-x86_64OK186
wasm-releaseOK121

Exports:is_xl_commentis_xl_formatis_xl_rich_stringlxw_versionwrite_xlsxxl_alignxl_borderxl_cell_generalxl_chartxl_chart_axisxl_chart_error_barsxl_chart_labelxl_chart_labelsxl_chart_legendxl_chart_markerxl_chart_seriesxl_chart_tablexl_chart_trendlinexl_chartsheetxl_col_specxl_colorxl_commentxl_cond_barxl_cond_cellxl_cond_iconsxl_cond_scalexl_fillxl_filterxl_filter_keepxl_fontxl_formatxl_formulaxl_hyperlinkxl_hyperlink_cellxl_imagexl_mergexl_num_formatxl_outlinexl_page_setupxl_propertiesxl_protectionxl_rich_runxl_rich_stringxl_row_specxl_sheetxl_sheet_viewxl_tablexl_table_columnxl_validationxl_workbook

Dependencies:

Getting started with writexl
One data frame | Several sheets | What is written | Everything else | Reading it back
Rendered froma-getting-started.Rmdusingknitr::rmarkdown

Last update: 2026-08-03
Started: 2026-07-31

Charts and images
A chart | Naming a range | Styling | Axes | The parts of a series | The chart as a whole | A chart on a sheet of its own | Images
Rendered fromd-charts-images.Rmdusingknitr::rmarkdown

Last update: 2026-08-01
Started: 2026-07-31

Everything at once
Formatting --- vignette | Cell content --- vignette | Worksheet features --- vignette | Printing and the sheet view --- vignette | Charts --- vignette | An image --- vignette | The workbook --- vignette | The second workbook: an embedded image | What was written
Rendered fromf-everything-at-once.Rmdusingknitr::rmarkdown

Last update: 2026-07-31
Started: 2026-07-31

Formatting cells
Building a format | Applying it to cells | Applying it to columns and rows | Where a format comes from | Conditional formatting | Scales, bars and icons | What is elsewhere
Rendered fromb-formatting.Rmdusingknitr::rmarkdown

Last update: 2026-07-31
Started: 2026-07-31

Formulas, tables and the rest
What a cell can hold | Formulas | Hyperlinks | Comments | Rich strings | Mixed columns | Data validation | Autofilters | Worksheet tables | Merged cells | Elsewhere
Rendered frome-formulas-and-more.Rmdusingknitr::rmarkdown

Last update: 2026-07-31
Started: 2026-07-31

Worksheets and workbooks
The sheet | Grouping and outlines | Protection | Silencing Excel's error indicators | The tab strip and the opening view | Printing | The workbook | Memory | Elsewhere
Rendered fromc-worksheets-workbooks.Rmdusingknitr::rmarkdown

Last update: 2026-07-31
Started: 2026-07-31

Readme and manuals

Help Manual

Help pageTopics
Test whether an object is an `xl_comment`is_xl_comment
Test whether an object is an `xl_format`is_xl_format
Versionlxw_version
Export to xlsxwritexl write_xlsx
General cell objects for Excel writingas.character.xl_cell_general xl_cell_general
Add a chart to a worksheetxl_chart
An axis of a chartxl_chart_axis
Error bars on a chart seriesxl_chart_error_bars
Data labels on a chart seriesxl_chart_label xl_chart_labels
A chart's legendxl_chart_legend
A marker on a chart seriesxl_chart_marker
A data series within a chartxl_chart_series
The table of values under a chartxl_chart_table
A trendline on a chart seriesxl_chart_trendline
A sheet holding a single chartxl_chartsheet
Normalize a color to a libxlsxwriter RGB integerxl_color
Column and row specifications for a worksheetxl_colrow_spec xl_col_spec xl_row_spec
Create a cell commentxl_comment
Format cells according to their contentsxl_conditional xl_cond_bar xl_cond_cell xl_cond_icons xl_cond_scale
Filter an autofilter column, hiding the rows that do not matchxl_filter
Which rows an Excel autofilter would leave visiblexl_filter_keep
Combine cell-formatting groups into a single format+.xl_format xl_format
Cell formatting groupsxl_align xl_border xl_fill xl_font xl_format_groups xl_num_format xl_protection
Excel Typesxl_formula xl_hyperlink xl_hyperlink_cell
Insert an image into a worksheetxl_image
Merge a range of cellsxl_merge
Control how outline (grouping) symbols are drawnxl_outline
How a worksheet printsxl_page_setup
Workbook properties, defaults, and metadataxl_properties
One run of a rich (multi-format) stringxl_rich_run
A cell whose text has several formatsas.character.xl_rich_string is_xl_rich_string xl_rich_string
A worksheet with formatting and layout optionsxl_sheet
How a worksheet appears when it opensxl_sheet_view
Add a worksheet tablexl_table
Describe a column of a worksheet tablexl_table_column
Restrict what can be typed into a rangexl_validation
A workbook: sheets plus workbook-level propertiesxl_workbook