Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #7377
| 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> |
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
Re: import issue Barrie Stokes <Barrie.Stokes@newcastle.edu.au> - 2011-12-21 11:55 +0000
csiph-web