private void btnExcelZD_Click(object sender, RoutedEventArgs e)
{
if (zdDataGrid.Items.Count == 0)
{
Message_Box.Show("沒有數(shù)據(jù)可以導(dǎo)出！");
return;
}
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
if (xlApp == null)
{
Message_Box.Show("無法創(chuàng)建Excel對象，可能您的機(jī)子未安裝Excel！");
return;
}
Microsoft.Office.Interop.Excel.Workbooks books = xlApp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook book = books.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)book.Worksheets[1];
sheet.Cells[1, 1] = "終端信息管理";
sheet.Cells[2, 1] = "終端編號";
sheet.Cells[2, 2] = "IP";
sheet.Cells[2, 3] = "所屬部門";
sheet.Cells[2, 4] = "姓名";
sheet.Cells[2, 5] = "工號";
sheet.Cells[2, 6] = "終端名稱";
sheet.Cells[2, 7] = "更新時(shí)間";
sheet.Cells[2, 8] = "終端類型";
//設(shè)置Excel樣式
Microsoft.Office.Interop.Excel.Range rang1;
Microsoft.Office.Interop.Excel.Range title1;
Microsoft.Office.Interop.Excel.Range merge1;
//數(shù)據(jù)導(dǎo)出
for (int i = 0; i < zdDataGrid.Items.Count; i++)
{
Model.Client client = (Model.Client)zdDataGrid.Items[i];
sheet.Cells[i + 3, 1] = client.SN;
sheet.Cells[i + 3, 2] = client.IP;
sheet.Cells[i + 3, 3] = client.DName;
sheet.Cells[i + 3, 4] = client.Name;
sheet.Cells[i + 3, 5] = client.JobNumber;
sheet.Cells[i + 3, 6] = client.ClientName;
sheet.Cells[i + 3, 7] = client.UpDateTime.ToString();
sheet.Cells[i + 3, 8] = client.Types;
}
merge1 = (Microsoft.Office.Interop.Excel.Range)sheet.get_Range("A1", "H1");
merge1.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
merge1.Font.Name = "黑體";
merge1.Font.Size = 16;
merge1.Merge(0);
merge1.Borders.LineStyle = 1;
title1 = (Microsoft.Office.Interop.Excel.Range)sheet.get_Range("A2", "H2");
title1.Cells.Interior.Color = System.Drawing.Color.FromArgb(208, 206, 210).ToArgb();
title1.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
title1.ColumnWidth = 15;
title1.Borders.LineStyle = 2;
title1.Font.Size = 13;
int Number = zdDataGrid.Items.Count + 2;
string HN = "H" + Number;
string A3 = "A3";
rang1 = (Microsoft.Office.Interop.Excel.Range)sheet.get_Range(A3, HN);
rang1.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;
rang1.ColumnWidth = 15;
rang1.Borders.LineStyle = 1;
//顯示時(shí)間和日期
Microsoft.Office.Interop.Excel.Range time1;
int Num = zdDataGrid.Items.Count + 3;
string ANS = "A" + Num;
string HNS = "H" + Num;
time1 = (Microsoft.Office.Interop.Excel.Range)sheet.get_Range(ANS, HNS);
time1.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignRight;
time1.RowHeight = 25;
time1.Merge(0);
time1.Value = DateTime.Now.ToString();
xlApp.DefaultFilePath = "D:\\";
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "數(shù)據(jù)文件(*.xlsx)|*.xlsx";
sfd.FilterIndex = 2;
sfd.FileName = (DateTime.Now.ToString().Replace(":", "-").Replace("/", "-") + "終端信息管理.xlsx");
if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
book.Saved = true;
book.SaveAs(sfd.FileName);
book.Close();
}
}