Hi Ramya,
I try to use this Excel component, performance is good. right now there is one thing we can't figure out, please help us.
In the Excel, We insert a lot of number cell which we need to format, for example cell
"AF284",
this value is 20372.511, we want to show as 20,373 , so we apply format rule
worksheet.Range["AF284"].NumberFormat = "_(* #,##0_);_(* (#,##0);_(* \"-\"??_);_(@_)";
when I open the Excel file after I save it, it doesn't apply these rule by default, see my below screen shot
but after we click "AF284", the format rule are apply, this cell show are correctly,
How can we apply all the format rule when we saved the Excel file, so it will show correct format when we open it?
Thanks,
CZ