Skip to Content
Menu
v 17.0 Third Party 88
Download for v 17.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 56
Technical Name ns_excel_file_reader
LicenseAGPL-3
Websitehttps://softworks.nibble.co.id/
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 56
Technical Name ns_excel_file_reader
LicenseAGPL-3
Websitehttps://softworks.nibble.co.id/

Excel File Reader

Beta License: AGPL-3 NibbleSoftworks/excel_processor

The ExcelFileReader class is a Python utility for reading data from Excel files. It utilizes the openpyxl library to parse Excel files and provides methods to extract data from the file.

Key Features

1. Get all data from Excel file. ✅

reader = ExcelFileReader(self.excel_file)
data = reader.get_data()

2. Get data by header. ✅

reader = ExcelFileReader(self.excel_file)
data = reader.get_data_by_header('header_name')

3. Get data by cell. ✅

reader = ExcelFileReader(self.excel_file)
data = reader.get_data_by_cell(1, 1)

Table of contents

Installation

Make sure you have openpyxl Python module installed

pip3 install openpyxl

Usage

An example of ExcelFileReader usage is shown below:

from odoo.addons.ns_excel_file_reader.models.excel_file_reader import ExcelFileReader

class SyncProductWizard(models.TransientModel):
    _name = "sync.product.wizard"

    excel_file = fields.Binary('Excel File')

    def sync_products(self):
        excel_file = self.excel_file
        reader = ExcelFileReader(excel_file)
        for row in reader.get_data():
            print(row)
        return True

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Authors

  • Nibble Softworks

Contributors

Maintainers

Current maintainer:

NibbleSoftworks

This module is part of the NibbleSoftworks/excel_processor project on GitHub.

You are welcome to contribute.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.