Пример #1
0
        private void ButtonBase_OnClick(object sender, RoutedEventArgs e)
        {
            List <People> list = new List <People>();

            list.Add(new People()
            {
                Name = "张三", Age = "10"
            });
            list.Add(new People()
            {
                Name = "李四", Age = "11"
            });
            list.Add(new People()
            {
                Name = "王五", Age = "13"
            });
            list.Add(new People()
            {
                Name = "345张三", Age = "17"
            });
            Hashtable ht = new Hashtable();

            ht.Add("Name", "姓名");
            ht.Add("Age", "年龄");
            string path = "D:\\21.xls";

            ExcelManager <People> .getExcel(list, ht, path);
        }
Пример #2
0
 private void Button_Click(object sender, RoutedEventArgs e)
 {
     ExcelManager.test3();
     //   HSSFWorkbook workbook = new HSSFWorkbook();
     //ISheet sheet = workbook.CreateSheet("sheet1");
     //ExcelManager.SetCellDropdownList(sheet, 1, 1, new List<string>() { "男", "女", "保密" }.ToArray());
     //MemoryStream ms=new MemoryStream();
     //workbook.Write(ms);
     //ms.Flush();
     //ms.Position = 0;
     //sheet = null;
     //string workbookFile = @"D:\\wulei.xls";
     //workbook = null;
     //FileStream fs = new FileStream(workbookFile, FileMode.Create, FileAccess.Write);
     //byte[] data = ms.ToArray();
     //fs.Write(data, 0, data.Length);
     //fs.Flush();
     //fs.Close();
 }