Exemplo n.º 1
0
        private XLWorkbook WriteDispatchData(XLWorkbook workbook)
        {
            XLWorkbook result;

            result = workbook;

            dispatchDetails = dataHandler.BindDispatchDetails();
            Logger.Trace("DataTable complete, found {0} rows", dispatchDetails.Rows.Count);

            var worksheet = result.Worksheet("Dispatch Data");

            worksheet.Clear();
            Logger.Trace("Data worksheet cleared");

            worksheet.Cell(1, 1).InsertTable(dispatchDetails, "dispatchDetails", false);
            Logger.Trace("Data worksheet populated");

            return(result);
        }