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); }