How to use 'read_xlsx pandas' in Python

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.

All examples are scanned by Snyk Code

By copying the Snyk Code Snippets you agree to
11def 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.
17 N.B., the sheet name is case sensitive.
19 The `sheet` argument can be omitted, in which case the first sheet in
20 the workbook is used by default.
22 The `range_string` argument can be used to provide a range string
23 specifying a range of cells to extract.
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.
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.
34 Any other keyword arguments are passed through to
35 :func:`openpyxl.load_workbook()`.
37 """
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)

Related snippets