Adding metadata to xlsx file

296 views
Skip to first unread message

csw...@gmail.com

unread,
Mar 12, 2015, 8:11:25 PM3/12/15
to r-packa...@googlegroups.com


Is there any package in R that can read/write metadata from an XLSX file?  I'm talking about properties like 'creator' or 'date' that one can set on the file itself from inside Excel.  
I would like to annotate my excel files with the name of the script that produced them and as much helpful information I can provide for reproducing the data.

Using the xlsx package I have been resorting to adding a comment to a cell, but that is visible in the data if you open it in excel.  

Is there any way to manipulate metadata in excel files from R?


brent.br...@gmail.com

unread,
Apr 12, 2015, 8:18:20 PM4/12/15
to r-packa...@googlegroups.com, csw...@gmail.com
I found this resource, which refers to the Apache POI, so it may require some more in-depth development, but may be a starting point for research on the question: http://thinktibits.blogspot.com/2014/07/read-write-metadata-excel-poi-example.html
Reply all
Reply to author
Forward
0 new messages