Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #7377 > unrolled thread

Re: import issue

Started byBarrie Stokes <Barrie.Stokes@newcastle.edu.au>
First post2011-12-21 11:55 +0000
Last post2011-12-21 11:55 +0000
Articles 1 — 1 participant

Back to article view | Back to comp.soft-sys.math.mathematica

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.


Contents

  Re: import issue Barrie Stokes <Barrie.Stokes@newcastle.edu.au> - 2011-12-21 11:55 +0000

#7377 — Re: import issue

FromBarrie Stokes <Barrie.Stokes@newcastle.edu.au>
Date2011-12-21 11:55 +0000
SubjectRe: import issue
Message-ID<jcshf2$27h$1@smc.vnet.net>
Hi Francisco

I happened to be talking to a medical colleague about this yesterday.

Experimentation (with my 2003 version of Excel) quickly shows that the
standard Excel sheet has 256 columns (A to IV) and 2^16 rows, so 2^24
cells. I said in passing that if there were problems Importing a very
full sheet from him, I would just cut the sheet up into sufficiently
smaller subsheets (keeping all the columns, but taking rows 1-10,000,
10,001 to 20,000, or so). Then join up the subsheets in Mathematica
(trivial).

Sometimes you need to get the job done without a general exploration of
the problem - at least that*s how it often is for me.

BTW, some Googling found this at
http://msdn.microsoft.com/en-us/library/ff700514.aspx#Office2007excelPerf_BigGridIncreasedLimitsExcel:

*Starting in Excel 2007, the "Big Grid" increases the maximum number
of rows per worksheet from 65,536 to over 1 million, and the number of
columns from 256 (IV) to 16,384 (XFD).*

Best,

Barrie

>>> On 20/12/2011 at 7:01 pm, in message
<201112200801.DAA27014@smc.vnet.net>,
Francisco Gutierrez <fgutiers2002@yahoo.com> wrote:
> Dear Group:
> I am having trouble importing large files from Excel (or csv) into 
> Mathematica. The program gets stuck or crashes.
> (Mathematica 8.01, a 36 RAM  computer).
> 
> By large I am meaning  50 000 + rows, never too many columns (let's
say 100 
> or less).
> 
> I've tried several forms to overcome the problem, to no avail. But I
am sure 
> there is an easy solution.
> 
> Can somebody out there help?
> 
> Best 
> Francisco

[toc] | [standalone]


Back to top | Article view | comp.soft-sys.math.mathematica


csiph-web