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


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

Re: import issue

From Barrie Stokes <Barrie.Stokes@newcastle.edu.au>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: import issue
Date 2011-12-21 11:55 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <jcshf2$27h$1@smc.vnet.net> (permalink)
References <201112200801.DAA27014@smc.vnet.net>

Show all headers | View raw


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

Back to comp.soft-sys.math.mathematica | Previous | Next | Find similar | Unroll thread


Thread

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

csiph-web