public class ReportHelper
extends java.lang.Object
Constructor and Description |
---|
ReportHelper(java.lang.String awsKey,
java.lang.String awsSecret,
java.lang.String emailBody,
java.lang.String emailSubject,
java.lang.String fromEmail,
boolean debugmode,
java.lang.String alsoSendTo) |
Modifier and Type | Method and Description |
---|---|
org.apache.poi.ss.usermodel.Sheet |
autoSizeAllCellsExceptForDescription(org.apache.poi.ss.usermodel.Sheet sheet,
int descriptionIndex) |
java.io.ByteArrayOutputStream |
generateExcel(java.util.List<InventoryUsageDTO> reportList) |
void |
sendEmail(java.io.ByteArrayOutputStream bytestream,
java.util.Set<java.lang.String> toset,
java.lang.String site) |
void |
underlineCellsInARow(org.apache.poi.ss.usermodel.Row row,
org.apache.poi.ss.usermodel.Workbook wb,
java.lang.Boolean bold,
org.apache.poi.ss.usermodel.Font boldfont) |
public ReportHelper(java.lang.String awsKey, java.lang.String awsSecret, java.lang.String emailBody, java.lang.String emailSubject, java.lang.String fromEmail, boolean debugmode, java.lang.String alsoSendTo)
public java.io.ByteArrayOutputStream generateExcel(java.util.List<InventoryUsageDTO> reportList)
public void underlineCellsInARow(org.apache.poi.ss.usermodel.Row row, org.apache.poi.ss.usermodel.Workbook wb, java.lang.Boolean bold, org.apache.poi.ss.usermodel.Font boldfont)
public org.apache.poi.ss.usermodel.Sheet autoSizeAllCellsExceptForDescription(org.apache.poi.ss.usermodel.Sheet sheet, int descriptionIndex)
public void sendEmail(java.io.ByteArrayOutputStream bytestream, java.util.Set<java.lang.String> toset, java.lang.String site)