Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.