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); }