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

`python`: detecting merged cells in an Excel spreadsheet when in read-only mode

  • Thread starter Thread starter bzm3r
  • Start date Start date
B

bzm3r

Guest
In openpyxl, there's no way to detect merged cells while in read_only mode (crucial for dealing with large Excel files in a reasonable manner). The top comment on this question reminds readers that:

Note for future readers: don't load_workbook(..., read_only=True) as information regarding merged cells is unavailable in read-only mode.

Are there other libraries or engines which retain merged cell information in a read-only mode? Or is there a solution using openpyxl that allows one to retain such information?
<p>In <code>openpyxl</code>, there's no way to detect merged cells while in <code>read_only</code> mode (crucial for dealing with large Excel files in a reasonable manner). The top comment on this <a href="https://stackoverflow.com/questions/39574991/how-to-detect-merged-cells-in-an-excel-sheet">question</a> reminds readers that:</p>
<blockquote>
<p>Note for future readers: don't <code>load_workbook(..., read_only=True)</code> as information regarding merged cells is unavailable in read-only mode.</p>
</blockquote>
<p>Are there other libraries or engines which retain merged cell information in a read-only mode? Or is there a solution using <code>openpyxl</code> that allows one to retain such information?</p>
 

Latest posts

B
Replies
0
Views
1
Blundering Ecologist
B
Top