Error R Markdown/Compiling Report

[Lily1]

Hi,

I am quite new to this, so please bear with me

I am trying to compile a report or a Markdown Script (Tried both -> the same error with both). This worked fine for one of my scripts, with the other one I am struggling. R can't find the File. The path is absolutely right, I tried it with different options (copied from Mac Finder Informations directly, copied from R "import file", etc. With the first Markdown script adding "~/" helped, it did not with this one.)
The code is below, it runs fine in R, the file is found etc.

library(readxl)
library(tidyr)
library(ggpubr)
library(rstatix)
library(gridExtra)
library(tidyverse)
library(RColorBrewer)
library(ggplot2)
data <- read_excel("~/Desktop/Promotion/Histologie/AuswertungHistoKomplett.xlsx")
View(AuswertungHistoKomplett)

This is the error that comes up when I try compiling a report/Knit a Markdown document:

processing file: AuswertungHisto_Lilith.spin.Rmd
|................................... | 67% [unnamed-chunk-1]
Quitting from lines 3-130 [unnamed-chunk-1] (AuswertungHisto_Lilith.spin.Rmd)

Error:
! object 'AuswertungHistoKomplett' not found
Backtrace:

1. utils::View(AuswertungHistoKomplett)
2. base::as.data.frame(x)
   Execution halted

I already spent a lot of time on google to find a solution for this but nothing worked yet.

Thanks a lot in advance

[cderv]

@Lily1

data <- read_excel("~/Desktop/Promotion/Histologie/AuswertungHistoKomplett.xlsx")

Is this done from within your Rmd file ? If not,it means the data won't be loaded and available when you are rendering.

[Lily1]

in R Markdown it would need the ```{r}, right? I tried that and had exactly the same error. Or what do you mean exactly?

[cderv]

I mean that AuswertungHistoKomplett needs to exist as an object in your environment. Currently you load the xlsx file in data object - not the same name as you file

[jrkrideau]

@Lily1

View(AuswertungHistoKomplett)

You cannot use view in a .rmd or .qmd document.

[cderv]

I missed that ! This is indeed additional problem, in addition of the name !

Thanks - @Lily1 I believe you can solve your issue now.

[jrkrideau]

Well, I missed the name!

[Lily1]

Thank you both! Excluding "View" solved it! Even ChatGPT missed that, so don't worry!