导出EXCEL的时候，单元格都是#DIV/0!该如何处理

using System;using System.Data;using Sweecom.BLL;using System.Collections;using System.Windows.Forms;using Sweecom.Model;using function;namespace Web.function{    /// <summary>    /// MakeReport 的摘要说明。    /// </summary>    public class MakeReport    {        public MakeReport()        {            //            // TODO: 在此处添加构造函数逻辑            //        }        private System.Data.DataTable _dt;        public System.Data.DataTable dt        {            get{return _dt;}            set{_dt = value;}        }        private string _strFilePath;        public string strFilePath        {            get{return _strFilePath;}            set{_strFilePath = value;}        }        private String[] _columnNames;        public String[] ColumnNames        {            get { return _columnNames; }            set { _columnNames = value; }        }        public bool CreatFile()        {            bool cFile = false;;            //            try            //            {            Microsoft.Office.Interop.Excel.ApplicationClass oExcel;                            oExcel = new Microsoft.Office.Interop.Excel.ApplicationClass();            oExcel.UserControl = false;            Microsoft.Office.Interop.Excel.WorkbookClass wb = (Microsoft.Office.Interop.Excel.WorkbookClass)oExcel.Workbooks.Add(System.Reflection.Missing.Value);            for (int j = 0; j < dt.Columns.Count; j++)            {                oExcel.Cells[1, j + 1] = _dt.Columns[j].ToString();            }            for (int i = 0; i < _dt.Rows.Count; i++)            {                DataRow dr = _dt.Rows[i];                for (int j = 0; j < _dt.Columns.Count; j++)                {                                                                oExcel.Cells[i + 2, j + 1] = dr[dt.Columns[j].ToString()].ToString();                                        }            }            wb.Saved = true;            //filename=  "d:/服务器生成文件/"+CompanyID.ToString();            string strFilePath1 = System.Web.HttpContext.Current.Server.MapPath(_strFilePath);            string strFileName =  DateTime.Now.ToString().Replace("-", "").Replace(" ", "").Replace(":", "") + DateTime.Now.Millisecond +".xls";            if (!System.IO.Directory.Exists(strFilePath1))            {                System.IO.Directory.CreateDirectory(strFilePath1);            }                            oExcel.ActiveWorkbook.SaveCopyAs(strFilePath1 + "/" +strFileName);            oExcel.Quit();            System.GC.Collect();            _strFilePath = _strFilePath + "/" + strFileName;            cFile = true;            //            }            //            catch            //            {            //                            //            }            return cFile;        }        public Boolean CreateFile1()        {            Int32 n = 0;            Boolean cFile = false;            try            {                Microsoft.Office.Interop.Excel.ApplicationClass oExcel;                                oExcel = new Microsoft.Office.Interop.Excel.ApplicationClass();                oExcel.UserControl = false;                Microsoft.Office.Interop.Excel.WorkbookClass wb = (Microsoft.Office.Interop.Excel.WorkbookClass)oExcel.Workbooks.Add(System.Reflection.Missing.Value);                for (Int32 num1 = 0; num1 < ColumnNames.Length; num1++)                {                    oExcel.Cells[1, num1 + 1] = ColumnNames[num1].ToString();                }                for (Int32 num1 = 0; num1 < _dt.Rows.Count; num1++)                {                    for (Int32 num2 = 0; num2 < _dt.Columns.Count; num2++)                    {                                                if (_dt.Rows[num1][num2].ToString().Length>1 && _dt.Rows[num1][num2].ToString().Substring(0, 1).Equals("0") && Int32.TryParse(_dt.Rows[num1][num2].ToString(),out n))//首字符是0                                                   oExcel.Cells[num1 + 2, num2 + 1] = "'" + _dt.Rows[num1][num2].ToString();                        else                            oExcel.Cells[num1 + 2, num2 + 1] = _dt.Rows[num1][num2].ToString();                                            }                }                wb.Saved = true;                String strFilePath1 = System.Web.HttpContext.Current.Server.MapPath("../File");                String strFileName = _dt.TableName + ".xls";                if (!System.IO.Directory.Exists(strFilePath1))                {                    strFilePath1 = System.Web.HttpContext.Current.Server.MapPath("../../File");                }                oExcel.ActiveWorkbook.SaveCopyAs(strFilePath1 + "\\" + strFileName);                oExcel.Quit();                System.GC.Collect();                _strFilePath = strFilePath1 + "\\" + strFileName;                cFile = true;            }            catch (Exception ex)            {                throw ex;            }            return cFile;        }        public void Export()        {            if (strFilePath != "")            {                System.IO.FileInfo file = new System.IO.FileInfo(strFilePath);                System.Web.HttpContext.Current.Response.Clear();                System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream";                System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + System.Web.HttpContext.Current.Server.UrlEncode(file.Name));                System.Web.HttpContext.Current.Response.AddHeader("Content-Length", file.Length.ToString());                System.Web.HttpContext.Current.Response.WriteFile(file.FullName);                System.Web.HttpContext.Current.Response.Write("<script>window.close();</script>");                System.Web.HttpContext.Current.Response.End();            }        }    } }//使用方法string[] columnNames = { "部门编号", "部门", "未支付费用", "已支付费用", "总计" };MakeReport mr = new MakeReport();mr.dt = Datatable;mr.ColumnNames = columnNames;mr.dt.TableName = "哈哈测试";if (mr.CreateFile1()){mr.Export();}
------解决方案--------------------------------------------------------
对呀给出你的导入代码。要不怎么知道那里错了呢？
http://zzk.cnblogs.com/s?w=%E5%AF%BC%E5%87%BAexcel&t=

------解决方案--------------------------------------------------------
up
------解决方案--------------------------------------------------------
UP
------解决方案--------------------------------------------------------
友情up
------解决方案--------------------------------------------------------
数据错误导致的