public async Task <string> ExcelExport(string langId) { AppSettings.SetSiteLanguage(langId); var parentDirectory = Directory.GetParent(Environment.CurrentDirectory).FullName; var fileName = string.Format("OperatingRooms_{0}.xlsx", Guid.NewGuid().ToString()); FileStream fs = new FileStream(Path.Combine(parentDirectory, "Surgicalogic.Web", "static", fileName), FileMode.CreateNew); var excelService = new ExcelDocumentService(); var items = await _operatingRoomStoreService.GetExportAsync <OperatingRoomExportModel>(); await excelService.WriteAsync(fs, "Worksheet", items, typeof(OperatingRoomExportModel), System.Globalization.CultureInfo.CurrentCulture); return(fileName); }
public async Task <string> ExcelExport(string langId) { AppSettings.SetSiteLanguage(langId); var parentDirectory = Directory.GetParent(Environment.CurrentDirectory).FullName; var fileName = string.Format("Equipments_{0}.xlsx", Guid.NewGuid().ToString()); FileStream fs = new FileStream(Path.Combine(parentDirectory, "Surgicalogic.Web", "static", fileName), FileMode.CreateNew); var excelService = new ExcelDocumentService(); var items = await _equipmentStoreService.GetExportAsync <EquipmentExportModel>(); foreach (var item in items) { item.IsPortable = item.IsPortable == "+" ? Resources.Resource.Yes : Resources.Resource.No; } await excelService.WriteAsync(fs, "Worksheet", items, typeof(EquipmentExportModel), System.Globalization.CultureInfo.CurrentCulture); return(fileName); }
public async Task WriteToFile(string filePath, string worksheetName, ExcelModel[] excelModels, CultureInfo cultureInfo) { await excelDocumentService.WriteAsync(filePath, worksheetName, excelModels, cultureInfo); }