public static Sheet VoucherStatementTemplate(VoucherStatementPageResult result)
{
ExcelReportBuilder builder = new();
Sheet sheet = new("RemainReport");
sheet.IsLocked = false;
var row = builder.AddRow(new List <string> {
"کد حساب", "بدهکار", "بستانکار"
}, new RowPropertyOptions(new Location("A", 3)));
var cell = builder.AddCell(result.ReportName, "ReportName",
new CellsPropertyOptions(new Location("H", 1)));
var table = builder.AddTable(result.RowResult, new TablePropertyOptions(new Location("A", 4)));
var currentLocation = table.NextVerticalLocation;
var row2 = builder.AddRow(new List <string> {
"کد حساب", "بدهکار", "بستانکار"
}, new RowPropertyOptions(currentLocation));
currentLocation = row2.NextVerticalLocation;
var table2 = builder.AddTable(result.RowResult, new TablePropertyOptions(currentLocation));
currentLocation = table2.NextVerticalLocation;
var accountheader = TableTemplates.AccountHeader(currentLocation);
currentLocation = accountheader.NextVerticalLocation;
var accounts = TableTemplates.Accounts(result.Accounts, currentLocation);
currentLocation = accounts.NextHorizontalLocation;
currentLocation = new Location(currentLocation.X, currentLocation.Y - 3);
var multiplexHeader = TableTemplates.Multiplex(result.SummaryAccounts, currentLocation);
Border border = new(LineStyle.Thick, Color.Black);
row.BackColor = Color.Gray;
row2.BackColor = Color.Gray;
table.InlineBorder = border;
table.OutsideBorder = border;
table2.InlineBorder = border;
table2.OutsideBorder = border;
sheet.Tables.Add(table);
sheet.Tables.Add(table2);
sheet.Tables.Add(accountheader);
sheet.Tables.Add(accounts);
sheet.Tables.Add(multiplexHeader);
sheet.Rows.Add(row);
sheet.Rows.Add(row2);
sheet.Cells.Add(cell);
ColumnProps column = new ColumnProps();
column.IsLocked = true;
column.ColumnNo = 1;
sheet.Columns = new List <ColumnProps> {
column
};
sheet.MergedCells.Add("A1:H2");
sheet.MergedCells.Add("L17:L18");
return(sheet);
}
public static ExcelGeneratedFileResult VoucherStatementExcelReport(VoucherStatementPageResult result)
{
var workBook = new WorkBook {
FileName = "FileName"
};
var sheet1 = SheetTemplates.VoucherStatementTemplate(result);
workBook.Sheets.Add(sheet1);
// Generate Excel from "WorkBook" instance
return(ExcelService.GenerateExcel(workBook));
}
public static string VoucherStatementExcelReportUrl(VoucherStatementPageResult result, string basePath, string excelName)
{
var workBook = new WorkBook {
FileName = "FileName"
};
var sheet1 = SheetTemplates.VoucherStatementTemplate(result);
workBook.Sheets.Add(sheet1);
// Generate Excel from "WorkBook" instance
return(ExcelService.GenerateExcel(workBook, basePath, excelName));
}
public IActionResult ExportExcel()
{
var arg = new VoucherStatementPageResult
{
ReportName = "TestReport",
SummaryAccounts = new List <SummaryAccount>
{
new SummaryAccount
{
AccountName = "کارخانه دان-51011",
Multiplex = new List <Multiplex>
{
new Multiplex {
After = 5000000, Befor = 4000
},
},
},
new SummaryAccount
{
AccountName = "پرورش پولت-51018",
Multiplex = new List <Multiplex>
{
new Multiplex {
After = 5000000, Befor = 4000
},
},
},
new SummaryAccount
{
AccountName = "تخم گزار تجاری-51035",
Multiplex = new List <Multiplex>
{
new Multiplex {
After = 5000000, Befor = 4000
},
},
}
},
Accounts = new List <AccountDto>
{
new AccountDto
{
Name = "حقوق پایه",
Code = "81010"
},
new AccountDto
{
Name = "اضافه کار",
Code = "81011"
},
},
RowResult = new List <VoucherStatementRowResult>
{
new VoucherStatementRowResult
{
AccountCode = "13351",
Credit = 50000,
Debit = 0
},
new VoucherStatementRowResult
{
AccountCode = "21253",
Credit = 0,
Debit = 50000
},
new VoucherStatementRowResult
{
AccountCode = "13556",
Credit = 1000000,
Debit = 0
},
new VoucherStatementRowResult
{
AccountCode = "13500",
Credit = 1000000,
Debit = 0
},
new VoucherStatementRowResult
{
AccountCode = "13499",
Credit = 2000000,
Debit = 0
},
new VoucherStatementRowResult
{
AccountCode = "22500",
Credit = 0,
Debit = 4000000
}
}
};
var result2 = ExcelReportGenerator.VoucherStatementExcelReport(arg);
var result22Url = ExcelReportGenerator.VoucherStatementExcelReportUrl(arg, @"E:\TestFolder", "MyCustomName");
var result = ExcelReportGenerator.TestReport();
return(Ok(result22Url));
}
