I am using spire.xls in c# and trying to get the percentage type values in the excel sheet.
I read up online and found this code should work:
sheet.Range["B12"].Text = "0.00%";
sheet.Range["C12"].NumberValue = 1234.5678;
sheet.Range["C12"].NumberFormat = "0.00%";
But so far it has not worked.
The version we are using for SPIRE - 10.1.0 via nugetpackage
I have attached the images with this.
One image shows even after using the demo or the code from the forum still the formatting type is General and not the Percentage.
Second image shows what we actually are trying to achieve.
Pls advice