Instead of coding I have started using android productivity office apps. Microsoft 365 is the best solution.

Hi,

To load an excel file and read its data and to create record inside the odoo database, you can refer this module, which creates chart of account from excel. See this: Import Chart of Accounts from CSV or Excel File

Relevant part of the code, that reads data from excel.

try:
    fp = tempfile.NamedTemporaryFile(delete=False, suffix=".xlsx")
    fp.write(binascii.a2b_base64(self.File_slect))
    fp.seek(0)
    values = {}
    workbook = xlrd.open_workbook(fp.name)
    sheet = workbook.sheet_by_index(0)
except:
    raise Warning(_("Invalid file!"))

for row_no in range(sheet.nrows):
    val = {}
    if row_no <= 0:
        fields = map(lambda row: row.value.encode('utf-8'), sheet.row(row_no))
    else:

        line = list(map(lambda row: isinstance(row.value, bytes) and row.value.encode('utf-8') or str(row.value),
                        sheet.row(row_no)))

        values.update({'code': line[0],
                       'name': line[1],
                       'user': line[2],
                       'tax': line[3],
                       'tag': line[4],
                       'group': line[5],
                       'currency': line[6],
                       'reconcile': line[7],
                       'deprecat': line[8],
                       })

        res = self.create_chart_accounts(values)

Thanks