private void LoadList() { gvList.AutoGenerateColumns = false; gvList.DataSource = miBll.GetList(); txtName.TabIndex = 0; txtPwd.TabIndex = 1; rb0.TabIndex = 2; rb1.TabIndex = 3; btnSave.TabIndex = 4; gvList.TabIndex = 5; }
private void btnExport_Click(object sender, EventArgs e) { //导出:将数据库中的数据,存储到一个excel中 //1、查询数据 var list = miBll.GetList(); // dgvList.DataSource = miBll.GetList(); //2、生成excel //生成workbook //生成sheet //遍历集合,生成行。(一个对象就是一行) //根据对象生成单元格,一个属性对应一个单元格 //创建工作本 HSSFWorkbook workbook = new HSSFWorkbook(); //创建工作表 //NPOI.SS.UserModel.ISheet sheet = workbook.CreateSheet("管理员"); ISheet sheet = workbook.CreateSheet("管理员"); //创建标题行 IRow row = sheet.CreateRow(0); //创建单元格 ICell cellId = row.CreateCell(0); cellId.SetCellValue("编号"); ICell cellName = row.CreateCell(1); cellName.SetCellValue("用户名"); ICell cellPwd = row.CreateCell(2); cellPwd.SetCellValue("密码"); ICell cellType = row.CreateCell(3); cellType.SetCellValue("类型"); FileStream file = new FileStream(@"C:\Users\Administrator\Desktop\b.xls", FileMode.CreateNew, FileAccess.Write); workbook.Write(file); file.Dispose(); }
private void button1_Click(object sender, EventArgs e) { //弹出保存对话框 SaveFileDialog sfd = new SaveFileDialog(); sfd.Title = "请选择要保存的路径,默认为桌面"; sfd.InitialDirectory = @"C:\Users\Administrator\Desktop"; sfd.Filter = "xls表格文件|*.xls|所有文件|*.*"; sfd.ShowDialog(); //获得保存文件的路径 string path = sfd.FileName; if (path == "")//打开了对话框,但是没有选择地址 { return; } //如果用户选择了保存路径,则开始进行保存操作 //导出:将数据库中的数据,存储到一个excel中 //1、查询数据 var list = miBll.GetList(); // dgvList.DataSource = miBll.GetList(); //2、生成excel //生成workbook //生成sheet //遍历集合,生成行。(一个对象就是一行) //根据对象生成单元格,一个属性对应一个单元格 //创建工作本 HSSFWorkbook workbook = new HSSFWorkbook(); //创建工作表 //NPOI.SS.UserModel.ISheet sheet = workbook.CreateSheet("管理员"); ISheet sheet = workbook.CreateSheet("管理员"); //创建标题行 IRow row = sheet.CreateRow(0); //合并单元格 sheet.AddMergedRegion(new CellRangeAddress(0, 0, 0, 3)); ICell cellTitle = row.CreateCell(0); cellTitle.SetCellValue("管理员列表"); //样式操作 var style = workbook.CreateCellStyle(); //style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Left;//左对齐 //style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Right;//右对齐 style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center; //居中 //竖直方向 style.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center; //垂直居中 //应用样式 cellTitle.CellStyle = style; IRow row1 = sheet.CreateRow(1); //创建单元格 ICell cellId = row1.CreateCell(0); cellId.SetCellValue("编号"); ICell cellName = row1.CreateCell(1); cellName.SetCellValue("用户名"); ICell cellPwd = row1.CreateCell(2); cellPwd.SetCellValue("密码"); ICell cellType = row1.CreateCell(3); cellType.SetCellValue("类型"); //遍历集合,生成行 int index = 2;//索引,0,1是表头。所以从2开始。 foreach (var item in list) { var row2 = sheet.CreateRow(index++); var cell0 = row2.CreateCell(0); cell0.SetCellValue(item.MId); var cell1 = row2.CreateCell(1); cell1.SetCellValue(item.MName); var cell2 = row2.CreateCell(2); cell2.SetCellValue(item.MPwd); var cell3 = row2.CreateCell(3); cell3.SetCellValue(item.MType == 0 ? "店员" : "经理"); } FileStream file = new FileStream(path, FileMode.Create, FileAccess.Write); workbook.Write(file); file.Dispose();//使用完要释放资源,或者使用using(){} }