I am using xlwings and I have a problem.
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?