How to put entire datatable onto html report? (or at least left align)

Question

I have several wide tables that should fit onto an html report, but I don't know how to do it.

Consider the following example. It's rather silly I know, because I could chop the digits off, but many of my tables have string columns that are about this long and cannot be chopped:

---
title: "DT Fitting"
output: html_document
---

```{r testTable, fig.align = 'left', fig.width = 6in}
DT::datatable(datasets::euro.cross)
```

It renders an html report that looks like this:

Notice that I've tried using fig.align and fig.width to align or shrink the table, but they don't seem to work. Does anyone know to put this single table onto the page so as to be completely visible?

How about this SO answer: http://stackoverflow.com/a/35752537/5645311 — Sixiang.Hu, Jan 21 '17 at 21:44
That centers the objects in the table, but not the table itself. — jks612, Jan 22 '17 at 02:49

score 0 · Answer 1 · edited May 23 '17 at 12:16

It looks like a previous SO post captures this.

This allows you to set the width via options(width = some number). This doesn't seem to be the ideal solution if you have multiple wide tables.

Another option is to consider, fixing the columns when setting up the datatables and enabling scrolling. Check out Section 5. They allow you to fix the first and last column, and scroll the columns in between.

Based on the Datatables link:

```{r}
      DT::datatable(datasets::euro.cross,
          extensions = 'FixedColumns',
             options = list(
                      dom = 't',
                      scrollX = TRUE,
                      fixedColumns = list(leftColumns = 2, rightColumns = 1))
                    )
```

How to put entire datatable onto html report? (or at least left align)

1 Answers1