OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

`pandas`: how to pass optimization options such as `read_only=True` to `pandas.read_excel` using `openpyxl` as the engine,?

  • Thread starter Thread starter bzm3r
  • Start date Start date


I want to use pandas.read_excel to read an Excel file with the option engine="openpyxl". However, I also want to pass additional optimization options to openpyxl such as:

  • read_only=True
  • data_only=True
  • keep_links=False

How do I do this?
<p>I want to use <a href="https://pandas.pydata.org/docs/reference/api/pandas.read_excel.html" rel="nofollow noreferrer"><code>pandas.read_excel</code></a> to read an Excel file with the option <code>engine="openpyxl"</code>. However, I also want to pass additional <a href="https://openpyxl.readthedocs.io/en/latest/optimized.html" rel="nofollow noreferrer">optimization options to <code>openpyxl</code> such as</a>:</p>
<p>How do I do this?</p>