CODEWITHSUNDEEP
rexcelr-markdownexport-to-pdfreadxl
Gabriela Arciszewska
Gabriela Arciszewska

Reputation: 9

Convert/Save Excel File to PDF in R

I have several files that needs converting to PDF format. I wasn't able to find the solution to my problem anywhere, even with help of ChatGPT.

There was an idea of using RDCOMClient package, however this doesn't seem to work with the newest version of R (R version 4.4.1)

Do you know how to sort this out? I have an object (list) with 50 Excel files (modified and ready to become PDFs).

Thank you in advance.

# Construct the file path to save the workbook
  file_path <- file.path(reports_folder, paste0(student_name, " Attendance Report ", ".xlsx"))

# Save the workbook to an Excel file in the specified folder
  saveWorkbook(wb, file = file_path, overwrite = TRUE)

}

This is the last 2 lines of my code to save my work to Excel.

Upvotes: 0

Views: 72

Answers (0)

Related Questions