Export to Excel related issues

1. Missing driver or upgrade OLE DB driver issue: Install accessdatabaseengine_x64 or accessdatabaseengine modify Data link provider=microsoft.ace.oledb.12.0; Data source=; Extended properties= ' Excel 12.0; Hdr=yes; Imex=1 '

2. Iterate through the DataTable and modify the values in the corresponding columns to resolve the default export scientific count display

foreach (DataRow dri in dt. Rows)
{
StringBuilder sb = new StringBuilder ("=\");
SB=SB. Append (dri["customer number"]). Append ("\" ");
dri["customer number"] = SB;
}

3. Format the export time

CONVERT (varchar), Shijian,------------------20160601

Export to Excel related issues