public async Task <BaseResult> ExportToXlsx(SmartTableParam param)
{
var rs = new BaseResult()
{
Result = Result.Success
};
SmartTableResult <CityItem> cities = Search(param).Result;
List <CityItem> list = cities.Items.ToList();
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");
var workbook = new ExcelFile();
var worksheet = workbook.Worksheets.Add("Quản lí tỉnh, thành phố");
var style = worksheet.Rows[0].Style;
style.Font.Weight = ExcelFont.BoldWeight;
style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[0].Style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[2].Style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[3].Style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[4].Style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[5].Style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[0].SetWidth(50, LengthUnit.Pixel);
worksheet.Columns[1].SetWidth(150, LengthUnit.Pixel);
worksheet.Columns[2].SetWidth(150, LengthUnit.Pixel);
worksheet.Columns[3].SetWidth(150, LengthUnit.Pixel);
worksheet.Columns[4].SetWidth(150, LengthUnit.Pixel);
worksheet.Columns[5].SetWidth(150, LengthUnit.Pixel);
worksheet.Cells["A1"].Value = "ID";
worksheet.Cells["B1"].Value = "Tên Tỉnh/Thành Phố";
worksheet.Cells["C1"].Value = "Mã";
worksheet.Cells["D1"].Value = "Miền";
worksheet.Cells["E1"].Value = "Ngày Tạo";
worksheet.Cells["F1"].Value = "Ngày Cập Nhật";
worksheet.Tables.Add("Table1", "A1:F" + (list.Count + 1).ToString(), true);
for (int r = 1; r <= list.Count; r++)
{
var item = list[r - 1];
worksheet.Cells[r, 0].Value = item.Id;
worksheet.Cells[r, 1].Value = item.Name;
worksheet.Cells[r, 2].Value = item.Code;
worksheet.Cells[r, 3].Value = item.CityRealmStr;
worksheet.Cells[r, 4].Value = item.CreatedTimeDisplay;
worksheet.Cells[r, 5].Value = item.UpdatedTimeDisplay;
}
string fileName = "ExportFile.xlsx";
workbook.Save(fileName);
rs.Message = "Thành Công!";
return(rs);
}
public async Task <BaseResult> ExportToXlsx(SmartTableParam param)
{
var rs = new BaseResult()
{
Result = Result.Success
};
SmartTableResult <WareHouseItem> warehouses = Search(param).Result;
List <WareHouseItem> list = warehouses.Items.ToList();
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");
var workbook = new ExcelFile();
var worksheet = workbook.Worksheets.Add("Quản lí nhà kho");
var style = worksheet.Rows[0].Style;
style.Font.Weight = ExcelFont.BoldWeight;
style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[0].Style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[3].Style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[4].Style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[7].Style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[8].Style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
worksheet.Columns[0].SetWidth(50, LengthUnit.Pixel);
worksheet.Columns[1].SetWidth(200, LengthUnit.Pixel);
worksheet.Columns[2].SetWidth(200, LengthUnit.Pixel);
worksheet.Columns[5].SetWidth(150, LengthUnit.Pixel);
worksheet.Columns[6].SetWidth(150, LengthUnit.Pixel);
worksheet.Columns[7].SetWidth(150, LengthUnit.Pixel);
worksheet.Columns[8].SetWidth(150, LengthUnit.Pixel);
worksheet.Cells["A1"].Value = "ID";
worksheet.Cells["B1"].Value = "Tên Nhà Kho";
worksheet.Cells["C1"].Value = "Địa Chỉ";
worksheet.Cells["D1"].Value = "Vĩ Độ";
worksheet.Cells["E1"].Value = "Kinh Độ";
worksheet.Cells["F1"].Value = "SĐT Người Liên Hệ";
worksheet.Cells["G1"].Value = "Tên Người Liên Hệ";
worksheet.Cells["H1"].Value = "Ngày Tạo";
worksheet.Cells["I1"].Value = "Ngày Cập Nhật";
worksheet.Tables.Add("Table1", "A1:I" + (list.Count + 1).ToString(), true);
for (int r = 1; r <= list.Count; r++)
{
var item = list[r - 1];
worksheet.Cells[r, 0].Value = item.Id;
worksheet.Cells[r, 1].Value = item.Name;
worksheet.Cells[r, 2].Value = item.Address;
worksheet.Cells[r, 3].Value = item.Latitude;
worksheet.Cells[r, 4].Value = item.Longtitude;
worksheet.Cells[r, 5].Value = item.PhoneNumber;
worksheet.Cells[r, 6].Value = item.ContactName;
worksheet.Cells[r, 7].Value = item.CreatedTimeDisplay;
worksheet.Cells[r, 8].Value = item.UpdatedTimeDisplay;
}
string fileName = "ExportFile.xlsx";
workbook.Save(fileName);
rs.Message = "Thành Công!";
return(rs);
}
