wpf datarid自定义导出到execl

Question

wpfdatagridexecl

Answer 1

ItemsSource 是什么？？ dataTable参见：http://blog.csdn.net/duanzi_peng/article/details/17414629
不过也可是用NPOI，也很方便。

Answer 2

#region 用户信息导出
        private void BtnCancdel1_Click(object sender, RoutedEventArgs e)
        {
            SaveFileDialog sd = new SaveFileDialog();
            sd.Filter = "Excel文件|*.xls";
            if(sd.ShowDialog()!=true)
            {
                return;
            }
            string filename = sd.FileName;
            HSSFWorkbook workbook = new HSSFWorkbook();
            ISheet sheet = workbook.CreateSheet("用户数据");
            IRow rowheader = sheet.CreateRow(0);
            rowheader.CreateCell(0,CellType.STRING).SetCellValue("用户编号");
            rowheader.CreateCell(1, CellType.STRING).SetCellValue("用户名");
            rowheader.CreateCell(2, CellType.STRING).SetCellValue("真实姓名");
            Users[] user = (Users[])dataGrid1.ItemsSource;
            for (int i = 0; i < user.Length;i++ )
            {
                Users users=user[i];
                IRow row = sheet.CreateRow(i+1);
                row.CreateCell(0, CellType.STRING).SetCellValue(users.Id);
                row.CreateCell(1, CellType.STRING).SetCellValue(users.LoginName);
                row.CreateCell(2, CellType.STRING).SetCellValue(users.RealName);
            }
            using (FileStream stream = File.OpenWrite(filename))
            {
                workbook.Write(stream);
            }
        }
        #endregion
       

Answer 3

 dataGrid1.ItemsSource = UsersDAL.GetAll();