导出Excel 并且适应列宽的长度

    ///DataObject[] 可以把它试做为DataTable

private void ExportExcel(DataObject[] objs)
    {
        //读取Excel路徑
        string excelSource = Server.MapPath("SIP016Export.xls");
        string FileName = "SIP016Export.xls";
        string tempFolder = "../../../tempFolder/";
        string tempFilePath = Server.MapPath(tempFolder + FileName);
        File.Copy(excelSource, tempFilePath, true);
        object missing = System.Type.Missing;
        Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
        Workbook workbook = app.Workbooks._Open(tempFilePath, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
        Worksheet worksheet = (Worksheet)workbook.Worksheets[1];
        app.Visible = false;

        for (int i = 0;