Exporting data from PowerPivot

r excel powerpivot
Moderat picture Moderat · Aug 22, 2014 · Viewed 30.4k times · Source

I have an enormous PowerPivot table (839,726 rows), and it is simply too big to copy-paste into a regular spread sheet. I have tried copying it and then reading it directly into R using the line data = read.table("clipboard", header = T), but neither of these approaches work. I am wondering if there is some add-on or method I can use to export my PowerPivot table as a CSV or .xlsx? Thanks very much

Answer

Riadh picture Riadh · Aug 24, 2014
  • Select all the PowerPivot table
  • Copy the data
  • Past the data in a text file (for example PPtoR.txt)
  • Read the text file in R using tab delimiter: read.table("PPtoR.txt", sep="\t"...)

Related questions

Export data from R to Excel

I am writing codes to export database from R into Excel, I have been trying others codes including: write.table(ALBERTA1, "D:/ALBERTA1.txt", sep="\t") write.csv(ALBERTA1,":\ALBERTA1.csv") your_filename_in_R = read.csv("ALBERTA1.csv") your_…

Read More
Read an Excel file directly from a R script

How can I read an Excel file directly into R? Or should I first export the data to a text- or CSV file and import that file into R?

Read More
Easy way to export multiple data.frame to multiple Excel worksheets

I am surprised to find that there is no easy way to export multiple data.frame to multiple worksheets of an Excel file? I tried xlsx package, seems it can only write to one sheet (override old sheet); I also …

Read More