大数据xls导出.txt

 

public void ExcelOut()
        {
  string fname = "D:/caiwu/attach/" + DateTime.Now.ToString("yyyyMMddHHmm") + ".xls";
                  
                            DataTable dt = DataLogic.GetListOrder();

                            Excelout(dt, fname);

    }
//大数据导出excel
  private void Excelout(DataTable ds, string path)
        {
            try
            {
                long totalCount = ds.Rows.Count;
                long rowRead = 0;
                float percent = 0;


                StreamWriter sw = new StreamWriter(path, true, Encoding.GetEncoding("gb2312"));
                StringBuilder sb = new StringBuilder();
                for (int k = 0; k < ds.Columns.Count; k++)
                {
                    sb.Append(ds.Columns[k].ColumnName.ToString() + "\t");
                }
                sb.Append(Environment.NewLine);
                for (int i = 0; i < ds.Rows.Count; i++)
                {