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
> ================
- References:
- Importing xlsx spreadsheet data into Mathematica, version 7.0
- From: Alan Beilis <abeilis99@gmail.com>
- Importing xlsx spreadsheet data into Mathematica, version 7.0