public static MemoryStream Export(DataTable data, string fileName)
{
HSSFWorkbook book = new HSSFWorkbook();
ISheet sheet = book.CreateSheet(fileName);
CreaHeader(data, sheet);
if (data != null)
{
for (int i = 0; i < data.Rows.Count; i++)
{
IRow row = sheet.CreateRow(sheet.LastRowNum + 1);
DataRow dataRow = data.Rows[i];
for (int j = 0; j < data.Columns.Count; j++)
{
ICell cell = row.CreateCell(j);
cell.SetCellValue(ConvertHelper.ToString(dataRow[j]));
}
}
}
MemoryStream ms = new MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
return(ms);
}
/// <summary>
/// 生成验证码
/// </summary>
/// <param name="length"></param>
/// <returns></returns>
public static string GenerateCode(int length = 4)
{
Random rd = new Random();
string code = string.Empty;
for (int i = 0; i < length; i++)
{
code += ConvertHelper.ToString(rd.Next(0, 9));
}
return(code);
}