public static void WriteToFile <T>(string path, List <T> data)
{
path = path.EndsWith(".xls") ? path : path + "-" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls";
var props = AssembleUtil.GetPorpertyNames <T>(flags);
HSSFWorkbook workbook = new HSSFWorkbook();
ISheet sheet = workbook.CreateSheet(Path.GetFileNameWithoutExtension(path));
Dictionary <int, string> valuePos = new Dictionary <int, string>();
for (int i = 0; i < props.Count; ++i)
{
valuePos.Add(i, props[i]);
}
IRow headRow = sheet.CreateRow(0);
SetRowValue(headRow, valuePos);
int rowPos = 1;
foreach (var d in data)
{
var row = sheet.CreateRow(rowPos++);
SetRowValue(row, valuePos, AssembleUtil.GetPropertyValues(d, flags));
}
using (FileStream file = new FileStream(path, FileMode.Create))
{
workbook.Write(file);
}
}
private static List <T> ReadFromSheet <T>(ISheet sheet)
{
List <T> formattedData = new List <T>();
List <Dictionary <string, object> > sheetData = GetSheetData(sheet, true);
foreach (var d in sheetData)
{
formattedData.Add(AssembleUtil.SetPorpertyValues <T>(d, flags));
}
return(formattedData);
}
private static string GetHeaderString <T>()
{
StringBuilder header = new StringBuilder();
var props = AssembleUtil.GetPorpertyNames <T>(flags);
foreach (var p in props)
{
header.AppendFormat("{0},", p);
}
return(header.ToString().TrimEnd(','));
}
private static string GetValueString <T>(T data)
{
StringBuilder value = new StringBuilder();
var objValues = AssembleUtil.GetPropertyValues(data, flags);
foreach (var v in objValues.Values)
{
var temp = v.ToString();
if (temp.Contains(",") || temp.Contains(" "))
{
temp = string.Format("\"{0}\"", v);
}
value.AppendFormat("{0},", temp);
}
return(value.ToString().TrimEnd(','));
}
private static T SetValueToObj <T>(Dictionary <string, object> values)
{
return(AssembleUtil.SetPorpertyValues <T>(values, flags));
}
