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


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

Re: Importing xlsx spreadsheet data into Mathematica,

Started byBob Hanlon <hanlonr357@gmail.com>
First post2012-08-17 07:44 +0000
Last post2012-08-17 07:44 +0000
Articles 1 — 1 participant

Back to article view | Back to comp.soft-sys.math.mathematica

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.


Contents

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

#11384 — Re: Importing xlsx spreadsheet data into Mathematica,

FromBob Hanlon <hanlonr357@gmail.com>
Date2012-08-17 07:44 +0000
SubjectRe: Importing xlsx spreadsheet data into Mathematica,
Message-ID<k0kso2$665$1@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@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
> ================

[toc] | [standalone]


Back to top | Article view | comp.soft-sys.math.mathematica


csiph-web