31

I would like to produce a table that spans over multiple pages using kable(). I know this is possible using xtable() with the "longtable" option, but I need kable() for other features.

Any ideas?

```{r cars, echo=TRUE, results='asis', warning=FALSE, message=FALSE}
    library(knitr)
    library(kableExtra)

# OUTPUT 1, fits on one page
output = rbind(mtcars[, 1:5])

kable(output, booktabs = T, format="latex", caption = "Small Output")


# OUTPUT 2, will not fit on one page 
output = rbind(mtcars[, 1:5], mtcars[, 1:5])

kable(output, booktabs = T, format="latex", caption = "Large Output")

```

Update: I am dumb! "longtable=TRUE," is an option. The problem is that this changes the order of my output and kinda messes things up.

Phil
  • 7,287
  • 3
  • 36
  • 66
kpr62
  • 522
  • 1
  • 4
  • 11

2 Answers2

41

You can try to use the kableExtra package. If you specify hold_position in kable_styling, you should be able to ping the table to the place you want.

Also, in the current dev version, I introduced a new feature called repeat_header for longtable to repeat the header row on every page. You can check it out. 

kable(output, "latex", booktabs = TRUE, longtable = TRUE, caption = "Test") %>%
  kable_styling(latex_options = c("hold_position", "repeat_header"))
Hao
  • 7,476
  • 1
  • 38
  • 59
0

I would use a combination between the kable_styling: full_width and column_spec. Hope it helps.

 kable(myFields, "latex", longtable = F, booktabs = T) %>%
 kable_styling(full_width = T) %>%  
 column_spec(1, width = "5em" ) %>% 
 column_spec(2, width = "10em" ) %>%  
 column_spec(3, width = "15em")
Edeilson da Silva
  • 39
  • 3