Re: [R] Read in from multiple Excel wksheets

On Tue, Jun 14, 2011 at 12:06 PM, dM/ wrote: > I’ve got an Excel workbook with about 30 worksheets.  Each worksheet > has 1 rows of data over 30 columns. > > I’d like to read the data from each worksheet into a dataframe or > matrix in R for processing.  Normally, I use read.csv when interacti

Re: [R] Read in from multiple Excel wksheets

dM/ gmail.com> writes: > > I’ve got an Excel workbook with about 30 worksheets. Each worksheet > has 1 rows of data over 30 columns. > > I’d like to read the data from each worksheet into a dataframe or > matrix in R for processing. Normally, I use read.csv when interacting > with Excel b

Re: [R] Read in from multiple Excel wksheets

Java uses "heap space" when creating new objects. My guess is that since the default size is 128 Mb iirc, you are reading in an object larger than this. I don't know the guts of the xlsx package or if there is a way to increase the heap, but you may get by if you can divide up your data import. HT

[R] Read in from multiple Excel wksheets

I’ve got an Excel workbook with about 30 worksheets. Each worksheet has 1 rows of data over 30 columns. I’d like to read the data from each worksheet into a dataframe or matrix in R for processing. Normally, I use read.csv when interacting with Excel but I’d rather manipulate a multisheet wo