Showing results for 
Search instead for 
Did you mean: 
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.


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?

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". 




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

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)?




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



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


I am unable to do so. 

Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Kudoed Authors