You can read it in as 'raw'
===========input <- file('your.xlsx', open = 'rb') # open as
binary
excel_file <- readBin(input, raw(), 1e8) # make sure you read in all the
file
close(input)
output <- file('your_new.xlsx', 'wb')
writeBin(excel_file, output)
close(output)
==================
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
On Fri, May 29, 2020 at 12:12 PM Sebastien Bihorel via R-help
<r-help at r-project.org> wrote:>
> Hi,
>
> Let's say I can extract the content of an Excel .xlsx file stored in a
database and store it as raw content in an R object. What would be the proper
way to "create" a .xlsx file and "transfer" the content of
this obj into it? I took the example of an Excel file, but my question would
extend to any kind of binary file.
>
> Thank you in advance for your input
>
> Sebastien
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.