Easily Create and Style Tables for LaTeX, HTML and Other Formats

Like 'xtable', creates styled tables. Export to HTML, LaTeX, 'Word', 'Excel', 'PowerPoint' and RTF. Simple, modern interface to manipulate borders, size, position, captions, colours, text styles and number formatting. Table cells can span multiple rows and/or columns. Includes a 'huxreg' function for creation of regression tables, and 'quick_*' one-liners to print data to a new document.


h

u

x

t

a

b

l

e


CRAN StatusBadge CRAN Downloads PerMonth Travis-CI BuildStatus AppVeyor BuildStatus CoverageStatus

Huxtable is an R package to create styled tables in multiple output formats, with a friendly, modern interface. Features include:

  • Control over text styling, number format, background colour, borders, padding and alignment.
  • Table cells can span multiple rows and/or columns.
  • Table manipulation via standard R subsetting, or using dplyr.
  • Automatic formatting for knitr/rmarkdown documents.
  • huxreg() function for quick creation of regression tables.
  • Output to HTML, LaTeX, RTF, and Microsoft Word/Excel/Powerpoint, using the officer and openxlsx packages.
  • Quick one-liners to print data frames into a new PDF, HTML page, RTF or Microsoft document.
  • Formatted table display in the R console, including borders, colour, and text styles.

To install from CRAN:

install.packages('huxtable')

To install the latest version from github:

install.packages('remotes')
remotes::install_github('hughjonesd/huxtable')

Learning more

Check out the website, read the documentation or read the vignette in HTML or PDF.

News

Note that huxtable attempts to follow semantic versioning (https://semver.org). Therefore, major version increments reflect backwards-incompatible API changes, not necessarily big changes.

huxtable 4.4.0

  • Huxtables can now be printed directly in Word documents and Powerpoint presentations, thanks to the flextable package and recent versions of Pandoc. (Powerpoint printing requires Pandoc >= 2.4.0.)
  • New "wrapleft" and "wrapright" options to position() allow text wrapping around tables.
  • New set_outer_border_colors() and set_outer_border_styles() functions, like set_outer_borders().
  • Huxtable no longer requires the broom package, instead using the generics package. If you use huxreg(), you will still need e.g. broom or broom.mixed to provide tidy() and glance() methods for specific models.
  • Bugfix: tidy.tidy_override() and glance.tidy_override() should work even if underlying object has no tidy() or glance() method.
  • Bugfix: huxtables had option clash when echo = TRUE in Rmd pdf_document format.
  • Bugfix: caption() and height() weren't playing nicely.
  • Bugfix: mutate(..., copy_cell_props = FALSE) was adding a column named copy_cell_props.
  • Bugfix: check_latex_dependencies and install_latex_dependencies gave misleading errors.
  • Enhancement: when stars is NULL in huxreg, don't print a note by default.
  • Enhancement: use tinytex when available, allowing autoinstallation of latex packages.

huxtable 4.3.0

  • More work on TeX. Tables should now compile when raw_attributes is not set.
  • New map_xxx functions to set properties variably by cell values.
  • Functions for mapping properties variably: by_rows, by_values, by_ranges, by_quantiles etc.
  • Correct bookdown labels are now automatically created.
  • New grey, blue, green and orange themes.
  • New "themes" vignette.
  • New tidy_override function to override p values etc. in huxreg.
  • New set_contents function to change huxtable contents within dplyr pipes.
  • Enhancement: left- and right-aligned captions are now set above the table in LaTeX, using the "threeparttable" package. You will need to install this using e.g. install_latex_dependencies() or tlmgr if it is not already on your system.
  • Enhancement: in huxtable() and friends, add_rownames = "Colname" now sets the name for the new column.
  • Improvements to the vignettes and help files.
  • Bugfix: to_md could hang with bold/italic cells.

Deprecated

  • The 3 argument form of set_xxx functions is deprecated, as is the where function. Use map_xxx instead.
  • Argument byrow is soft-deprecated. Use by_cols() instead.

huxtable 4.2.1

  • Bugfix: wrap=TRUE caused squeezed text in RTF.

Important

  • TeX code was getting escaped by pandoc. To avoid this, if possible, huxtable now adds fenced code blocks round latex tables (see https://pandoc.org/MANUAL.html#extension-raw_attribute). You must add

    md_extensions: +raw_attribute

    to your YAML header for this to work, and you will need a recent (> 2.0.0) version of Pandoc.

huxtable 4.2.0

  • More speedups: LaTeX 2-3x faster, as_Workbook 2-3x faster.
  • Simplify LaTeX output using our own LaTeX commands.
  • RTF support: new print_rtf, to_rtf and quick_rtf functions.
  • New border_style properties to set "solid", "double", "dotted" or "dashed" borders. (At present, LaTeX only allows "solid" or "double".)
  • New merge_cells function, an alternative interface to colspan and rowspan.
  • New quick_pptx function to print data frames and huxtables into Powerpoint.
  • New install_latex_dependencies and check_latex_dependencies utility functions.
  • add_rows and add_columns now accept data frames as arguments.
  • New theme_mondrian theme :-D
  • Enhancement: print_md now handles bold and italic cells.
  • Enhancement: quick_pdf has new width and height options to change paper size.
  • Use CSS writing-mode where possible for text rotation. Note that this may break on non-LTR languages. If this affects you, please file an issue.
  • Bugfix: LaTeX didn't compile when height and caption were both set.
  • Bugfix: print_screen and print_md would hang with a wide huxtable.
  • Tweaks to documentation.

huxtable 4.1.0

  • dplyr, knitr, rmarkdown and some other packages have moved to "Suggests:", lowering the dependency load considerably. All the functionality is still present. huxtable gives an informative warning if a needed package is not installed.
  • Code rewrites for better performance and maintainability: HTML is up to 10x faster, LaTeX is up to 4x faster.
  • Documentation improvements.
  • New tribble_hux function wrapping tibble::tribble() for readable data input.
  • New add_rows and add_columns functions to insert one or more rows into the middle of a huxtable.
  • New option "huxtable.knitr_output_format" to override the default output format in knitr documents.
  • Numeric row heights and column widths are rescaled to 1 when huxtables are cbinded/rbinded.
  • LaTeX: at points where borders cross, priority is given to the horizontal border color.
  • Bugfix: property accessors had the wrong environment. Thanks to Iñaki Úcar.
  • Bugfix: row heights and column widths weren't being copied with cbind/rbind.
  • Bugfixes for 0-row or 0-column huxtables:
    • Output works, usually with a warning.
    • cbind and rbind work.
  • Bugfix: HTML cols were printed with 'width: NA'.
  • Bugfix: width, col_width etc. can be reset to a number after setting them to a string.
    • The (undocumented) ability to mix numeric and non-numeric values for padding and/border widths has been removed. If you want a number, set a number and not a string.
  • Bugfix: HTML tables with position "right" weren't right-aligned.
  • Nicer error messages when rbinding objects with different numbers of rows.
  • Vignette improvements.
  • is_a_number is deprecated.
  • ... and a cool new randomized hux_logo() ;-)

huxtable 4.0.1

  • Improved formatting in Excel output.
  • New format method which returns the result of to_html, to_latex etc. as appropriate.
  • Bugfix: to_html printing e.g. "left-border: NA;" in cell CSS.
  • Bugfix: set_all_* not working when huxtable is not attached.
  • Bugfix: as_Workbook failing with non-numeric width.
  • Bugfix: hux_logo was using multiple fonts, fails with Excel output.
  • Bugfix: as_flextable borders not working in cells with colspan > 1.
  • Documentation bugfixes.
  • Compatibility with broom 5.0.0 - thanks @alexpghayes

huxtable 4.0.0

  • New theme_plain theme.
  • The default value for add_colnames is going to become TRUE. At present it remains FALSE. Set options("huxtable.add_colnames") to TRUE or FALSE to set the default and avoid warnings in future.
  • quick_* functions now automatically open documents if used interactively. Use open = FALSE to avoid.
  • Tweak top and bottom margins for HTML tables.
  • pad_decimal is deprecated in favour of align(ht) <- ".".
  • huxreg continues with a warning if statistics are unavailable for some models.

Breaking changes

  • huxtable now provides knit_print.data.frame methods. This means that bare data frames will be pretty-printed via huxtable if the package is loaded.
    • Set options("huxtable.knit_print_df") to FALSE if you don't want this.
    • By default data frames are printed using the theme_plain theme. Set options("huxtable.knit_print_df_theme") to a different one-argument function if you want to use a different theme.
  • The new autoformat argument lets huxtable() and as_huxtable() automatically choose alignment and number format based on column type. Set options("huxtable.autoformat") to FALSE to turn off this feature by default.
  • The default value of number_format has changed from "%5.3g" to "%.3g", which no longer space-pads numbers.
  • as_flextable now does not print column names in the header. This matches the standard huxtable behaviour whereby headers are "just another row/column". To get the old behaviour, use colnames_to_header = TRUE.

Bugfixes

  • Bugfix: Date and datetime columns were converted to numbers by add_colnames.
  • LaTeX bugfix: background colors were printing an extra space.
  • huxreg was never using built-in confidence intervals.
  • Screen bugfixes:
    • set max_width to screen width (thanks @jacob-long)
    • misaligned decimal points
  • Various bugfixes for number_format, huxreg, as_hux.table, as_flextable.

huxtable 3.0.0

  • Output to Excel workbooks using the openxlsx package.
  • New quick_xlsx function.
  • dplyr select helpers now work inside set_* column specifications: e.g. set_bold(ht, 1:3, matches("ab"), TRUE)
  • Column names can now be used for the after argument to insert_column.
  • quick_* functions: when the file argument is not explicitly specified, confirm overwrites manually, or fail if called non-interactively.
  • Add pointless quote marks in Description and Title... I don't make the rules.
  • Don't apply number_format to negative exponents (e.g. 1.12e-3).
  • New tidy_args argument to huxreg allows per-model customization of the call to tidy.

Breaking changes

  • quick_xxx functions without an explicit file argument throw an error if called non-interactively, and prompt before overwriting files if called interactively.

huxtable 2.0.2

  • Don't apply number_format to exponents in scientific notation.
  • Turn off some tests on CRAN, as they fail there but not elsewhere.

huxtable 2.0.1

  • Fix quick_pdf error when moving output across filesystems.

huxtable 2.0.0

  • New quick_html, quick_pdf and quick_docx functions to print table-like objects to a new document.
  • to_screen only shows colnames if there are any non-zero-length column names.

Breaking changes

  • number_format now applies to any number-like substrings in cells. This means you can include e.g. significance stars in a cell and still use number_format to format the content.
  • If number_format is NA, numbers are unchanged.
  • Default value of number_format has changed from "%5.2f" to "%5.3g", which plays nicer with integers but may surprise you by using scientific format for large numbers.

huxtable 1.2.0

  • New outer_borders argument for huxreg. This changes default behaviour slightly.
  • New border argument for add_footnote to choose width of footnote's top border.
  • Added guard assertions to many exported functions.
  • Bugfix: captions and colnames are wrapped in to_screen to respect max_width.

huxtable 1.1.0

  • No more ugly autocreated column names.
  • Allow huxtable to have invalid or empty column names in general.
  • LaTeX should now be much faster on large tables.
  • set_outer_borders now accepts the same row/column arguments as other set_ functions.
  • Better handling in LaTeX of horizontal borders which don't cross the entire table. (But not varying positive border widths....)
  • Bugfix: flextable didn't like huxreg's syntactically invalid column names.
  • Accept, but silently change, English spelling of 'centre' in align, position and caption_pos.

huxtable 1.0.0

  • LaTeX implements different thicknesses for vertical and horizontal borders (but only one horizontal thickness per row).
  • LaTeX border colors now collapse nicely: set colors override unset ones.
  • React gracefully to lack of p values in huxreg.
  • New set_outer_borders function to set borders round a rectangle of cells.
  • to_screen and to_md now respect wrap and col_widths properties.
  • Screen and markdown wrap respect word boundaries.
  • to_screen and to_md gain a min_width argument; to_md gains a logical header argument; to_screen gains a compact argument replacing blank = NULL.
  • On screen colour and bold support, if the crayon package is installed. New huxtable.color_screen option.
  • Move from ReporteRs to officer and flextable. No more RJava horror.
  • New error_format argument to huxreg for flexible control over uncertainty estimates.
  • Infrastructure improvements: slightly less ugly code in screen.R and LaTeX.R.

Breaking changes

  • Removed options collapse, borders, blank and colname_color from to_screen/print_screen.
  • as_FlexTable is deprecated and calls as_flextable with a warning. header_rows and footer_rows arguments are ignored. If you need this feature, tell me.
  • HTML border sizes are now set in points, not pixels.
  • In huxreg:
    • ci_level is NULL by default. Set it to a number to calculate confidence intervals.
    • error_style is deprecated with a warning in favour of error_format.
    • Use {stars} not %stars% to display significance levels in the note argument.
    • borders becomes a number specifying border width. Set to 0 for no borders.

huxtable 0.3.1

  • New convenience functions insert_row and insert_column.
  • latex_float property allows you to change positioning in LaTeX.
  • (Semantic versioning fail: this should have been 0.4.0.)

huxtable 0.3.0

  • New borders argument for huxreg, gives borders in sensible places.
  • Allow more flexible caption positioning with caption_pos.
  • New set_default_properties function to set default properties for new huxtables.
  • Fix compatibility with dplyr 0.6.0.

huxtable 0.2.2

  • Fix a bug that could lead to wrong significance stars in huxreg.

huxtable 0.2.1

  • Compatibility with dplyr 0.6.0.
  • Use ~ for decimal padding in LaTeX.

huxtable 0.2.0

  • New huxreg function to convert a list of models to a huxtable.
  • New set_* interface allowing column ranges, expressions a la subset, and filling in values by row.
  • Replacement methods $<-, [<- and [[<- now work better.
  • New function set_cell_properties to set multiple properties on cells.
  • evens, odds, everywhere, every(n, from), final(n), where(cond): convenience functions to select rows, columns and cells.
  • Export to Word/Powerpoint via ReporteRs.
  • Huxtable now supports dplyr verbs like filter and select.
  • Exported function guess_knitr_output_format.
  • Ability to set border colors.
  • Prevent overlapping row/colspans.
  • Expanded introduction and new vignette for huxreg.
  • Numerous bugs have been fixed and replaced with new, more advanced bugs.

Breaking changes

  • theme_minimal has been renamed theme_basic to avoid a name clash with ggplot2.

huxtable 0.1.0

  • Added a NEWS.md file to track changes to the package.
  • First CRAN release.

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.