Feature Type

  • [X] Adding new functionality to pandas

  • [ ] Changing existing functionality in pandas

  • [ ] Removing existing functionality in pandas

Problem Description

Hello! It would be great to have a chance to setup the decimal separator for to_excel function. Could you add this, please? It might be similar to https://github.com/pandas-dev/pandas/pull/44317

Feature Description

It is needed to setup the decimal separator when generating XLSX files so that it should not be necessary to fix this when opening Excel

Alternative Solutions

For now I have to convert floats to strings and replace '.' to ',' ...

Additional Context

No response

Comment From: attack68

Doesnt the decimal and thousands separator for an excel file change and depend on the region settings of the computer? At least in my experience the same file with the same floats displays differently on two computers with different region settings. in which case this cannot be controlled from pandas unless you explicitly write strings and not floats which also doesnt sound like a good idea?

Comment From: phofl

I think @attack68 is correct, closing for now. Please ping to reopen if you have other suggestions