private void btnSave_Click(object sender, EventArgs e)
{
//AsyncCallback callback = new AsyncCallback(ExportCompleted);
//ExportMediator.PerformExportAsync(dataGridView,callback);
if(ExportMediator.PerformExport(dataGridView,FileType.Html))
MessageBox.Show(this,"数据保存成功","成功提示",MessageBoxButtons.OK,MessageBoxIcon.Information,MessageBoxDefaultButton.Button1);
}
public static class ExportMediator
{
public static bool ShowSaveExcelDialog(out string fileName, FileType type)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "���Excel 文件";
saveFileDialog.Filter = "Excel 文件(*.xls)|*.xls";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = false;
saveFileDialog.CreatePrompt = false; //���
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
fileName = saveFileDialog.FileName;
return true;
}
else
{
fileName = null;
return false;
}
}
public static bool Export(DataGridView dataGridView, string fileName, FileType type)
{
switch (type)
{
case FileType.Excel:
return Export2Excel(dataGridView, fileName);
break;
case FileType.Html:
return Export2Html(dataGridView,fileName);
break;
default:
return false;
break;
}
}
public static bool Export2Excel(DataGridView dataGridView,string xlsName)
{
if (dataGridView == null || xlsName == null || xlsName.Trim() == "")
return false;
//object objOpt = Missing.Value;
Excel.Application
xlApp = new Excel.ApplicationClass();
xlApp.DefaultFilePath = "";
xlApp.DisplayAlerts = false; //Ӹ�Ϊfalse
xlApp.SheetsInNewWorkbook = 1;
Excel.Workbook xlBook = xlApp.Workbooks.Add(true);
//��DataTable�������Excel���һ�
int columnIndex = 1;
foreach (DataGridViewColumn column in dataGridView.Columns)
{
//if (column.Visible)
xlApp.Cells[1, columnIndex++] = column.HeaderText;
}
//н�DataTable�е���ݵ��Excel��
int rowIndex = 2;
foreach (DataGridViewRow row in dataGridView.Rows)
{
columnIndex = 1;
foreach (DataGridViewCell cell in row.Cells)
{
xlApp.Cells[rowIndex, columnIndex++] = cell.Value;
}
rowIndex++;
}
xlBook.SaveCopyAs(xlsName);
//if (xlBook.Saved == true)
// xlBook.Close(true, objOpt, objOpt);
xlApp.Quit();
return true;
}
public static bool Export2Html(DataGridView dataGridView, string htmlName)
{
if (dataGridView == null || htmlName == null || htmlName.Trim() == "")
return false;
StringBuilder sbHtml = new StringBuilder("<html><head><title>���ʷ���</title><meta http-equiv='Content-Type' content='text/html; charset=utf-8'/></head>");
sbHtml.Append("<body>\n<table border='1' cellPadding='1' cellSpacing='0'>\n");
sbHtml.Append("<tr>");
foreach (DataGridViewColumn column in dataGridView.Columns)
{
if (column.Visible)
sbHtml.Append(string.Format("<td>{0}</td>", GetSafeString(column.HeaderText)));
}
sbHtml.Append("</tr>\n");
//�DataTable�е���ݵ��Excel��
foreach (DataGridViewRow row in dataGridView.Rows)
{
sbHtml.Append("<tr>");
foreach (DataGridViewCell cell in row.Cells)
{
if (cell.Visible)
sbHtml.Append(string.Format("<td>{0}</td>", GetSafeString(cell.Value)));
}
sbHtml.Append("</tr>\n");
}
sbHtml.Append("</table></body></html>");
using (StreamWriter write = new StreamWriter(htmlName))
{
write.Write(sbHtml.ToString());
write.Close();
}
return true;
}
public static bool PerformExport(DataGridView dataGridView, FileType type)
{
string fileName;
return ShowSaveExcelDialog(out fileName, type)
&& Export(dataGridView, fileName, type);
}
//public static bool ExportToText(SaleInfo saleInfo, string fileName)
//{
// StreamWriter sw = new StreamWriter(fileName);
// //sw.WriteLine("" + saleInfo.
//}
static string GetSafeString(object obj)
{
return obj.ToString().Replace("<", "<").Replace(">", ">");
}
}
public enum FileType
{
Excel,
Html
}