public void ExportBetDetail()
{
var criteria = new ExportExcelCriteria
{
SheetName = "BetDetail",
FileName = "BetDetail.xlsx",
ColumnWidths = new[] { 15, 20, 20, 20 },
Data = repository.SelectBetDetails(new SelectBetDetailsCriteria())
};
var exporter = new GenericExcelService(criteria);
exporter.Export();
}
public static void Export()
{
var testData = new List <dynamic>
{
new { trans_id = 1, vendor_member_id = "a1", winlost_amount = 10, stake = 10 },
new { trans_id = 2, vendor_member_id = "a2", winlost_amount = 10, stake = 10 },
new { trans_id = 3, vendor_member_id = "a3", winlost_amount = 10, stake = 10 }
};
var exporter = new GenericExcelService(new ExportExcelCriteria
{
SheetName = "Sheet1",
FileName = "Sample.xlsx",
ColumnWidths = new[] { 15, 20, 20, 20 },
Data = testData
});
exporter.Export();
}
