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