void createXLSFile()
{
using (this.con)
{
if(con.State==ConnectionState.Closed) con.Open();
string sqlAccounts = @"select distinct ACCNO, ACCNAME from View_Kite_LoadReport_ACCNO";
SqlDataAdapter adp = new SqlDataAdapter(sqlAccounts, con);
DataSet dst = new DataSet();
adp.Fill(dst, "ACCOUNTS");
string sqlAll = "select * from View_Kite_LoadReport_ACCNO order by ACCNO,ACCNAME,CORTEXDATE,CRDPRODUCT,PROGRAMID,ACCTYPE";
adp = new SqlDataAdapter(sqlAll, con);
adp.Fill(dst, "ALL");
LoadsXLSCreator loads = new LoadsXLSCreator(dst.Tables["ACCOUNTS"]);
loads.CreateFlatSheet(dst.Tables["ALL"]);
LoadsXLSCreator.CellFieldProperty ACCNO = new LoadsXLSCreator.CellFieldProperty("ACCNO");// "ACCNO", "ACCNAME"\
//"CORTEXDATE", "CRDPRODUCT", "PROGRAMID", "ACCTYPE", "DESCRIPTION", "AMTBILL"
loads.HeaderFields((new LoadsXLSCreator.CellFieldProperty("ACCNO")), (new LoadsXLSCreator.CellFieldProperty("ACCNAME")))
.DetailFields((new LoadsXLSCreator.CellFieldProperty("CORTEXDATE",CarlosAg.ExcelXmlWriter.DataType.String,"{0:MM/dd/yyyy}")),
(new LoadsXLSCreator.CellFieldProperty("CRDPRODUCT")), (new LoadsXLSCreator.CellFieldProperty("PROGRAMID")),
(new LoadsXLSCreator.CellFieldProperty("ACCTYPE")),(new LoadsXLSCreator.CellFieldProperty("DESCRIPTION")),
(new LoadsXLSCreator.CellFieldProperty("AMTBILL",CarlosAg.ExcelXmlWriter.DataType.Number)))
.Create();
}
}
