python – xlwings: how can I read all values when first cell is empty?

I am using xlwings and I have a problem.

my excel data looks like

Like above a image, My data has a empty value of first cell.

when I try to read that cell…I have all NaN values…like below..

Resolution Type

 NaN 

 NaN 

 NaN 

 NaN 

This is my code..

sheet.range('G1').options(pd.DataFrame, index=False, expand='table', headers=True, empty='').value

I want to my original data..

what should I do?

Product of the Month September 2016

Source link

Leave a Comment

Your email address will not be published. Required fields are marked *