class Program
{
static void Main(string[] args)
{
List<Student> stu = new List<Student>()
{
new Student{ Id=1,Name="耀",Age=56},
new Student{ Id=1,Name="耀",Age=56},
new Student{ Id=1,Name="耀",Age=56},
new Student{ Id=1,Name="耀",Age=56},
new Student{ Id=1,Name="耀",Age=56},
new Student{ Id=1,Name="耀",Age=56},
};
var dic = new Dictionary<string, string>();
dic.Add("Id", "编号");
dic.Add("Name", "姓名");
dic.Add("Age", "年龄");
Expormgj(stu,@"F:\A.xls" );
Console.Read();
//导入
var dic1 = new Dictionary<string, string>();
dic1.Add("Id", "编号");
dic1.Add("Name", "姓名");
dic1.Add("Age", "年龄");
Console.Read();
}
public static void jfnf(List<Student> stusa, string FileName)
{
var warkwook = new HSSFWorkbook();
var hf = warkwook.CreateSheet("Sheet");
var sf = hf.CreateRow(0);
var gd = sf.CreateCell(0);
gd.SetCellValue("Id");
var gsg = sf.CreateCell(1);
gsg.SetCellValue("name");
}
public static void Expormgj(List<Student> stus, string FileName)
{
//创建工作簿
var workbook = new HSSFWorkbook();
//创建表
var table = workbook.CreateSheet("sheet1");
//创建行
var head = table.CreateRow(0);
//创建单元格
var Idcell = head.CreateCell(0);
Idcell.SetCellValue("编号");
var Namecell = head.CreateCell(1);
Namecell.SetCellValue("姓名");
var agesjj = head.CreateCell(2);
agesjj.SetCellValue("年龄");
int i = 0;
foreach (var s in stus)
{
var data = table.CreateRow(i++);
var datacell = data.CreateCell(0);
datacell.SetCellValue(s.Id);
var datacell2 = data.CreateCell(1);
datacell2.SetCellValue(s.Name);
var datacell3 = data.CreateCell(2);
datacell3.SetCellValue(s.Age);
}
using (FileStream fs = new FileStream(FileName, FileMode.Create))
{
workbook.Write(fs);
}
}
}
class Student
{
public int Id { get; set; }
public string Name { get; set; }
public int Age { get; set; }
}
c#导入导出
最新推荐文章于 2024-04-08 16:42:43 发布