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


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

Re: Importing xlsx spreadsheet data into Mathematica,

From Bob Hanlon <hanlonr357@gmail.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: Importing xlsx spreadsheet data into Mathematica,
Date 2012-08-17 07:44 +0000
Message-ID <k0kso2$665$1@smc.vnet.net> (permalink)
References <20120816055857.49B55684D@smc.vnet.net>
Organization Time-Warner Telecom

Show all headers | View raw


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@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@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@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@gmail.com
> ================

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


Thread

Re: Importing xlsx spreadsheet data into Mathematica, Bob Hanlon <hanlonr357@gmail.com> - 2012-08-17 07:44 +0000

csiph-web