search

dhatim / fastexcel

Generate and read big Excel files quickly
Other
675 stars 122 forks source link

Thousand separator in FastExcel #128

Closed karthick9686 closed 3 years ago

karthick9686 commented 3 years ago

Hi, I don't know how to do Thousand separator in FastExcel for number value. Please help me to achieve this.

rzymek commented 3 years ago

Try this:

ws.value(0, 0, 1_000_000);
ws.style(0, 0).format("#,##0").set();
karthick9686 commented 3 years ago

Thanks for your support