asp.net利用开源MyXLS生成excel

1.Download the binaries.
2.Add a reference to org.in2bits.MyXls.dll in your project
3.Add a using statement to reference the MyXls namespace using org.in2bits.MyXls;

 

一、
asp.net环境下发送到客户端

XlsDocument doc = new XlsDocument(); doc.FileName = "ok" + ".xls"; Worksheet sheet = doc.Workbook.Worksheets.Add("Hello World Sheet"); Cell cell = sheet.Cells.Add(1, 1, "Hello!"); cell.Font.Weight = FontWeight.Bold; doc.Send();

 

二、保存excel

XlsDocument doc = new XlsDocument(); doc.FileName = Server.MapPath("~/files/excel/")+"ok" + ".xls"; Worksheet sheet = doc.Workbook.Worksheets.Add("Hello World Sheet"); Cell cell = sheet.Cells.Add(1, 1, "Hello!"); cell.Font.Weight = FontWeight.Bold; doc.Save();