Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2012

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Importing xlsx spreadsheet data into Mathematica,

  • To: mathgroup at smc.vnet.net
  • Subject: [mg127728] Re: Importing xlsx spreadsheet data into Mathematica,
  • From: Bob Hanlon <hanlonr357 at gmail.com>
  • Date: Fri, 17 Aug 2012 03:44:04 -0400 (EDT)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com
  • Delivered-to: l-mathgroup@wolfram.com
  • Delivered-to: mathgroup-newout@smc.vnet.net
  • Delivered-to: mathgroup-newsend@smc.vnet.net
  • References: <20120816055857.49B55684D@smc.vnet.net>

Write a short macro in Excel to create a workbook with three sheets
(Sheet1 contains columns 1-250 of original workbook, Sheet2 contains
columns 251-500, Sheet3 contains columns 501-750) and have macro save
as an .xls workbook.  Then try

data = Join @@@ (Import["filePathName.xls",
     "Data"] // Transpose);


Bob Hanlon


On Thu, Aug 16, 2012 at 11:50 AM, Alan Beilis, Ph.D.
<abeilis99 at gmail.com> wrote:
> There is a restriction of 255 columns for xls files. The particular
> xlsx files have 750 columns that xls cannot accomodate. Mathematica,
> Version 7 recognizes xls files, not xlsx files. That's why I need a
> "workaround", if it exits.
>
> Thanks,
> Alan
>
> On 8/16/12, Bob Hanlon <hanlonr357 at gmail.com> wrote:
>> Is there any reason not to just Save As=85 the .xlsx as an .xls file and
>> then import the data from the .xls into Mathematica?
>>
>>
>> Bob Hanlon
>>
>>
>> On Thu, Aug 16, 2012 at 1:58 AM, Alan Beilis <abeilis99 at gmail.com> wrote:
>>> Has anyone had any luck doing this? If so, would you mind providing
>>> the Mathematica syntax to do this? Thanks for any and all help!
>>>
>>
>
>
> --
> Best Regards,
> Alan
>
> Alan Beilis, Ph.D.
> 732.718.8730
> abeilis99 at gmail.com
> ================



  • Prev by Date: Re: compact notation for NonCommutativeMultiply that supports cut and paste
  • Next by Date: Using a huge list of random numbers from random.org
  • Previous by thread: Importing xlsx spreadsheet data into Mathematica, version 7.0
  • Next by thread: Re: Importing xlsx spreadsheet data into Mathematica,