Column titles

61 views
Skip to first unread message

Brian Olney

unread,
Oct 16, 2012, 5:01:59 PM10/16/12
to wizard...@googlegroups.com
I'm trying to import data from an excel file, and each column in excel has headers in it.

When I import, the raw data view grabs random data from that column (not the same in every case) and uses those as the column titles.

The titles have underscores but otherwise nothing strange about them, no empty rows, etc. The headlines are in the first row too.

Not sure what I'm doing wrong here?

Evan Miller

unread,
Oct 16, 2012, 10:30:21 PM10/16/12
to wizard...@googlegroups.com
Hmm, that doesn't sound good. Any chance you can pass along the
spreadsheet so I can take a look?

Evan
--
Evan Miller
http://www.evanmiller.org/

Tristan Lane

unread,
Feb 10, 2013, 6:48:03 PM2/10/13
to wizard...@googlegroups.com
I'm getting this problem as well.

Not sure why this is happening I have to say!

UPDATE:  It's that dratted blooming header option in excel!

Tristan

Evan Miller

unread,
Feb 10, 2013, 7:18:21 PM2/10/13
to wizard...@googlegroups.com
I think what's happening is this: if there are any blank header cells,
Wizard assumes that's not actually the header and moves on to the next
line. I'll get this fixed up to be more intelligent in the next
release. In the meantime if you make sure there aren't any blank
header cells, it should work fine.

Evan
> --
> You received this message because you are subscribed to the Google Groups
> "Wizard User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to wizard-users...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
Reply all
Reply to author
Forward
0 new messages