cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Exporting with R to excel table

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?

4 REPLIES 4
v-jingzhang
Community Support
Community Support

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
Not applicable

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. 

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
Not applicable

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. 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors