search

ropensci / writexl

Portable, light-weight data frame to xlsx exporter for R
https://docs.ropensci.org/writexl
Other
209 stars 17 forks source link

write xlsx without any fonts #74

Closed toxintoxin closed 8 months ago

toxintoxin commented 8 months ago

Thank you for such a great package, it was so fast.

But I have a problem, I'm Chinese and when I use it to export xlsx, the font is always Song, which is annoying because numbers and english letters are hard to read in Song. In the openxlsx::write.xlsx, I see the font is Calibri in the result.

Can I solve this problem from somewhere?

jmcnamara commented 8 months ago

The libxlsxwriter library used by writexl uses Calibri as the default font, the same as Excel. If the font is showing as Song then that may be a Windows or Excel setting that is changing it.

toxintoxin commented 8 months ago

The libxlsxwriter library used by writexl uses Calibri as the default font, the same as Excel. If the font is showing as Song then that may be a Windows or Excel setting that is changing it.

Thank you. So that's why.

FYI, I found change the language setting of Excel 2016 works. 选项>语言>Office 创作语言和校对, put the English to the top.

jmcnamara commented 8 months ago

@toxintoxin that is good to know. Could you close the issue if it is resolved.