Click here to Skip to main content
16,018,904 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Friends,

I am using VS 2008 ,asp.net,c#.net.
I have numbers in decimal format in grid.
I want to export a decimal figure to excel sheet with thousand separators and decimal separators.
Those numbers should be aligned right.
for example 12,12,34,567.89
Also the in bulit excel formulas like sum .. must be performed on the exported excel sheet.

Tx in advance
george
Posted
Comments
JoCodes 17-Jan-14 2:12am    
thousand separators?

You need to add formatting details to the cells where you want it to appear as described. For the sum you need to add the SUM() formula to the cell in question.
 
Share this answer
 
use comma seperator to seperate your decimal values and point this full data into cell and insert cell to row of excel sheet
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900