DevExpress.XtraGrid.GridControl导出excel需要添加表头
string head = "";
head += "单号 \t" + txtcCode.Text ;
string foot = "";
foot += "制单人 \t" + "制单日期 \t" + "审核人: \t" + "审核日期 \t" + "修改人 \t" + "修改日期 \t" + "运算日期 \t" + "报价日期 \t" + "弃审人 \t" + "弃审日期 \t" + " \n";
using (MemoryStream ms = new MemoryStream())
{
gridControl1.ExportToText(ms);
ms.Position = 0;
List<string> rows = new List<string>();
using (var reader = new StreamReader(ms, Encoding.Default))
{
string line;
while ((line = reader.ReadLine()) != null)
{
rows.Add(line);
}
}
Dbdal.ExportExcelByStr(rows, true, head, foot);
}
public static void ExportExcelByStr(List<string> rows, bool showHide, string head, string foot = "")
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.Title = "导出Excel文件到";
DateTime now = DateTime.Now;
saveFileDialog.FileName = now.Year.ToString().PadLeft(2)
+ now.Month.ToString().PadLeft(2, '0')
+ now.Day.ToString().PadLeft(2, '0') + "-"
+ now.Hour.ToString().PadLeft(2, '0')
+ now.Minute.ToString().PadLeft(2, '0')
+ now.Second.ToString().PadLeft(2, '0');
if (DialogResult.Cancel == saveFileDialog.ShowDialog())
{
return;
}
Stream myStream;
myStream = saveFileDialog.OpenFile();
StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
string str = head;
try
{
sw.WriteLine(str);
foreach (string row in rows)
{
sw.WriteLine(row);
}
if (!string.IsNullOrEmpty(foot))
{
sw.WriteLine(foot);
}
sw.Close();
myStream.Close();
MessageBox.Show("导出成功!");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sw.Close();
myStream.Close();
}
}