You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This is not about the naming problem that "ExcelWriter" also supports ods files but is named "Excel" instead of "ExcelAndOds" or something better.
See the argument engine in the docu.
It should explain which engines (and packages behind) are used by default for the different possible filetypes. It only explains which one is deprecated.
See the argument engine_kwargs.
Here is a list of engines/packages. It is unclear if this are the engine strings that can be used with the engine keyword or if this are the package names.
For odf it seems that odswriter is the used engine. But that project seems dead because of the last commit in 2016 (6 years ago).
Looking around in the internet I also find tutorials using odfpy. Again it is not clear if this is the engine string or just the package name. But that tutorials quit old and it is unclear for me if this is supported or not.
I also found a tutorial using engine="odf" which is unclear which package is used here.
Suggested fix for documentation
Clearly differentiate between package names and the string that can be used for engine argument.
Make clear which engines/packages are supported for which file types.
The text was updated successfully, but these errors were encountered:
Of course open to any improvements you'd like to make to the excel page you've linked.
W.r.t. the naming of "ExcelWriter", the history of how this was developed was that opendoc support came way later than excel support. I think at the time we decided it wasn't worth any API churn for correctness when most people think of ods / excel files to be conceptually the same (at least as far as pandas is concerned). I don't see us changing that
Pandas version checks
main
hereLocation of the documentation
https://pandas.pydata.org/docs/reference/api/pandas.ExcelWriter.html
Documentation problem
This is not about the naming problem that "ExcelWriter" also supports ods files but is named "Excel" instead of "ExcelAndOds" or something better.
See the argument
engine
in the docu.It should explain which engines (and packages behind) are used by default for the different possible filetypes. It only explains which one is deprecated.
See the argument
engine_kwargs
.Here is a list of engines/packages. It is unclear if this are the engine strings that can be used with the
engine
keyword or if this are the package names.For odf it seems that
odswriter
is the used engine. But that project seems dead because of the last commit in 2016 (6 years ago).Looking around in the internet I also find tutorials using
odfpy
. Again it is not clear if this is theengine
string or just the package name. But that tutorials quit old and it is unclear for me if this is supported or not.I also found a tutorial using
engine="odf"
which is unclear which package is used here.Suggested fix for documentation
Clearly differentiate between package names and the string that can be used for
engine
argument.Make clear which engines/packages are supported for which file types.
The text was updated successfully, but these errors were encountered: