So I tried it this morning and it works for several sheets, but not for
one.
When I run this:
f = openxl("Data.XLSX")
test = readxl(DataFrame, f, "Data!A1:C1885")
I get the following error:
NAException("Cannot convert DataArray with NA's to desired type")
while loading In[3], in expression starting on line 2
in convert at C:\.julia\v0.3\DataArrays\src\dataarray.jl:561
in readxl_internal at C:\.julia\v0.3\ExcelReaders\src\ExcelReaders.jl:214
in readxl at C:\.julia\v0.3\ExcelReaders\src\ExcelReaders.jl:204
Any suggestions?
Thanks.
Brandon
On Tuesday, May 19, 2015 at 7:28:59 PM UTC-4, David Anthoff wrote:
>
> Have you tried
>
>
>
> df = readxl(DataFrame, "Filename.xlsx", "Sheet1!A1:C4")
>
>
>
> That would return a DataFrame. Note that there is no readxlsheet that
> reads into a DataFrame (yet).
>
>
>
> The eventual API design I had in mind is that one can pass as a first
> argument the return type one desires. Right now the only option is
> DataFrame, otherwise it defaults to a DataArray.
>
>
>
> Cheers,
>
> David
>
>
>
> *From:* julia...@googlegroups.com <javascript:> [mailto:
> julia...@googlegroups.com <javascript:>] *On Behalf Of *Brandon Booth
> *Sent:* Tuesday, May 19, 2015 7:22 PM
> *To:* julia...@googlegroups.com <javascript:>
> *Subject:* [julia-users] Convert DataArray to DataFrame
>
>
>
> I feel like this should be simple to do, but I can't seem to do it. I'm
> using ExcelReaders and it imports as a DataArray whereas I'd like to have
> the data as a DataFrame. I didn't see anything in the approximately 375
> pages of methods for convert.
>
> Thanks.
>
> Brandon
>
