WPF 导出数据

　　  //数据导出Excel功能

　　  private void btnExcelZD_Click(object sender, RoutedEventArgs e)
        {
            if (zdDataGrid.Items.Count == 0)
            {
                Message_Box.Show("没有数据可以导出！");
                return;
            }
            Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
            if (xlApp == null)
            {
                Message_Box.Show("无法创建Excel对象，可能您的机子未安装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] = "更新时间";
            sheet.Cells[2, 8] = "终端类型";
            //设置Excel样式
            Microsoft.Office.Interop.Excel.Range rang1;
            Microsoft.Office.Interop.Excel.Range title1;
            Microsoft.Office.Interop.Excel.Range merge1;
            //数据导出
            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;
            //显示时间和日期
            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 = "数据文件(*.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();
            }
        }