I have several Office files (Word, PowerPoint, Excel) and I need to get the document properties (for instance, title, subject, creator, keywords, lastModifiedBy, date created, etc.) from R.
I have used the package officer, which is giving me this information for Word and PowerPoint files, but not for Excel files. I use:
library(officer)
PowerPoint file
ppt1<-read_pptx("Slides.pptx")
doc_properties(ppt1)
Word file
doc1<-read_docx("Document.docx")
doc_properties(doc1)
But, as I said, officer does not give document properties for Excel files.
Excel file
exc1<-read_xlsx("Excel_file.xlsx")
doc_properties(exc1)
Error in doc_properties(exc1) : x should be a rpptx or rdocx object.
Is there any other R package to get document properties for Excel files?
Are there any other R packages to get document properties for Word, PowerPoint and Excel files, in a similar way to the officer package?
Thank you.