I'm new to R Markdown. I have a few TSV-tables (I don't get the data out of the system in another format) and I want them to get listed in a pdf-document by using R Markdown.
I'm able to load the data und get the data frames on page, but only the first page is shown. I knew that the first data frame has over 300 rows, but only the firs 50 are on the first page and then the next data frame is shown.
Is there anybody to help, please!
Here is my code so far:
---
output:
pdf_document:
keep_tex: yes
---
```{r global_options, R.options=knitr::opts_chunk$set(warning=FALSE, message=FALSE)}
```
```{r echo=FALSE}
#install.packages("readr")
```
```{r echo=FALSE}
#install.packages("kableExtra")
```
```{r echo=FALSE}
library(readr)
```
```{r echo=FALSE}
library(kableExtra)
```
```{r echo=FALSE}
this_year<-as.integer(format(Sys.Date(),"%Y"))
last_year<-as.integer(format(Sys.Date(),"%Y"))
```
```{r echo=FALSE}
fifty <- read_tsv("PATHtoTSV//.data.tsv")
fifty<-as.data.frame(fifty)
fiftyfive <- read_tsv("PATHtoTSV//.data2.tsv")
fiftyfive<-as.data.frame(fiftyfive)
fiftysix <- read_tsv("PATHtoTSV//.data3.tsv")
fiftysix<-as.data.frame(fiftysix)
```
**INSTITUTION** \hfill {width="205" height="55"}
\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
#
#
#
```{=tex}
\begin{center}\LARGE{DOCUMENT-}\end{center}
\begin{center}\LARGE{TITLE}\end{center}
\begin{center}\LARGE{`r last_year-1`/`r this_year`}\end{center}
```
```{=tex}
\begin{center}\large(Geschäftsjahr {`r last_year-2`/`r this_year-1`})\end{center}
```
\newpage
\listoftables
\newpage
```{r setup, include=FALSE}
knitr::opts_chunk$set(echo = T)
```
\newpage
```{r echo=FALSE, message=TRUE, warning=TRUE, paged.print=TRUE, results='asis'}
knitr::kable(fifty, caption = "Values of Fifty")%>%
kable_styling(full_width = T, position = "center", row_label_position = "c", repeat_header_continued=T)
```
\newpage
```{r results='asis',echo=FALSE}
knitr::kable(fiftyfive, caption = "Values of Fiftyfive")%>%
kable_styling(full_width = T, position = "center", row_label_position = "c", repeat_header_continued=T)
```
\newpage
```{r results='asis',echo=FALSE}
knitr::kable(fiftysix, caption = "Values of Fiftysix")%>%
kable_styling(full_width = T, position = "center", row_label_position = "c", repeat_header_continued=T)
```
###More Tables
The Output is: The first 50 rows of Fifty (out of over 300) The first 15 rows of Fiftyfife (out of 15) and the first 55 rows of Fiftysix (out of over 130).
Best regards and thaks for any help!
I tryed to get help from the internet by searching after: not all rows showing from data frame r markdown not all rows showing from data frame r markdown pdf r markdown table pdf
I get the recommendation to use: results='asis'
I tryed following: Printing data frames in r markdown And get this error: Fehler in kable_latex(x=c(DATA), : unbenutztes Argument (floating.environment="sidewaystable") Error in kable_latex(x=c(DATA), : unused argument (floating.environment="sidewaystable")
At ?knitr::kable() isn't any sidewaystable-argument.