Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #11384
| 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 |
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
Re: Importing xlsx spreadsheet data into Mathematica, Bob Hanlon <hanlonr357@gmail.com> - 2012-08-17 07:44 +0000
csiph-web