import numpy as np import aspose.cells from aspose.cells import Workbook, Worksheet, Range # Open the Excel workbook book = Workbook("sample_data.xlsx") # Get the first worksheet sheet1 = book.worksheets.get(0) # range to ndarray cells = sheet1.cells range_obj = cells.create_range("B1", "C3") range_list =[] for row_index in range(range_obj.first_row , range_obj.first_row + range_obj.row_count ): row =[] for column_index in range(range_obj.first_column, range_obj.first_column + range_obj.column_count): curr_cell = cells.check_cell(row_index, column_index) if curr_cell: row.append(curr_cell.value) else: row.append("") range_list.append(row) range_ndarray = np.asarray(range_list) print(range_ndarray)