123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172 |
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using NPOI.HSSF.UserModel;
- using System.IO;
- using StackExchange.Redis;
- //using System.Threading;
- //using System.Data;
- using CSharpUtil;
- //using Newtonsoft.Json;
- //using Newtonsoft.Json.Linq;
- //using System.Diagnostics;
- namespace DataTransfer.tongji
- {
- class loseUserDataTransfer
- {
- public static void excelText111()
- {
- //导出:将数据库中的数据,存储到一个excel中
- //1、查询数据库数据
- User user1 = new User() { Id = 1, Name = "小明", pwd = "123123", type = "学生" };
- User user2 = new User() { Id = 2, Name = "小红", pwd = "123123", type = "学生" };
- User user3 = new User() { Id = 3, Name = "小绿", pwd = "123123", type = "学生" };
- User user4 = new User() { Id = 4, Name = "小白", pwd = "123123", type = "老师" };
- User user5 = new User() { Id = 5, Name = "小黑", pwd = "123123", type = "老师" };
- User user6 = new User() { Id = 6, Name = "小蓝", pwd = "123123", type = "老师" };
- List<User> list = new List<User>();
- list.Add(user1);
- list.Add(user2);
- list.Add(user3);
- list.Add(user4);
- list.Add(user5);
- list.Add(user6);
- //2、 生成excel
- //2_1、生成workbook
- //2_2、生成sheet
- //2_3、遍历集合,生成行
- //2_4、根据对象生成单元格
- HSSFWorkbook workbook = new HSSFWorkbook();
- //创建工作表
- var sheet = workbook.CreateSheet("信息表");
- //创建标题行(重点) 从0行开始写入
- var row = sheet.CreateRow(0);
- //创建单元格
- var cellid = row.CreateCell(0);
- cellid.SetCellValue("编号");
- var cellname = row.CreateCell(1);
- cellname.SetCellValue("用户名");
- var cellpwd = row.CreateCell(2);
- cellpwd.SetCellValue("密码");
- var celltype = row.CreateCell(3);
- celltype.SetCellValue("类型");
- //遍历集合,生成行
- int index = 1; //从1行开始写入
- for (int i = 0; i < list.Count; i++)
- {
- int x = index + i;
- var rowi = sheet.CreateRow(x);
- var id = rowi.CreateCell(0);
- id.SetCellValue(list[i].Id);
- var name = rowi.CreateCell(1);
- name.SetCellValue(list[i].Name);
- var pwd = rowi.CreateCell(2);
- pwd.SetCellValue(list[i].pwd);
- var type = rowi.CreateCell(3);
- type.SetCellValue(list[i].type);
- }
- FileStream file = new FileStream(@"F:\excel\信息表.xls", FileMode.CreateNew, FileAccess.Write);
- workbook.Write(file);
- file.Dispose();
- }
- public static void excelText(string memKey,int retain,int zoneid,float day)
- {
- //获取redis种的数据
- var mem = Redis.Ins.GetDatabase(0);
- HashEntry[] ctxList = mem.HashGetAll(memKey);
- int length = ctxList.Length;
- if (length <= 0)
- {
- return;
- }
- HSSFWorkbook workbook = new HSSFWorkbook();
- //创建工作表
- var sheet = workbook.CreateSheet("信息表");
- var row = sheet.CreateRow(0);
- //创建单元格
- var cellid = row.CreateCell(0);
- cellid.SetCellValue("指标类型");
- var cellname = row.CreateCell(1);
- cellname.SetCellValue("指标id");
- var cellpwd = row.CreateCell(2);
- cellpwd.SetCellValue("指标累计值");
- int x = 1;
- foreach (var item in ctxList)
- {
-
- string[] sList = item.ToString().Split(':');
- string type = sList[0];
- int num = int.Parse(sList[1]);
- string[] ctx = type.Split('-');
- string name = ctx[0];
- int id = int.Parse(ctx[1]);
-
- var rowi = sheet.CreateRow(x);
- var cname = rowi.CreateCell(0);
- cname.SetCellValue(name);
- var cid = rowi.CreateCell(1);
- cid.SetCellValue(id);
- var cnum = rowi.CreateCell(2);
- cnum.SetCellValue(num);
-
- x += 1;
- }
- string txtName = "流失玩家指标累计信息表_" +"zone"+zoneid+"_"+retain+"retaine_" + day;
- FileStream file = new FileStream(@"F:\excel\"+txtName+".xls", FileMode.CreateNew, FileAccess.Write);
- workbook.Write(file);
- file.Dispose();
- }
- }
- public class User
- {
- /// <summary>
- /// 索引
- /// </summary>
- public int Id { get; set; }
- public string Name { get; set; }
- public string pwd { get; set; }
- public string type { get; set; }
- }
- public class Model
- {
- /// <summary>
- /// 索引
- /// </summary>
- public int Id { get; set; }
- public string Name { get; set; }
- public int pwd { get; set; }
- public string type { get; set; }
- }
- }
|