I need to export a data set:
DataSet ds = new DataSet("tabless");
ds.Tables.Add(table01);
ds.Tables.Add(table02);
ds.Tables.Add(table03);
it 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));
then i added data to each table ...
table01.Rows.Add("A", 0, 84100, 2, null, 9);
So I need to export them to an 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 apply this to each table in the work sheet. For more info check the below photo:
http://postimg.org/image/lj55lz6ib/[
^]