¶ (c) Technocore - All Rights Reserved.
NOTICE: All information contained herein is, and remains
the property of TechnoCore.
The intellectual and technical concepts contained
herein are proprietary to TechnoCore and dissemination of this information or reproduction of this material
is strictly forbidden unless prior written permission is obtained
from TechnoCore.
¶ ObjImportApi for XLS Files
The ObjImportApi class in ObjDataImportXls.py is designed to import data from legacy Excel (.xls) files. It uses the xlrd library to read and parse the structure and content of XLS spreadsheets.
¶ Key Features
- Sheet Selection: Allows specifying which sheet to import, either by name (
_Sheetname) or by index (_SheetNumber). - Data Type Handling: Automatically converts Excel data types, such as numbers and dates, into string representations suitable for further processing.
- Row-by-Row Reading: Provides a simple way to iterate through the rows of the selected sheet.
¶ Methods
¶ __init__(self, DB=0)
Initializes the ObjImportApi object.
¶ OpenFile(self, Filename)
Opens the specified XLS file. It identifies the target sheet based on the _Sheetname or _SheetNumber attribute and prepares it for reading.
¶ ColumnList(self)
Retrieves the column names from the first row of the selected sheet.
¶ NextRow(self)
Reads the next row from the sheet. It processes each cell, converting numeric and date values to strings. If there are no more rows, it returns None.
¶ Usage Example
# Create an instance of the importer
xls_importer = ObjImportApi()
# Specify the sheet to import
xls_importer._Sheetname = "Sheet1"
# Open an XLS file
xls_importer.OpenFile("data.xls")
# Get the column list
columns = xls_importer.ColumnList()
print("Columns:", columns)
# Iterate over the rows
while True:
row = xls_importer.NextRow()
if row is None:
break
print("Row data:", row)
¶ Cyclomatic complexity
A quantitative measure of the number of linearly independent
paths through a program's source code.
M 57:4 ObjImportApi.NextRow - B
C 31:0 ObjImportApi - A
M 41:4 ObjImportApi.OpenFile - A
M 32:4 ObjImportApi.__init__ - A
M 35:4 ObjImportApi.Version - A
M 53:4 ObjImportApi.ColumnList - A
¶ Halstead metrics
Halstead’s goal was to identify measurable properties of software, and the
relations between them. These numbers are statically computed from the source code
η1 = the number of distinct operators
η2 = the number of distinct operands
N1 = the total number of operators
N2 = the total number of operands
h1: 4
h2: 16
N1: 8
N2: 16
vocabulary: 20
length: 24
calculated_length: 72.0
volume: 103.72627427729671
difficulty: 2.0
effort: 207.45254855459342
time: 11.525141586366301
bugs: 0.0345754247590989
¶ Maintainability Index
Maintainability Index is a software metric which measures how maintainable
factory.import/ObjDataImportXls.py - A
Updated : 2025-11-26