xls.parse: fails to skip lines

[timmie]

Hello,
my excel file is like:

• metadata (10 rows)
• header (1 row)
• units (1 row)
• data (250 rows)

Now, I am trying to read it like:

df = xlsall.parse(sheetname='mydata', skiprows=11, header=10)

But it would not assign the information in row 11 as column labels but rather use the units in row 12 (counting from 1).

What could be the cause?

[timmie]

What could make this fail?
it looks like the parser just take the row which is

skiprows -1

[timmie]

Confirmed.
Sample code in:
https://github.com/timmie/example_code_data

[jtratner]

If you've figured it out, do you want to try applying it to the pandas
codebase?

On Mon, Jul 29, 2013 at 5:41 AM, timmie notifications@github.com wrote:

Confirmed.
Sample code in:
https://github.com/timmie/example_code_data

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/4340#issuecomment-21709120
.

[timmie]

@jtratner
Sorry, I was not clear. I could only confirm that it occurs. But would need to find out what causes the script to ignoe the header indication.

I found a solution for #4332. Would please check my example code?
I am not sure if such a workaround is accepted.

Else, I'll be happy create a PR

[jtratner]

Definitely. I misunderstood what you meant before.

[jreback]

closing in favor or #4903

[timmie]

note: will most probably find time next week to finalise these issues with Excel.