How to open xltx and xltx files using pandas in python?

Question

Openpyxl would do the job but I'm just wondering if there is a way to do it in pandas or maybe converting a Openpyxl workbook into pandas dataframe? Thank you guys.

edit: I found the doc for Openpyxl and tried to do the following …

ws = wb.worksheets[0]
data = ws.values
col = next(data)[1:]    #error occurred here

…

The issue for this script is that xltx file consists of several merged cells. Error message: 'MergedCell' object has no attribute 'value'

score 0 · Answer 1 · answered Feb 26 '19 at 23:40

0

There's a method for that.

import pandas as pd
df = pd.read_excel('filename.xltx')

df will be your dataframe. Read all the options here.

answered Feb 26 '19 at 23:40

run-out

3,114
1
9
25

That's my first try,and for some reason it didn't work for me. OSError no. 22 invalid argument. – user11122184 Feb 27 '19 at 01:29
Does this help? https://stackoverflow.com/questions/25584124/oserror-errno-22-invalid-argument-when-use-open-in-python – run-out Feb 27 '19 at 02:24
Most welcome, if the answer is acceptable could you please accept it? Thanks. – run-out Feb 27 '19 at 04:57

How to open xltx and xltx files using pandas in python?

1 Answers1