Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1590
Currency format In excel column using Infragistics Excel
posted

Hi ,

In our application I am using Infragistics.Excel to export the file. But I am not able to apply the Currency format for numeic values.  Please how can i specify the currency format.

Ex:- 10,235.00 Ex: 0

Could you please respond soon will be appreciable because this is our immediate requirement and going to production today EOD.

Code snippet:-

Right now I am converting the value to string and applying the format. This cause the different problems. so please let me know the proper solution. If provide the sample application to me will be great helpful to me...

  if (value != null && value.ToString() == "0")
                    cell.Value = value.ToString();
                else
                    cell.Value = string.Format("{0:0,0}", value);
                                  cell.CellFormat.VerticalAlignment = VerticalCellAlignment.Center;
                cell.CellFormat.Alignment = HorizontalCellAlignment.Right;

 

Parents Reply Children