Learn R Programming

⚠️There's a newer version (0.9.5) of this package.Take me there.

flextable R package

The user documentation is available here: https://ardata-fr.github.io/flextable-book/

set_flextable_defaults(
  font.family = "Arial", font.size = 10, 
  border.color = "gray")

flextable(head(cars)) %>% 
  bold(part = "header") %>% 
  add_footer_lines("The 'cars' dataset")

Tables can be embedded within HTML, PDF, Word and PowerPoint documents from R Markdown documents and within Microsoft Word or PowerPoint documents with package officer. Tables can also be rendered as R plots or graphic files (png, pdf and jpeg).

flextable(mtcars) %>% 
  theme_vanilla() %>% 
  save_as_docx(path = "mytable.docx")

A flextable object is a data.frame representation. An API is available to let R users create tables for reporting and control their formatting properties and their layout. The package provides functions that give control over:

  • header, body and footer content
  • text, paragraphs, cells and border formatting of any element
  • displayed values

Installation

install.packages("flextable")

You can get the development version from GitHub:

devtools::install_github("davidgohel/flextable")

Resources

Documentation

The help pages are in a bookdown located at: https://ardata-fr.github.io/flextable-book/

Manuals are available at: https://davidgohel.github.io/flextable/reference/index.html

A gallery of examples is available here: https://ardata.fr/en/flextable-gallery/

Getting help / questions

If you have questions about how to use the package, visit Stackoverflow and use tags flextable and r Stackoverflow link! You can also use https://github.com/davidgohel/flextable/discussions to start a discussion.

Contributing to the package

Code of Conduct

Anyone getting involved in this package agrees to our Code of Conduct.

Bug reports

When you file a bug report, please spend some time making it easy for me to follow and reproduce. The more time you spend on making the bug report coherent, the more time I can dedicate to investigate the bug as opposed to the bug report.

Contributing to the package development

A great way to start is to contribute an example or improve the documentation.

If you want to submit a Pull Request to integrate functions of yours, please provide:

  • the new function(s) with code and roxygen tags (with examples)
  • a new section in the appropriate vignette that describes how to use the new function
  • corresponding tests in directory tests/testthat.

By using rhub (run rhub::check_for_cran()), you will see if everything is ok. When submitted, the PR will be evaluated automatically on travis and appveyor and you will be able to see if something broke.

Copy Link

Version

Install

install.packages('flextable')

Monthly Downloads

77,938

Version

0.8.2

License

GPL-3

Maintainer

David Gohel

Last Published

September 26th, 2022

Functions in flextable (0.8.2)

add_body

Add column values as new lines in body
add_latex_dep

add latex dependencies
add_footer_row

Add footer labels
add_header_lines

Add labels as new rows in the header
add_body_row

Add body labels
add_header_row

Add header labels
align

Set text alignment
add_footer_lines

Add labels as new rows in the footer
add_header

Add column values as new lines in header
add_footer

Add column values as new lines in footer
as_chunk

chunk of text wrapper
as_flextable.htest

tabular summary for htest object
as_flextable

method to convert object to flextable
append_chunks

append chunks to flextable content
as_flextable.grouped_data

tabular summary for grouped_data object
as_flextable.gam

tabular summary for gam object
as_equation

equation chunk
as_flextable.glm

tabular summary for glm object
as_bracket

chunk with values in brackets
as_b

bold chunk
as_image

image chunk wrapper
as_flextable.merMod

tabular summary for mixed model
as_flextable.tabulator

tabulator to flextable
as_i

italic chunk
as_flextable.xtable

get a flextable from a xtable object
as_grouped_data

grouped data transformation
as_highlight

highlight chunk
as_flextable.pam

tabular summary for pam
as_flextable.kmeans

tabular summary for kmeans
as_flextable.lm

tabular summary for lm object
as_paragraph

concatenate chunks in a flextable
as_sub

subscript chunk
body_add_flextable

add flextable into a Word document
as_sup

superscript chunk
as_raster

get a flextable as a raster
as_word_field

'Word' computed field
before

is an element before a match with entries
bold

Set bold font
autofit

Adjusts cell widths and heights
bg

Set background color
border_inner_h

set inner borders
colformat_datetime

format datetime cells
colformat_char

format character cells
colformat_date

format date cells
chunk_dataframe

create a chunk representation suitable for flextable
border_outer

set outer borders
border_inner_v

set vertical inner borders
border_remove

remove borders
border_inner

set vertical & horizontal inner borders
border

cell borders update
colformat_image

format cells as images
colformat_double

format numeric cells
continuous_summary

continuous columns summary
colformat_int

format integer cells
delete_part

delete flextable part
colorize

colorize chunk
colformat_num

format numeric cells
color

Set font color
colformat_lgl

format logical cells
compose

Define displayed values and mixed content
fix_border_issues

fix border issues when cell are merged
fit_to_width

fit a flextable to a maximum width
empty_blanks

make blank columns as transparent
df_printer

data.frame automatic printing as a flextable
dim.flextable

Get widths and heights of flextable
dim_pretty

Calculate pretty dimensions
dim.flextableGrob

Get optimal width and height of a flextable grob
flextable-package

flextable: Functions for Tabular Reporting
flextable

flextable creation
flextable_dim

width and height of a flextable object
flextable_to_rmd

flextable raw code
fmt_2stats

format content for data generated with summarizor()
font

Set font
fp_border_default

Border formatting properties
footers_flextable_at_bkm

add flextable at a bookmark location in document's footer
flextable_html_dependency

htmlDependency for flextable objects
fp_text_default

Text formatting properties
fontsize

Set font size
footnote

add footnotes to flextable
gen_grob

Convert a flextable to a grid grob object
get_flextable_defaults

Get flextable defaults formatting properties
highlight

Text highlight color
gg_chunk

gg plots chunk wrapper
hrule

Set flextable rule for rows heights
htmltools_value

flextable as an HTML object
headers_flextable_at_bkm

add flextable at a bookmark location in document's header
hline

set horizontal borders
hline_top

set top horizontal border
hline_bottom

set bottom horizontal border
height

Set flextable rows height
merge_at

Merge flextable cells into a single one
knit_print.flextable

Render flextable in rmarkdown
linerange

mini linerange chunk wrapper
lollipop

mini lollipop chart chunk wrapper
labelizor

change displayed labels
line_spacing

Set text alignment
merge_h

Merge flextable cells horizontally
italic

Set italic font
hyperlink_text

Chunk of text with hyperlink
merge_h_range

rowwise merge of a range of columns
nrow_part

Number of rows of a part
plot.flextableGrob

plot a flextable grob
ph_with.flextable

add a flextable into a PowerPoint slide
merge_v

Merge flextable cells vertically
ncol_keys

Number of columns
padding

Set paragraph paddings
plot.flextable

plot a flextable
plot_chunk

mini plots chunk wrapper
minibar

mini barplots chunk wrapper
merge_none

Delete flextable merging informations
save_as_pptx

save flextable objects in an PowerPoint file
regulartable

flextable old functions
print.flextable

flextable printing
proc_freq

frequency table as flextable
separate_header

Separate collapsed colnames into multiple rows
prepend_chunks

prepend chunks to flextable content
save_as_html

Save a Flextable in an HTML File
save_as_image

save a flextable as an image
save_as_docx

save flextable objects in an Word file
rotate

rotate cell text
set_flextable_defaults

Modify flextable defaults formatting properties
surround

Set borders for a selection of cells
shift_table

Create a shift table
summarizor

data summary preparation
style

Set flextable style
set_caption

Set Caption
set_header_footer_df

Set flextable's header or footer rows
set_formatter

set column formatter functions
set_header_labels

Change headers labels
set_table_properties

Global table properties
theme_vanilla

Apply vanilla theme
theme_tron

Apply tron theme
theme_booktabs

Apply booktabs theme
theme_vader

Apply Sith Lord Darth Vader theme
theme_tron_legacy

Apply tron legacy theme
theme_box

Apply box theme
theme_alafoli

Apply alafoli theme
tabulator_colnames

column keys of tabulator objects
theme_apa

Apply APA theme
tabulator

Tabulation of aggregations
use_model_printer

set model automatic printing as a flextable
valign

Set vertical alignment
width

Set columns width
theme_zebra

Apply zebra theme
vline_right

set flextable right vertical borders
vline

set vertical borders
use_df_printer

set data.frame automatic printing as a flextable
void

Delete flextable content
vline_left

set flextable left vertical borders