Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/pandas-dev/pandas/issues/55027 below:

_openpyxl.py load_workbook allow to modify the read_only, data_only and keep_links parameters using engine_kwargs · Issue #55027 · pandas-dev/pandas · GitHub

• Adding new functionality to pandas

• Changing existing functionality in pandas

• Removing existing functionality in pandas

Dear Developers,

I was updating my libraries using Pandas 2.1.0 and Openpyxl 3.1.2 as engine and I found a missing point, months ago it was added the opportunity to include in the engine_kwargs for this lib the keep_vba parameter but, the other parameters were stablished /forced by default. If we want to change the behaviour we cannot doing it from pandas, that's why I;m requesting to include all these parameters as well not only the VBA.

the current definition on _openpyxl.py file is:

def load_workbook(
        self, filepath_or_buffer: FilePath | ReadBuffer[bytes], engine_kwargs
    ) -> Workbook:
        from openpyxl import load_workbook

        return load_workbook(
            filepath_or_buffer,
            read_only=True,
            data_only=True,
            keep_links=False,
            **engine_kwargs,
        )

and it must be just 👍
` def load_workbook(
self, filepath_or_buffer: FilePath | ReadBuffer[bytes], engine_kwargs
) -> Workbook:
from openpyxl import load_workbook

    return load_workbook(
        filepath_or_buffer,
        **engine_kwargs,
    )`

Many thanks for your support,

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4