I’m working on generating translated xlsx files. While we can pass translated strings into xlsx, some strings generated are not translated into other languages.
Examples like: Total, Grand Total(they are generated by pivotTable.setRowGrand(true)), Row Labels
Is there a way to translate them based on some parameters (like locale or language)?
I find that there is a function called
But the instruction tells:
Gets or sets the Locale used by this workbook. MS Excel will always
display a file in accordance with the machine’s locale settings, no
matter what the locale/region has been set (in your code).
So I’m just wondering is there a way to translate those strings or excel will only handle it based on the locale setting of the machine which opens it?