public bool CreateEmpty(string workSheetName, string fileName)
{
try {
using (ExcelPackage pck = new ExcelPackage(new FileInfo(fileName))) {
ExcelWorksheet ws = pck.Workbook.Worksheets.Add(workSheetName);
ws.Cells["A1"].Value = "";
pck.Save();
}
} catch (Exception e) {
Debug.WriteLine(e.Message);
ExcelReaderEventHub.OnSaveError(null, new ExcelSaveErrorEventArgs(fileName, e.Message, e.StackTrace));
OnSaveError(null, new ExcelSaveErrorEventArgs(fileName, e.Message, e.StackTrace));
}
return(true);
}
public void SaveBase <T>(string fileName, IEnumerable <T> result, Action <ExcelPackage, DataTable> opt)
{
try {
var i = 1;
var parts = result.SplitList(800000).ToList();
foreach (var prt in parts)
{
try {
if (i > 1)
{
var filInfo = new FileInfo(fileName);
var dir = filInfo.Directory;
var name = filInfo.Name;
fileName = $"{dir}\\Part_{i}_{name}";
}
Console.WriteLine($"Salvando {fileName}...");
var json = JsonConvert.SerializeObject(prt, Formatting.Indented);
DataTable dt = (DataTable)JsonConvert.DeserializeObject(json, (typeof(DataTable)));
using (ExcelPackage pck = new ExcelPackage(new FileInfo(fileName))) {
opt.Invoke(pck, dt);
pck.Save();
}
Console.WriteLine($"{fileName} foi salvo!!");
} catch (Exception e) {
Console.WriteLine(e.Message);
ExcelReaderEventHub.OnSaveError(null, new ExcelSaveErrorEventArgs(fileName, e.Message, e.StackTrace));
OnSaveError(null, new ExcelSaveErrorEventArgs(fileName, e.Message, e.StackTrace));
}
i++;
}
} catch (Exception e) {
Console.WriteLine($"Um erro ocorreu: {e.Message}");
ExcelReaderEventHub.OnSaveError(null, new ExcelSaveErrorEventArgs(fileName, e.Message, e.StackTrace));
OnSaveError(null, new ExcelSaveErrorEventArgs(fileName, e.Message, e.StackTrace));
}
}
public bool SaveBase <T>(IEnumerable <T> result, string workSheetName, string fileName)
{
try {
DataTable dt = result.ToDataTable();
using (ExcelPackage pck = new ExcelPackage(new FileInfo(fileName))) {
ExcelWorksheet ws = pck.Workbook.Worksheets.Add(workSheetName);
ws.Cells["A1"].LoadFromDataTable(dt, true);
pck.Save();
}
} catch (Exception e) {
Debug.WriteLine(e.Message);
ExcelReaderEventHub.OnSaveError(null, new ExcelSaveErrorEventArgs(fileName, e.Message, e.StackTrace));
OnSaveError(null, new ExcelSaveErrorEventArgs(fileName, e.Message, e.StackTrace));
}
return(true);
}
