protected void DownloadButton_Click(object sender, EventArgs e) { string file = string.Format("{0}-SchoolCrosswalk.xlsx", DateTime.Now.ToString("yyyyMMdd")); CreateExcelFile.CreateExcelDocument(DAL.SchoolCrosswalk.GetExport(), file, Response); }
public void ExportData() { var sid = int.Parse(SID.SelectedValue); string SourceType = string.Empty; int SourceID = 0; int SchoolID = 0; if (ddSource.SelectedValue == "0") { SourceType = string.Empty; SourceID = 0; } else { string[] stringSeparators = new string[] { "_|_" }; var arr = ddSource.SelectedValue.Split(stringSeparators, StringSplitOptions.None); SourceType = arr[0]; SourceID = int.Parse(arr[1]); } int.TryParse(ddSchool.SelectedValue, out SchoolID); var ds = DAL.SurveyResults.GetExport(sid, SourceType, SourceID, SchoolID); string excelFilename = Server.MapPath("~/SurveyOrTestResultsExport.xlsx"); CreateExcelFile.CreateExcelDocument(ds, excelFilename); Response.ContentType = "application/vnd.ms-excel"; Response.AppendHeader("Content-Disposition", "attachment; filename=SurveyOrTestResultsExport.xlsx"); EnableViewState = false; Response.BinaryWrite(File.ReadAllBytes(excelFilename)); File.Delete(excelFilename); Response.End(); }
public DataTable GetLocalAccountsInfo() { _localAccounts = new LocalAccountService(_scope, _options); var localAccountsList = _localAccounts.GetAllLocalAccounts(); return(CreateExcelFile.ListToDataTable(localAccountsList, "Local Accounts")); }
protected void btnExportExcel_Click(object sender, EventArgs e) { var payableProvider = new PayableProvider(); var DataSource = payableProvider.GetResultPayables().ToList(); var CollectionsListData = from payableModel in DataSource select new PayableDurationModel { JournalID = payableModel.JournalID, JournalNo = payableModel.JournalNo, ApplicationNo = payableModel.ApplicationNo, ProcessingDays = payableProvider.CalculateProcessDay((DateTime)payableModel.PaymentDate, payableModel.CreateDate), LatePayment = payableProvider.IsPaymentlate(payableModel.CreateDate) }; var FileName = "PaymentDurationData.xlsx"; var memoryStream = new MemoryStream(); CreateExcelFile.CreateExcelDocument(CollectionsListData.ToList(), memoryStream, "Payment Durations Report"); HttpResponse httpresponse = HttpContext.Current.Response; httpresponse.ClearContent(); httpresponse.ClearHeaders(); httpresponse.Buffer = true; httpresponse.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; httpresponse.AddHeader("content-Disposition", "attachment;filename=\"" + FileName); httpresponse.BinaryWrite(memoryStream.ToArray()); httpresponse.Flush(); httpresponse.End(); }
protected void DownloadReport_Click(object sender, EventArgs e) { ReportPanel.Visible = true; AlertPanel.Visible = false; try { var ds = PrepareReport(); if (ds.Tables != null && ds.Tables.Count >= 1 && ds.Tables[0].Rows.Count != 0) { ds.Tables[0].TableName = ReportName; CreateExcelFile.CreateExcelDocument( ds, string.Format("{0}.xlsx", ReportName.Replace(" ", string.Empty)), Response); } } catch (Exception ex) { ReportPanel.Visible = false; AlertPanel.Visible = true; AlertMessage.Text = ex.Message; } }
public DataTable GetPrintersInfo() { _printers = new PrintersService(_scope, _options); var printerNamesList = _printers.GetPrinters(); return(CreateExcelFile.ListToDataTable(printerNamesList, "Printers")); }
public DataTable GetServicesInfo() { _services = new ServicesService(_scope, _options); var serviceNamesList = _services.GetAllServices(); return(CreateExcelFile.ListToDataTable(serviceNamesList, "Services")); }
public async Task <IHttpActionResult> ExportMediaNewsToExcel(MediaSearchModel model) { var userId = User.Identity.GetUserId <int>(); DateTime?fromDate = null, toDate = null; string pathnew = Request.RequestUri.AbsolutePath; if ((!String.IsNullOrEmpty(model.startDate))) { fromDate = DateTime.ParseExact(model.startDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); } if ((!String.IsNullOrEmpty(model.endDate))) { toDate = DateTime.ParseExact(model.endDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); } var taskResult = repository.GeMediaListAll(userId, model.mediaTypeId, model.newsTypeIds, model.channelIds, model.categoryIds, model.sentimentIds, model.relevanceIds, model.createdBy, model.script, fromDate, toDate); var excelData = taskResult.MediaFormList; string baseUrl = ""; string excelFilename = "MediaNews" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + DateTime.Now.Millisecond + ".xls"; string SaveLocation = HttpContext.Current.Request.PhysicalApplicationPath + "Files\\" + excelFilename; DataTable dt = CreateExcelFile.ListToDataTable(excelData); CreateExcelFile file = new CreateExcelFile(); string detail = file.CreateExcelSheet(dt, SaveLocation, new List <int>(), new List <int>(), new List <string>()); baseUrl = "Files/" + excelFilename; return(Ok(baseUrl)); }
public void showStuff(DataSet ds) { //// baz kardane dialoge save Microsoft.Win32.SaveFileDialog dlg = new Microsoft.Win32.SaveFileDialog(); dlg.FileName = ""; // Default file name dlg.DefaultExt = ".xls"; // Default file extension dlg.Filter = "Excel Document (.xls)|*.xls"; // Filter files by extension Nullable <bool> result = dlg.ShowDialog(); string filename = ""; if (result == true) { filename = dlg.FileName; // Step 2: Create the Excel .xlsx file try { bool b = CreateExcelFile.CreateExcelDocument(ds, filename); } catch (Exception ex) { MessageBox.Show("Couldn't create Excel file.\r\nException: " + ex.Message); return; } } //// -- }
public ActionResult ExportToExcel(Enumerations.ExcelExport id = Enumerations.ExcelExport.ALL) { try { IAdminService adminService = new AdminService(); var listofMemberships = adminService.GetMemberships(null).ToList(); IUserService userService = new UserService(); var members = userService.GetMembers(null, null, true); if (id == Enumerations.ExcelExport.ALL) { } var memberlist = members. Select(group => new { memberid = group.MemberId, name = group.TitleFullname, Age = group.Age, DateOfBirth = group.DateOfBirth, Town = group.Town, Mobile = group.MobilePhone, Phone = group.HomePhone, Office = group.OfficePhone, Email = group.EmailAddress, NumVisits = group.NumberVisits, LastVisit = group.LastVisit, Membership = group.Membership.Name, HasArrears = (group.HasArrears?"Yes":"No"), LongOverdue = (group.IsLongOverdue ? "Yes" : "No"), Birthday = (group.IsBirthday ? "Yes" : "No"), IsActive = (group.IsActive ? "Yes" : "No"), LastOrNextPaymentDate = group.PaymentUntilDate, DuetoDate = (group.HasArrears?group.AmountDueToDate:0) }).ToList(); var Dt = DateTime.Now; ContentResult excel = new ContentResult(); var target = ConfigurationHelper.GetReportFolder() + "Members as at " + Dt.ToString("dd-MMM-yyyy-HHmmss") + ".xlsx"; ViewBag.Target = target; CreateExcelFile.CreateExcelDocument(memberlist, target); return(View()); } catch (Exception e) { log.Error("ExportToExcel] - Exception Caught" + e.ToString()); TempData["errorLog"] = new ErrorLog(e); return(RedirectToAction("Error", "Home")); } }
protected void DownloadReport_Click(object sender, EventArgs e) { ReportPanel.Visible = true; AlertPanel.Visible = false; try { var ds = PrepareReport(); if (ds.Tables != null && ds.Tables.Count >= 1 && ds.Tables[0].Rows.Count != 0) { ds.Tables[0].TableName = "Events+Codes"; CreateExcelFile.CreateExcelDocument( ds, string.Format("{0}-{1}-EventCodes.xlsx", LibraryDistrictList.SelectedItem.Text.Replace(" ", string.Empty), LibraryBranchList.SelectedItem.Text.Replace(" ", string.Empty)), Response); } } catch (Exception ex) { ReportPanel.Visible = false; AlertPanel.Visible = true; AlertMessage.Text = ex.Message; } }
public JsonResult GenerateSpreadsheet() { // Create temp path and file name var path = Server.MapPath("~/temp"); var fileName = "Spreadsheet.xlsx"; // Create temp path if not exits if (Directory.Exists(path) == false) { Directory.CreateDirectory(path); } // Create the sample DataSet DataSet dataSet = new System.Data.DataSet("Hospital"); dataSet.Tables.Add(Table()); // Create the Excel file in temp path string fullPath = Path.Combine(path, fileName); //CreateExcelFile cef = new CreateExcelFile(); CreateExcelFile.CreateExcelDocument(dataSet, fullPath, includeAutoFilter: true); // Return the Excel file name return(Json(new { fileName = fileName, errorMessage = "" })); }
public void CreateExcelDoc() { SqlConnection connection = new SqlConnection(ConnectionString); SqlDataAdapter sda = new SqlDataAdapter(sql, connection); DataSet dst = CreateSampleData(sda); //new DataSet(); SaveFileDialog savef = new SaveFileDialog(); savef.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*"; savef.FilterIndex = 1; if (savef.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { CreateExcelFile.CreateExcelDocument(dst, savef.FileName); if (ToOpen(savef.FileName) == DialogResult.Yes) { System.Diagnostics.Process.Start(savef.FileName); } } catch (Exception ex) { MessageBox.Show(ex.Message); return; } } }
public void ProcessAllFtp() { _ConnectionString = Helper.LoadConfigKeys("ConnectionString");// +";Integrated Security=SSPI; trusted_connection=Yes;"; try{ _processes = GetDataFromDb(); } catch (Exception ex) { LogObj.WriteLog("Failed Accessing DB for windows user identity " + WindowsIdentity.GetCurrent() + " error:" + ex.Message, enMsgType.enMsgType_Error, _LogPrefix, _AppLogDirectory); } _AppLogDirectory = Helper.GetMyDir(_ConnectionString); foreach (Process p in _processes) { string res = "For Upload ProcessID " + p.ID + " HostIP " + p.HostIP + ": "; LogObj.WriteLog(res, enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory); if (ValidInput(p)) { _results += res; p.LocalDir = _UploadFolder; //we change it to the user-selected folder ! FTPProcess ftp = new FTPProcess(p.RAM, p.HostIP, p.Port, p.Login, p.Password, p.RemoteDir, p.Pattern, _UploadFolder, p.PharmacyName, "not used here"); ftp.SetExcelTable(_tblExcel); IFtpType requiredTFtp = null; FtpFactory factory = new FtpFactory(); requiredTFtp = factory.CreateFtpFactory(p.FtpType, "upload", "", ""); res = ftp.ComputeFtp(requiredTFtp); _tblExcel = ftp.GetExcelTbl(); LogObj.WriteLog(res, enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory); _results += res; } // LogObj.WriteLog(res, enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory); _results += "\r\n"; } LogObj.WriteLog("Completed!", enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory); /* Create the Excel report */ try { if (_tblExcel == null) { throw new Exception("No Excel Report content was generated"); } CreateExcelFile.CreateExcelDocument(_tblExcel, _AppLogDirectory, _LogPrefix); } catch (Exception ex) { LogObj.WriteLog("Couldn't create Excel report. nException: " + ex.Message, enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory); } }
public DataTable GetSoftwareInfo() { _applications = new SoftwareService(_scope, _options); var softwareNamesList = _applications.GetAllSoftware(); var dt = CreateExcelFile.ListToDataTable(softwareNamesList, "Software"); DataView dv = dt.DefaultView; dv.Sort = "Name asc"; return(dv.ToTable()); }
public void ExportOperationsOld(int id) { //Create table for results var result = _exportService.ExportOperationsForEventOld(id); if (result != null) { CreateExcelFile.CreateExcelDocument(result.Table, result.Name + ".xlsx", System.Web.HttpContext.Current.Response); } }
protected ActionResult ExportToExcel <T>(FromToQuery query, List <T> list, ExportDefinition <T> exportDefinition, string prefix, Action <DataTable> postProcessDataTable = null) { var tempFile = Path.GetTempFileName(); CreateExcelFile.CreateExcelDocument(list, exportDefinition, tempFile, postProcessDataTable); return(File(System.IO.File.ReadAllBytes(tempFile), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", $"{prefix}-Export_{query.From:yyyyMMdd}-{query.To:yyyyMMdd}.xlsx")); }
//export data to excel private void btnOK_Click(object sender, EventArgs e) { Maticsoft.BLL.Patient patientBLL = new Maticsoft.BLL.Patient(); DataSet ds = patientBLL.GetAllListWithTitle(); ds.Tables[0].TableName = "患者信息"; //人口学数据 Maticsoft.BLL.Demographic demoBLL = new Maticsoft.BLL.Demographic(); DataTable dtDemo = demoBLL.GetAllListWithTitle().Tables[0].Copy(); dtDemo.TableName = "人口学数据"; //一般情况 Maticsoft.BLL.GeneralInfo geneBLL = new Maticsoft.BLL.GeneralInfo(); DataTable dtGene = geneBLL.GetAllListWithTitle().Tables[0].Copy(); dtGene.TableName = "一般情况"; ds.Tables.Add(dtDemo); ds.Tables.Add(dtGene); DialogResult result = this.folderBrowserDialog1.ShowDialog(); if (result == DialogResult.OK) { string foldername = this.folderBrowserDialog1.SelectedPath; try { if (cbTreatInfo.Checked || cbTreatInfoBadAction.Checked) { DataSet dsTreatInfo = GetTreatInfo(); CreateExcelFile.CreateExcelDocument(dsTreatInfo, foldername + @"\治疗情况.xlsx"); } if (cbCOPD.Checked || cbBlood.Checked || cbLung.Checked || cbDicom.Checked || cbChartis.Checked || cbSport.Checked) { DataSet dsBeforeTreatInfo = GetBeforeTreatInfo(); CreateExcelFile.CreateExcelDocument(dsBeforeTreatInfo, foldername + @"\治疗前基线指标.xlsx"); } CreateExcelFile.CreateExcelDocument(ds, foldername + @"\患者基本信息.xlsx"); MessageBox.Show("数据提取成功!"); if (File.Exists(foldername)) { Process.Start("explorer.exe", foldername); } } catch (Exception ex) { MessageBox.Show("Couldn't create Excel file.\r\nException: " + ex.Message); return; } // the code here will be executed if the user presses Open in // the dialog. } }
protected void btnExportToExcel_Click(object sender, EventArgs e) { if (GridView1.Caption == "ProfitAndLoss") { CreateExcelFile.CreateExcelDocument((List <ProfitAndLoss>)ViewState["ProfitAndLossData"], "D:\\ProfitAndLoss-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx"); } else { CreateExcelFile.CreateExcelDocument((List <SalesData>)ViewState["ListSalePurchase"], "D:\\" + GridView1.Caption + "-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx"); } }
public IHttpActionResult SaveFile(int id) { Survey survey = surveyService.GetWithResult(id); if (survey == null) { return(NotFound()); } survey.Questions.ToList().ForEach(q => { q.QuestionAnswers = q.QuestionAnswers.OrderBy(qa => qa.OrdinalNumber).ToList(); }); var users = surveyService.UsersWhoFilledSurvey(survey.Users.Select(u => u.UserId).ToList()); SurveyResultViewModel surveyVM = AutoMapper.Mapper.Map <Survey, SurveyResultViewModel>(survey); this.SetSurveyResultVMValues(surveyVM, survey, users, 0, true); using (var xlPackage = new ExcelPackage()) { var ws = xlPackage.Workbook.Worksheets.Add("Anketa: " + survey.Name); CreateExcelFile createEF = new CreateExcelFile(surveyService); if (!survey.Anonymous) { createEF.CreateSurveyWorksheet(ws, surveyVM); } createEF.CreateQuestionsOnSurveyWorksheet(ws, surveyVM); surveyVM.Questions.ToList().ForEach(q => { createEF.CreateQuestionWorksheet(xlPackage, q, surveyVM, survey); }); users.ForEach(u => { var answers = surveyService.GetAnswersForUser(u.Id).ToList(); createEF.CreateUserWorksheet(xlPackage, u, survey, answers, users.IndexOf(u)); }); ExcelFiles obj = new ExcelFiles() { Bytes = xlPackage.GetAsByteArray(), SurveyId = survey.Id, CreationDate = DateTime.Now, Name = survey.Name + DateTime.Now.ToString() + ".xlsx" }; surveyService.AddExcel(obj); unitOfWork.Commit(); } return(Ok()); }
private void BtnExel_Click(object sender, RoutedEventArgs e) { var entities = ak.Capitals.ToList(); var table = new System.Data.DataTable(); table.Columns.Add("شماره", typeof(int)); table.Columns.Add("تاریخ", typeof(string)); table.Columns.Add("مبلغ", typeof(string)); foreach (var entity in entities) { var row = table.NewRow(); row["شماره"] = entity.CNO; row["تاریخ"] = entity.CDate; row["مبلغ"] = entity.CTotalPrice; table.Rows.Add(row); } //// ------- DataSet ds = new DataSet("New_DataSet"); ds.Locale = System.Threading.Thread.CurrentThread.CurrentCulture; ds.Tables.Add(table); //// baz kardane dialoge save Microsoft.Win32.SaveFileDialog dlg = new Microsoft.Win32.SaveFileDialog(); dlg.FileName = ""; // Default file name dlg.DefaultExt = ".xls"; // Default file extension dlg.Filter = "Text documents (.xls)|*.xls"; // Filter files by extension Nullable <bool> result = dlg.ShowDialog(); string filename = ""; if (result == true) { filename = dlg.FileName; //ExcelLibrary.DataSetHelper.CreateWorkbook(filename, ds); // Step 2: Create the Excel .xlsx file try { bool b = CreateExcelFile.CreateExcelDocument(ds, filename); } catch (Exception ex) { MessageBox.Show("Couldn't create Excel file.\r\nException: " + ex.Message); return; } } //// --------- }
private void ExportarAExcel() { var a = this.columnas; SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.Filter = "Libro de Excel|.xlsx"; saveFileDialog1.Title = "Exportar a Excel"; saveFileDialog1.ShowDialog(); if (saveFileDialog1.FileName != "") { CreateExcelFile.CreateExcelDocument(Items.ToList(), saveFileDialog1.FileName); } }
private void ExecuteExportToExcel(object parameter) { try { CreateExcelFile c = new CreateExcelFile(); c.CreatePlaybookSheets(FailedTrials, NewSales, ScheduledTrials, ImportantProjects); } catch { IMessageBoxService _msg = new MessageBoxService(); _msg.ShowMessage("There was a problem creating the Excel report", "Unable to create Excel report", GenericMessageBoxButton.OK, GenericMessageBoxIcon.Error); } }
private void ExecuteExportToExcel(object parameter) { try { CreateExcelFile c = new CreateExcelFile(); c.CreateExcelSummaryReport(_datatable, _projectcountdatatable); } catch { IMessageBoxService _msg = new MessageBoxService(); _msg.ShowMessage("There was a problem creating the Excel report", "Unable to create Excel report", GenericMessageBoxButton.OK, GenericMessageBoxIcon.Error); } }
private void ExecuteExportToExcel(object parameter) { CreateExcelFile c = new CreateExcelFile(); if (Assets.Count > 0) { c.CreateExcelReport(MakeDTReport(Assets, "Duplicate Asset Labels")); } if (AssetsWithNoLocationInformation.Count > 0) { c.CreateExcelReport(MakeDTReport(AssetsWithNoLocationInformation, "Missing Location Data")); } }
private void ExportExcel(DataTable data) { string fileName; SaveFileDialog fileDialog = new SaveFileDialog() { Filter = "Excel files (*.xlsx)|*.xlsx" }; if (fileDialog.ShowDialog() == DialogResult.OK) { fileName = fileDialog.FileName; CreateExcelFile.CreateExcelDocument(data, fileName); } }
protected void btnExport_Click(object sender, EventArgs e) { var ds = GetReportData(); string excelFilename = Server.MapPath("~/FinisherStatsReportResults.xlsx"); CreateExcelFile.CreateExcelDocument(ds, excelFilename); Response.ContentType = "application/vnd.ms-excel"; Response.AppendHeader("Content-Disposition", "attachment; filename=FinisherStatsReportResults.xlsx"); EnableViewState = false; Response.BinaryWrite(File.ReadAllBytes(excelFilename)); File.Delete(excelFilename); Response.End(); }
private bool GenerarFacturacion() { string Reporte = "Listado para facturación"; string FileName = GetFileName(Reporte); if (CheckFile(FileName, Reporte)) { Facturaciones Facturaciones = new Facturaciones(); List <Facturacion> lstReporte = Facturaciones.Generar(semanaToReport); List <string> header = GetHeader(semanaToReport, "Listado para facturación"); string footer = lstReporte.Count.ToString() + " registros"; CreateExcelFile.CreateExcelDocument(lstReporte, Reporte, FileName, header.ToArray(), footer); return(true); } return(false); }
private bool GenerarSituacionBSPs() { string Reporte = "Situacion BSP"; string FileName = GetFileName(Reporte); if (CheckFile(FileName, Reporte)) { SituacionBSPs SituacionBSPs = new SituacionBSPs(); List <SituacionBSP> lstReporte = SituacionBSPs.Generar(semanaToReport); List <string> header = GetHeader(semanaToReport, "Situación BSP (Movimientos registrados en BSP y no en su sistema)"); string footer = lstReporte.Count.ToString() + " registros"; CreateExcelFile.CreateExcelDocument(lstReporte, Reporte, FileName, header.ToArray(), footer); return(true); } return(false); }
private bool GenerarReembolsos() { string Reporte = "Reembolsos"; string FileName = GetFileName(Reporte); if (CheckFile(FileName, Reporte)) { Reembolsos Reembolsos = new Reembolsos(); List <Reembolso> lstReporte = Reembolsos.Generar(semanaToReport); List <string> header = GetHeader(semanaToReport, "Reembolsos en BSP"); string footer = lstReporte.Count(x => x.BoletoNro != "TOTAL").ToString() + " registros"; CreateExcelFile.CreateExcelDocument(lstReporte, Reporte, FileName, header.ToArray(), footer); return(true); } return(false); }