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")); } }
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); } }
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(); }
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 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 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(); }
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 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 = "" })); }
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; } }
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 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"); } }
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 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 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); }
private bool GenerarOvers() { string Reporte = "Over"; string FileName = GetFileName(Reporte); if (CheckFile(FileName, Reporte)) { Overs Overs = new Overs(); List <Over> lstReporte = Overs.Generar(semanaToReport); List <string> header = GetHeader(semanaToReport, "Análisis de Over"); string footer = lstReporte.Count(x => x.Boleto != "TOTAL").ToString() + " registros"; CreateExcelFile.CreateExcelDocument(lstReporte, Reporte, FileName, header.ToArray(), footer); return(true); } return(false); }
private bool GenerarDiferencias() { string Reporte = "Diferencias"; string FileName = GetFileName(Reporte); if (CheckFile(FileName, Reporte)) { Diferencias Diferencias = new Diferencias(); List <Diferencia> lstReporte = Diferencias.Generar(semanaToReport); List <string> header = GetHeader(semanaToReport, "Diferencias de Boletos (BSP vs BackOffice)"); string footer = lstReporte.Count.ToString() + " registros"; CreateExcelFile.CreateExcelDocument(lstReporte, Reporte, FileName, header.ToArray(), footer); return(true); } return(false); }
private bool GenerarDebitos() { string Reporte = "Debitos"; string FileName = GetFileName(Reporte); if (CheckFile(FileName, Reporte)) { Debitos Debitos = new Debitos(); List <Debito> lstReporte = Debitos.Generar(semanaToReport); List <string> header = GetHeader(semanaToReport, "Notas de Débito en BSP"); string footer = lstReporte.Count(x => x.Nro != "TOTAL").ToString() + " registros"; CreateExcelFile.CreateExcelDocument(lstReporte, Reporte, FileName, header.ToArray(), footer); return(true); } return(false); }
private bool GenerarControlIVAs() { string Reporte = "Control IVA"; string FileName = GetFileName(Reporte); if (CheckFile(FileName, Reporte)) { ControlIVAs ControlIVAs = new ControlIVAs(); List <ControlIVA> lstReporte = ControlIVAs.Generar(semanaToReport); List <string> header = GetHeader(semanaToReport, "CONTROL IVA"); string footer = lstReporte.Count.ToString() + " registros"; CreateExcelFile.CreateExcelDocument(lstReporte, Reporte, FileName, header.ToArray(), footer); return(true); } return(false); }
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 GenerarBSPNroOPs() { string Reporte = "BSP-Op.Nro"; string FileName = GetFileName(Reporte); if (CheckFile(FileName, Reporte)) { BSPNroOPs BSPNroOPs = new BSPNroOPs(); List <BSPNroOP> lstReporte = BSPNroOPs.Generar(semanaToReport); List <string> header = GetHeader(semanaToReport, "BSP + Nro OP"); string footer = lstReporte.Count.ToString() + " registros"; CreateExcelFile.CreateExcelDocument(lstReporte, Reporte, FileName, header.ToArray(), footer); return(true); } return(false); }
private string saveExcelFile(DataTable dt, string fileName) { string appPath = HttpContext.Current.Request.ApplicationPath; string physicalPath = HttpContext.Current.Request.MapPath(appPath).TrimEnd('\\'); string folderName = string.Format("{0}", Guid.NewGuid()); string outputFolder = string.Format("{0}\\output\\{1}", physicalPath, folderName); if (!Directory.Exists(outputFolder)) { Directory.CreateDirectory(outputFolder); } string fileNamePath = string.Format("{0}\\{1}.xlsx", outputFolder, fileName); CreateExcelFile.CreateExcelDocument(dt, fileNamePath); return(string.Format("{0}/{1}.xlsx", folderName, fileName)); }
//use to process through all download-processes in the db and then FTP the files. public void ProcessAllFtp(int hrsGoBack) { _ConnectionString = Helper.LoadConfigKeys("ConnectionString"); // + // ";Integrated Security=SSPI; trusted_connection=Yes;"; _SshHostKeyFingerPrint = Helper.LoadConfigKeys("SshHostKeyFingerPrint"); //not used anymore. _processes = GetDataFromDb(); _AppLogDirectory = Helper.GetMyDir(_ConnectionString); foreach (Process p in _processes) { string res = "For Download ProcessID " + p.ID + " HostIP " + p.HostIP + ": "; LogObj.WriteLog(res, enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory); if (ValidInput(p)) { _results += res; FTPProcess ftp = new FTPProcess(p.RAM, p.HostIP, p.Port, p.Login, p.Password, p.RemoteDir, p.Pattern, p.LocalDir, p.PharmacyName, ""); ftp.NumDaysGoback(hrsGoBack); ftp.SetExcelTable(_tblExcel); //ftp.SetFingerPnt(_SshHostKeyFingerPrint); // we not passing the fingerprint, can ascertain it at time of fileDownload. IFtpType requiredTFtp = null; FtpFactory factory = new FtpFactory(); requiredTFtp = factory.CreateFtpFactory(p.FtpType, "download", p.RAM, p.Pattern); res = ftp.ComputeFtp(requiredTFtp); _tblExcel = ftp.GetExcelTbl(); LogObj.WriteLog(res, enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory); _results += res; } } /* Create the Excel report */ LogObj.WriteLog("Completed!", enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory); try { CreateExcelFile.CreateExcelDocument(_tblExcel, _AppLogDirectory, _LogPrefix); } catch (Exception ex) { LogObj.WriteLog("Couldn't create Excel report. nException: " + ex.Message, enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory); } }
public ActionResult CSVExport([DataSourceRequest] DataSourceRequest request) { var filtered = _db.ProductSkuMaps.AsQueryable().ToDataSourceResult(request); var shops = LS.Get <Shop>(); var products = LS.Get <ProductSmall>( "ProductSmall", false, () => { return(_db.Products.AsNoTracking() .Select(x => new ProductSmall() { ID = x.ID, Image = x.Image, Name = x.Name, SKU = x.SKU }) .ToList()); }, "Product" ).AsQueryable(); var neededData = (filtered.Data as IEnumerable <ProductSkuMap>) .Select(x => new { ProductName = products.Any(y => y.SKU == x.ProductSKU) ? products.FirstOrDefault(y => y.SKU == x.ProductSKU).Name : "", x.ImportProductName, x.Imported, x.ShortSKU, x.ProductSKU, x.Price, x.Quantity, x.ShopID, ShopName = shops.Any(y => y.ID == x.ShopID) ? shops.FirstOrDefault(y => y.ID == x.ShopID).Name : "" }) .ToList(); byte[] bytes = null; bytes = CreateExcelFile.CreateExcelDocument( neededData, "ProductSkuMaps_" + DateTime.Now.ToString() + ".xlsx" , HttpContext.Response); return(File(bytes , "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" , "ProductSkuMaps_" + DateTime.Now.ToString() + ".xlsx")); }
public static void DatasetStatisticsToCSV(string path, MainForm form) { System.Data.DataTable DatasetAsCSV = new System.Data.DataTable("Statistics"); DatasetAsCSV.Columns.Add("Class", typeof(string)); DatasetAsCSV.Columns.Add("No. Files", typeof(int)); int _NumberOf_Directory = Directory.GetDirectories(@path).Count(); int i = 0; foreach (var directory in Directory.GetDirectories(@path, "*.txt", SearchOption.AllDirectories)) { DatasetAsCSV.Rows.Add(directory.Split('\\').Last(), Directory.GetFiles(directory).Count()); form.setProgressValue(((i + 1) * 100) / _NumberOf_Directory, i + 1, _NumberOf_Directory); i++; } CreateExcelFile.CreateExcelDocument(DatasetAsCSV, @path + "Dataset Statistics.xlxs"); }