Excel .xlsx conversion for robot use

Development Python
6

Hi,

For those that would help, finally sort out this by using calamine engine:

from python_calamine.pandas import pandas_monkeypatch()

pandas_monkeypatch()
def open_file(file_path,sheet):
    try:
        df = pd.read_excel(file_path, sheet_name=sheet, engine="calamine")

Regards
Charlie

2 Likes