protected void TOC(string TName, string Rem = "Added")
{
TocWS.Cell(Row, 1).Value = (++SN);
TocWS.Cell(Row, 2).Value = TName;
TocWS.Cell(Row, 3).Value = Rem;
Row++;
}
protected void TOC(string TName, string Rem = "Uploaded")
{
TocWS.Cell(Row, 6).Value = (++SN);
TocWS.Cell(Row, 7).Value = TName;
TocWS.Cell(Row, 8).Value = Rem;
TocWS.Cell(Row, 9).Value = DateTime.Now;
Row++;
}
private XLWorkbook GetWorkBook(string Title, string path)
{
var WBs = new XLWorkbook();
WBs.Author = "eStore: AKS Labs";
TocWS = WBs.Worksheets.Add("TableOfContent");
TocWS.Cell(1, 4).Value = "Aprajita Retails";
TocWS.Cell(2, 4).Value = "Data Exporting";
TocWS.Cell(4, 4).Value = Title;
TocWS.Cell(5, 3).Value = "Date";
TocWS.Cell(5, 4).Value = DateTime.Now;
TocWS.Cell(7, 4).Value = "Table Of Contents";
TocWS.Cell(8, 1).Value = "SNo";
TocWS.Cell(8, 1).Value = "TableName";
TocWS.Cell(8, 2).Value = "SheetName";
TocWS.Cell(8, 1).Value = "Remarks";
WBs.SaveAs(Path.Combine(path, $"{Title}_ {DateTime.UtcNow.ToFileTimeUtc().ToString()}.xlsx"));
return(WBs);
}