Exporting with R to excel table

[Anonymous]

I have a report that all it does is export it's data to excel via power automate using some R code.

"write_xlsx(dataset,"file_path.xlsx")"

However, I need to manipulate it further and it needs to be in a tabular format to do so. Yet, when I try "write.table" I get the error that my connection to OneDrive is not open. So I can export an Excel sheet with the data, but not the same data as a Table.

Any ideas?

[v-jingzhang]

Hi @Anonymous 

Perhaps "write.table" doesn't support XLSX files. I didn't find examples that use "write.table" to export data to XLSX files. They export data to TXT, CSV or other formats. For XLSXs, they use "write_xlsx" or "write.xlsx". Maybe you can try "write.xlsx". 

Reference:

https://r-coder.com/export-data-r/ 

https://www.dataanalytics.org.uk/the-3-rs-writing/

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

Thank you for replying. I've tried write_xlsx. The issue is writting it as a table. I can export it as a spreadsheet no problem. 

[v-jingzhang]

Hi @Anonymous 

I'm a little confused. When you want to write it as a table, which type of file are you writing it to? Can you show the current "write.table" code (removing sensitive info)?

Regards,

Jing

[Anonymous]

I can't write it as a table. I can export the data to excel as a .xlsx file, but it's not in table format.  But when I try

library("writexl")

 write.table(dataset,"C:\\file location.xlsx")

I am unable to do so.