abhi250372

Function only reading filtered rows. How do I read all rows from a sheet?

13

Here is my code - filepath = os.path.join(FolderPath, FileName) a = load_workbook(filepath, read_only=True) def read_excel_file(path: str, sheet_index: int) -> pd.DataFrame: buffer = StringIO() Xlsx2csv(path, outputencoding="utf8").convert(buffer,sheetid=sheet_index) buffer.seek(0) df = pd.read_csv(buffer) return...

Here is my code - filepath = os.path.join(FolderPath, FileName) a = load_workbook(filepath, read_only=True) def read_excel_file(path: str, sheet_index: int) -> pd.DataFrame: buffer = StringIO() Xlsx2csv(path, outputencoding="utf8").convert(buffer,sheetid=sheet_index) buffer.seek(0) df = pd.read_csv(buffer) return...