mardi 24 février 2015

Export data table to excel sheet with number format

i need to export data set



DataSet ds = new DataSet("tabless");
ds.Tables.Add(table01);
ds.Tables.Add(table02);
ds.Tables.Add(table03);


contains 3 data table each one of them is



table01.Columns.Add("Branch",typeof(string));
table01.Columns.Add("Today", typeof(double));
table01.Columns.Add("MTD",typeof(double));
table01.Columns.Add("LM",typeof(double));
table01.Columns.Add("Differ",typeof(double),"LM-MTD");
table01.Columns.Add("YTD",typeof(double));


soo in need to export them to excel sheet with number format and comma separator like when value = -200000 will be(200,000) with red color and value 300000 will be 300,000 and each table in work sheet for more info check the below photo http://ift.tt/1addKB1


Aucun commentaire:

Enregistrer un commentaire