Every line of 'read_xlsx pandas' code snippets is scanned for vulnerabilities by our powerful machine learning engine that combs millions of open source libraries, ensuring your Python code is secure.
11 def fromxlsx(filename, sheet=None, range_string=None, min_row=None, 12 min_col=None, max_row=None, max_col=None, read_only=False, 13 **kwargs): 14 """ 15 Extract a table from a sheet in an Excel .xlsx file. 16 17 N.B., the sheet name is case sensitive. 18 19 The `sheet` argument can be omitted, in which case the first sheet in 20 the workbook is used by default. 21 22 The `range_string` argument can be used to provide a range string 23 specifying a range of cells to extract. 24 25 The `min_row`, `min_col`, `max_row` and `max_col` arguments can be 26 used to limit the range of cells to extract. They will be ignored 27 if `range_string` is provided. 28 29 The `read_only` argument determines how openpyxl returns the loaded 30 workbook. Default is `False` as it prevents some LibreOffice files 31 from getting truncated at 65536 rows. `True` should be faster if the 32 file use is read-only and the files are made with Microsoft Excel. 33 34 Any other keyword arguments are passed through to 35 :func:`openpyxl.load_workbook()`. 36 37 """ 38 39 return XLSXView(filename, sheet=sheet, range_string=range_string, 40 min_row=min_row, min_col=min_col, max_row=max_row, 41 max_col=max_col, read_only=read_only, **kwargs)