public void GetUrl() { Assert.AreEqual("[[wikiuk:Хронологія історії України]]", ExcelManager.GetUrl("Вікіпедія.Хронологія історії України")); Assert.AreEqual( "[[wikiru:Генуэзские колонии в Северном Причерноморье]]", ExcelManager.GetUrl("Википедия.Генуэзские колонии в Северном Причерноморье")); }
public void Read() { var man = new ExcelManager(Path.Combine("Mw/Excel/Tests", "Крым реконструкция.xls")); man.Read(); Assert.AreEqual(377, man.Sheet.PhysicalNumberOfRows); }
/// <summary> /// 作用:下载项目洽谈表格 /// 作者:汪建龙 /// 编写时间:2017年1月16日19:53:26 /// </summary> /// <param name="name"></param> /// <param name="otherside"></param> /// <param name="minmoney"></param> /// <param name="maxmoney"></param> /// <param name="number"></param> /// <param name="year"></param> /// <param name="city"></param> /// <param name="town"></param> /// <param name="projecttype"></param> /// <param name="state"></param> /// <param name="payCompany"></param> /// <returns></returns> public ActionResult DownloadArticle( string name = null, string otherside = null, double?minmoney = null, double?maxmoney = null, string number = null, string year = null, string city = null, string town = null, string projecttype = null, string state = null, string payCompany = null) { var parameter = new ArticleParameter { Name = name, OtherSide = otherside, MinMoney = minmoney, MaxMoney = maxmoney, Number = number, Year = year, City = city, Town = town, ProjectType = projecttype, PayCompany = payCompany }; if (!string.IsNullOrEmpty(state)) { parameter.State = EnumHelper.GetEnum <ArticleState>(state); } var list = Core.ArticleManager.Search2(parameter); var workbook = ExcelManager.DownloadArticleWorkbook(list); if (workbook != null) { byte[] fileContents = ExcelManager.Translate(workbook); return(File(fileContents, "application/ms-excel", string.Format("项目洽谈统计表-{0}.xls", DateTime.Now.ToLongDateString()))); } return(Content("内部服务器错误!")); }
private void btnWriteHierarchyToExcel_Click(object sender, EventArgs e) { try { ExcelManager excelManager = new ExcelManager(); //method to read energy plus error message from files and generate excel file for the error messages Func <Files, bool> exclusionFilter = (Files f) => (f.hasChildren && (f.name.ToLower() == "bin" || f.name.ToLower() == "obj" || f.name.ToLower() == "properties" || f.name.ToLower() == ".vs" || f.name.ToLower() == "mymodules" || f.name.ToLower() == "prebuild_keepthisfirstinbuildorder" || f.name.ToLower() == "samplecode" || f.name.ToLower() == "thirdpartylibraries" || f.name.ToLower() == "packages" || f.name.ToLower() == "tests" || f.name.ToLower() == "templates" || f.name.ToLower() == "help" || f.name.ToLower() == "images" || f.name.ToLower() == "geomlibtests" )); excelManager.ExportDirectoryHierarchy(txtDirectoryPath.Text, txtExportPath.Text, exclusionFilter); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ActionResult importUser(HttpPostedFileBase file1) { if (file1 == null) { return(Content("0")); } try { var path = Server.MapPath("~/Files/") + file1.FileName; file1.SaveAs(path); ExcelManager ex = new ExcelManager(); DataSet ds = ex.Excel(path, "Sheet1"); var dt = ds.Tables[0]; dt.Columns.Add("ID", typeof(int)); dt.Columns.Add("State", typeof(int)); dt.Columns["ID"].SetOrdinal(0); DataBase db = new DataBase(); db.Bulk("ConstructionPersonnelTable", dt); } catch (Exception) { return(Content("-1")); } return(Content("1")); }
protected override Graphes GroupEventsByYear(ExcelManager man, Dictionary <string, string> legends = null, bool twoAndMoreEventtypes = false) { var result = new Graphes(legends, twoAndMoreEventtypes); foreach (HSSFRow row in man.Records) { for (int colGroup = 0; colGroup < 12; colGroup++) { var i = colGroup * 2; if (row.RowNum >= 3058 && colGroup >= 11 || row.RowNum >= 6663 && colGroup >= 10 || row.RowNum >= 8563 && colGroup >= 9 || row.RowNum >= 19683 && colGroup >= 8 || row.RowNum >= 25229 && colGroup >= 7 || row.RowNum >= 37180 && colGroup >= 6 || row.RowNum >= 45344 && colGroup >= 5 || row.RowNum >= 54304 && colGroup >= 4 ) { } else { var year = (int)row.Cells[i].NumericCellValue; var index = row.Cells[i + 1].ToString(); result.Add(year, index); } } } return(result); }
public override void ExecuteCommand(CancellationToken token) { Action <string> ok = new Action <string>(result => { int numRows = 0; if (!int.TryParse(result, out numRows)) { ShellManager.ShowMessageBox("Please input a valid number"); return; } numRows = Math.Max(numRows, 0); var selectedQuery = ShellManager.GetSelectedText(); QueryManager.Run(ConnectionManager.GetConnectionStringForCurrentWindow(), token, (queryManager) => { var ds = new DataSet(); FileInfo file = DialogManager.ShowExcelSaveFileDialog(); if (file == null) { return; } queryManager.Fill(selectedQuery, ds); ExcelManager.TableToExcel(ds, file); }); }); DialogManager.GetDialogInputFromUser("How many rows to select? (0=max)", "0", ok, cancelCallback); }
private int ImportExcelFileAndCreateTags(Languages excelSelectedLanguage, int categoryIndex, int tagNameIndex, int contentIndex) { LanguageFile newFile = new LanguageFile(m_englishFile, excelSelectedLanguage); List <LanguageFileEntry> excelEntries = ExcelManager.ImportExcelFileEntries(excelPath, categoryIndex, tagNameIndex, contentIndex); if (excelIgnoreHeaderLine) { excelEntries.RemoveAt(0); } //neue keys hinzufügen foreach (LanguageFileEntry entry in excelEntries) { if (!m_newTagList.Contains(entry.textTag)) { m_newTagList.Add(entry.textTag); } //Im EnglishFile nur Key hinzufügen, wenn noch nicht da m_englishFile.SetEntry(entry.textTag); newFile.SetEntry(entry.textTag, entry); } //neues file schreiben LocalizationManager.WriteNewLanguageFile(excelSelectedLanguage, newFile); //neues File reloaden, wenn ausgewählt if (m_loadedLanguage == excelSelectedLanguage) { m_secondLanguageFile = LocalizationManager.GetLanguageDataFromFile(excelSelectedLanguage); } return(excelEntries.Count); }
public async Task <IEnumerable <Dictionary <string, object> > > ExecuteSourceOperation(ActiveOperation ops) { // TODO // 1) Read file content from blob storage // 2> Return List from excel data var intermediateJson = JsonConvert.DeserializeObject <string>(ops.Content); var content = JsonConvert.DeserializeObject <ExcelDocument>(intermediateJson); using (var da = new DocumentDataAccess(_conStr)) { var doc = await da.Get(Convert.ToInt32(content.DocumentId)); if (doc != null) { var bs = new BlobStorageService(blobContainer); var blobContent = await bs.GetBlob(doc.WebUrl); var excelData = new ExcelManager().ExtractData(blobContent); return(excelData); } } return(null); }
public ActionResult Projects() { var stringKey = Identity.UserID + ParameterManager.ParameterKey; var parameter = SessionHelper.GetSession(stringKey) as ProjectParameter; if (parameter == null) { return(Content("未获取当前查询条件!")); } parameter.Page = null; var list = Core.ProjectManager.Search(parameter); if (list == null) { return(Content("查询项目信息失败!")); } IWorkbook workbook = ExcelManager.WriteCoProjects(list); if (workbook == null) { return(Content("生成表格失败!")); } var ms = new MemoryStream(); workbook.Write(ms); ms.Flush(); byte[] fileContents = ms.ToArray(); return(File(fileContents, ParameterManager.ExcelContentType, string.Format("项目清单-{0}.xls", DateTime.Now.ToString(ParameterManager.TimeContentType)))); }
public static void WriteOnly(string outFileName, List <string> content, WriteType type = WriteType.TEXT) { if (string.IsNullOrEmpty(CDNResourceMoveConfig.Instance().logOutPath) || !Directory.Exists(CDNResourceMoveConfig.Instance().logOutPath)) { Debug.LogError("write error !:" + CDNResourceMoveConfig.Instance().logOutPath); return; } string outputPath = CDNResourceMoveConfig.Instance().logOutPath + "/" + outFileName; string dir = Path.GetDirectoryName(outputPath); if (!Directory.Exists(dir)) { Directory.CreateDirectory(dir); } if (type == WriteType.EXCEL) { ExcelIns ei = ExcelManager.GetExcel(outputPath + ".xls"); ei.WriteSimpleList(content); //ei.GetWorkSheet(); } else { outputPath = outputPath + ".txt"; if (!File.Exists(outputPath)) { FileStream fs1 = new FileStream(outputPath, FileMode.Create, FileAccess.Write);//创建写入文件 fs1.Close(); } System.IO.File.WriteAllLines(outputPath, content.ToArray()); } }
protected virtual Graphes GroupEventsByYear( ExcelManager man, Dictionary <string, string> legends = null, bool twoAndMoreEventtypes = false) { var result = new Graphes(legends, twoAndMoreEventtypes); foreach (HSSFRow row in man.Records) { var indices = man.GetValue(row, "Индекс"); if (!string.IsNullOrEmpty(indices) && (!twoAndMoreEventtypes || indices.Split(IndicesSeparator).Count(i => !string.IsNullOrEmpty(i)) >= 2)) { if (legends != null) { var indicesFromLegend = new List <string>(); foreach (var index in indices.Split(IndicesSeparator)) { indicesFromLegend.Add(legends.ContainsKey(index) ? legends[index] : index); } indices = indicesFromLegend.Aggregate((a, b) => a + IndicesSeparator + b); } var eventOrYear = twoAndMoreEventtypes ? row.RowNum : int.Parse(man.GetValue(row, "-99000")); result.Add(eventOrYear, indices); } } return(result); }
public ActionResult FileLoadDraft(HttpPostedFileBase fileLoad) { if (fileLoad != null) { FileManager file = new FileManager(Server.MapPath("~/App_Data"), AreaName, ControllerName, fileLoad); file.Save(); ExcelManager excel = new ExcelManager(file.FullPath, 1); excel.ReadAll(); List <string> vs = new List <string>(); foreach (var row in excel.Rows) { if (row.Cell(1).Value.ToString().All(char.IsDigit)) { vs.Add(row.Cell(1).Value.ToString()); } } excel.Dispose(); MarkingCollection.IncomingPinsFile = vs.ToArray(); } IEnumerable <CleanPins> result = MarkingCollection.WithoutDraft; return(View("WriteDraft", result)); }
private static void Test1() { string storeLocation = @"C:\Users\ergis\Desktop\Test1.xls"; List <Customer> data = new List <Customer>() { new Customer { Id = 1, Name = "Test", Salary = 750d, BirthDate = DateTime.Now.AddYears(-18), IsActive = true }, new Customer { Id = 2, Name = "Test", Salary = 800f, BirthDate = DateTime.Now.AddYears(-20), IsActive = false } }; byte[] content = ExcelManager.GenerateExcel(data, new ExcelOptions { HeaderStyle = new HeaderStyle { IsBold = false }, BodyStyle = new BodyStyle { IsBordered = true } }); using (var fileStream = File.Create(storeLocation)) { fileStream.Write(content, 0, content.Length); } }
public static void Test_Read() { string location = @"C:\Users\ergis\Desktop\Test_read.xls"; string sheetName = "Sheet1"; var data = ExcelManager.ReadFromExcel <Customer>(location, sheetName, 1); }
// GET: Reservation/ExportOrders public ActionResult ExportOrders() { IViewerFactory <OrderView> factory = new OrderViewFactory(); var list = factory.Query(new Criteria(new { MenuDate = DateTime.Today, MenuType = (int)MenuDto.GetMenuLunchOrSupper(0, false) })); if (list != null && list.Count > 0) { var mapper = OrderDto.ConfigMapper().CreateMapper(); var orders = mapper.Map <IEnumerable <OrderDto> >(list.AsEnumerable()).ToList(); var book = ExcelManager.BuildOrderWorkbook(orders); byte[] file; using (var ms = new MemoryStream()) { book.Write(ms); file = ms.GetBuffer(); } return(File(file, "application/vnd.ms-excel", $@"今日订餐记录表-{DateTime.Today.ToString("yyyyMMdd")}.xls")); //return File(file, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", // $"今日订餐记录表-{DateTime.Today.ToString("yyyyMMdd")}.xlsx"); } return(RedirectToAction("TodayOrders", "Reservation")); }
public Testing() { //DBConnHelper dwHelper = new DBConnHelper(Constants.dwConnString); //DataSet dwDS = dwHelper.ExecQuery(Constants.stgQuery, 60); //System.Data.DataTable dwDT = dwDS.Tables[0]; //dwDT.TableName = "FactTable"; //dwDT.ConvertDBNull(); DBConnHelper uatHelper = new DBConnHelper("Constants.uatConnString"); DataSet uatDS = uatHelper.ExecQuery("Constants.uatQuery", 600); System.Data.DataTable uatDT = uatDS.Tables[0]; uatDT.TableName = "RRRTable"; uatDT.ConvertDBNull(); //System.Data.DataTable unionDT = dwDT.AsEnumerable().Union(uatDT.AsEnumerable(), DataRowComparer.Default).CopyToDataTable(); //unionDT.TableName = "UnionTable"; //System.Data.DataTable expDT = dwDT.AsEnumerable().Except(uatDT.AsEnumerable(), DataRowComparer.Default).CopyToDataTable(); //expDT.TableName = "EXPTable"; ExcelController.PivotTableConfig ptconfi = new ExcelController.PivotTableConfig(); ptconfi.PivotName = "Pivot_Testing"; ptconfi.PivotColumns = new System.Collections.ObjectModel.ObservableCollection<string>(); ptconfi.PivotColumns.Add("Scenario"); ptconfi.PivotRows = new System.Collections.ObjectModel.ObservableCollection<string>(); ptconfi.PivotRows.Add("Desk"); ptconfi.PivotRows.Add("Account"); ptconfi.PivotValues = new System.Collections.ObjectModel.ObservableCollection<string>(); ptconfi.PivotValues.Add("EffectiveDV01"); ptconfi.PivotValues.Add("Convexity"); ptconfi.PivotValues.Add("Duration"); IExcelManager em = new ExcelManager(); em.CreatePivot(uatDT, ptconfi); }
public ActionResult Import(string FileTable) { string Editor = Method.GetLogonUserId(Session, this, User.Identity.Name.ToUpper()); int i = 0; foreach (string file in Request.Files) { HttpPostedFileBase hpf = Request.Files[i] as HttpPostedFileBase; if (hpf.ContentLength == 0) { continue; } DataTable workTable = ExcelManager.getExcelSheetData(hpf); attachFileTable attachfiletable = db.attachFileTables.Where(x => x.FileTable == FileTable).FirstOrDefault(); string insert_Table = attachfiletable.TempTable; int ColumnsCount = attachfiletable.ColumnsCount; if (workTable.Columns.Count > ColumnsCount) { for (int c = ColumnsCount; c < workTable.Columns.Count; c++) { DataColumn removedc = workTable.Columns[c]; if (workTable.Columns.Count > ColumnsCount) { workTable.Columns.Remove(removedc); c--; } } } DAO.DatatableToSQL(Constant.ConnDBContext, workTable, insert_Table); workTable.Clear(); } return(View()); }
/// <summary> /// 导出数据到Excel表 导出的excel表为 .xls 格式 /// </summary> /// <returns></returns> public FileResult ExportData() { ExcelManager em = new ExcelManager(_memberBLL, _informationBLL, _followBLL, _followRecordBLL); MemoryStream ms = em.DataToExcel(System.Web.HttpContext.Current.Session["InformationList"] as List <InformationModel>); return(File(ms, "application/vnd.ms-excel", Guid.NewGuid().ToString() + ".xls")); }
public ActionResult ExportCheckLists(DateTime date) { using (IRepository repo = new Repository()) { var list = repo.Query <CheckList>(x => x.OperateDate >= date.AddDays(-2) && x.OperateDate <= date.AddDays(2)) .FindAll(x => x.OperateDate.Date == date.Date && x.IsActive); if (list.Count > 0) { var mapper = CheckListDto.ConfigMapper().CreateMapper(); var checklists = mapper.Map <IEnumerable <CheckListDto> >(list.AsEnumerable()).ToList(); var book = ExcelManager.BuildCheckListWorkbook(checklists, date); byte[] file; using (var ms = new MemoryStream()) { book.Write(ms); file = ms.GetBuffer(); } return(File(file, "application/vnd.ms-excel", $@"今日安全检查表-{date:yyyyMMdd}.xls")); } } return(RedirectToAction("CheckListManagement", "SecureNode", new { date })); }
// GET: Console/ExportReports public ActionResult ExportReports() { IViewerFactory <ReportView> factory = new ReportViewFactory(); var list = factory.Query(new Criteria(new { MenuDate = DateTime.Today, MenuType = (int)MenuDto.GetMenuLunchOrSupper(0, false) })); if (list != null && list.Count > 0) { var mapper = ReportDto.ConfigMapper().CreateMapper(); var reports = mapper.Map <IEnumerable <ReportDto> >(list.AsEnumerable()).ToList(); var book = ExcelManager.BuildReportWorkbook(reports); byte[] file; using (var ms = new MemoryStream()) { book.Write(ms); file = ms.GetBuffer(); } return(File(file, "application/vnd.ms-excel", $@"今日订餐统计表-{DateTime.Today:yyyyMMdd}.xls")); } return(RedirectToAction("Index", "Home")); }
public ActionResult AnalyzeFile() { if (Request.Files.Count == 0) { throw new ArgumentException("请选择上传文件"); } var file = HttpContext.Request.Files[0]; var fileName = file.FileName; if (string.IsNullOrEmpty(fileName)) { throw new ArgumentException("请选择上传文件"); } var filePath = FileManager.Upload(file); var list = ExcelManager.AnalyzeLand(filePath); Core.LandManager.AddRange(list, Identity.UserID); try { } catch { } return(RedirectToAction("Index")); }
public ActionResult Verify(DownloadEnum download) { var stringKey = Identity.UserID + ParameterManager.ParameterKey; var parameter = SessionHelper.GetSession(stringKey) as SheetVerifyParameter; //var parameter = RedisManager.Get<SheetVerifyParameter>(, RedisManager.Client); if (parameter == null) { return(Content("未获取查询条件!")); } var list = Core.VerifyViewManager.Search(parameter, true); if (list == null) { return(Content("未读取到报销单信息")); } IWorkbook workbook = ExcelManager.WriteVerify(list, download); if (workbook == null) { return(Content("创建表格失败!")); } var ms = new MemoryStream(); workbook.Write(ms); ms.Flush(); byte[] fileContents = ms.ToArray(); return(File(fileContents, ParameterManager.ExcelContentType, string.Format("{0} {1}.xls", download.GetDescription(), DateTime.Now.ToString(ParameterManager.TimeContentType)))); }
//汇总的表格要有项目编号、负责人、项目名称、研究周期、批复金额、余额 //批量导出,单个导出 #region 导出到Excel protected void Exp2Excel_Click(object sender, EventArgs e) { //str_sql = "exec Q_Lxjg "; str_sql = "select content from t_dict where flm= 14 and bm = 1"; str_sql = DBFun.ExecuteScalar(str_sql).ToString(); ExcelManager.Exp2Excel(this.Page, str_sql); }
// Загрузка файла недокомплекта Excel void btnLoadFromExcel_Click(object sender, RoutedEventArgs e) { try { var dlg = new OpenFileDialog { Filter = "Файлы Excel|*.xls" }; if (dlg.ShowDialog(this) != true) { return; } var rTemp = ExcelManager.LoadRequests(type, dlg.FileName); foreach (var r in rTemp) { var item = requests.SingleOrDefault(x => x.Name == r.Name && x.Article == r.Article && x.Type == type); if (item == null) { requests.Add(r); } else // если такой уже есть добавляем количество { item.TotalCount += r.TotalCount; } } } catch (Exception ex) { var msg = string.Format("Ошибка загрузки файла Excel: {0}", ex.Message); MessageBox.Show(msg, "Внимание", MessageBoxButton.OK, MessageBoxImage.Error); LogManager.LogError(unit, msg, ex); } }
private void OnStart() { ExcelManager.InitLoader(name => { Stream stream = null; var refSet = ResourcesManager.GetUnmanagedRefSet("configuration"); { var asset = ResourcesManager.LoadAsset <TextAsset>(name, refSet); stream = new System.IO.MemoryStream(asset.bytes); } refSet.Release(); return(stream); }); ExcelManager.LoadAll(); this.world = GBox.Make <IWorld>(); this.observer = this.world.AddSystem <MessageSystem>(); this.windowManager = this.world.AddSystem <WindowSystem>(); this.world.AddSystem <RenderSystem>(); this.world.AddSystem <CameraSystem>(); var room = this.world.AddSystem <RoomSystem>(); this.world.AddSystem <AudioSystem>(); this.game = this.world.CreateEntity(); var ctx = this.game.AddTrait <Context>(); ctx.World = this.world; ctx.Room = room; var machine = this.game.AddControl <StateMachine>(); machine.ChangeState(new LoginState()); }
public static void ExportEnfantToExcel(string FileName, int plaine) { ExcelManager ExcelManager = new ExcelManager(); string Query = $"SELECT Nom,Prenom,Tranche_age,Age,Date_Naissance,Email,N_National,Adresse,Fiche_Sante,MC,BIM,Prix,Nbr_jour,Lundi,Mardi,Mercredi,Jeudi,Vendredi FROM Enfant Where PlaineID ={plaine} "; ExcelManager.DataToExcel(DbToDataSet(Query), FileName); }
public static void ExportALLToExcel(string FileName, int plaine) { ExcelManager ExcelManager = new ExcelManager(); string Query = $"Select * from Enfant Where PlaineID ={plaine}"; ExcelManager.DataToExcel(DbToDataSet(Query), FileName); }
private void buttonOpenExcel_Click(object sender, EventArgs e) { buttonOpenExcel.Enabled = false; ExcelManager.Create(); ExcelManager.Fill(Tables, Titles, comboBoxQuarter.Text, comboBoxSubsidiary.Text); buttonOpenExcel.Enabled = true; ExcelManager.Open(); }
protected void Add_OK_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { string path = "~/UploadFiles/ExcelData/"; string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + FileUpload1.FileName; path += filename; if (Path.GetExtension(filename) == ".xls") { try { FileUpload1.PostedFile.SaveAs(Server.MapPath(path)); string excelResult = ExcelManager.CheckExcelData(Server.MapPath(path)); if (excelResult == "NullData") { string myscript = @"alert('数据导入失败!');window.location.href='EQState.aspx';"; Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true); } else { string splitflag = "."; string[] resultinfo = excelResult.Split(splitflag.ToCharArray(), System.StringSplitOptions.RemoveEmptyEntries); string insertsql = "Insert Into [EQ State] ([shortdate],[filepath]) values ('" + resultinfo[1] + "','" + path + "')"; if (resultinfo[0] == "ExistData") { insertsql = "Update [EQ State] Set [filepath]='" + path + "' where [shortdate]='" + resultinfo[1] + "'"; } try { DbManager.ExecuteNonQuery(insertsql); string myscript = @"alert('数据导入成功!');window.location.href='EQState.aspx';"; Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true); } catch { string myscript = @"alert('数据库操作失败!');window.location.href='EQState.aspx';"; Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true); } } } catch { string myscript = @"alert('文件上传失败!');window.location.href='EQState.aspx';"; Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true); } } else { ToolTips.Text = "文档格式必须为'.xls'!"; Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script> ShowDialog('Add_Dialog');</script>"); } } else { ToolTips.Text = "请选择数据文件!"; Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script> ShowDialog('Add_Dialog');</script>"); } }
public void ExportToExcel(SIMREG_NEWFORMSearchViewModel model) { //BOUser boUser = new BOUser(); BOSIMREG_NEWFORM boSim = new BOSIMREG_NEWFORM(); ExcelManager ex = new ExcelManager("SimRegisterReport.csv", false); System.Data.DataSet ds = new System.Data.DataSet(); //boSim.GetSIMREG_NEWFORMs(ds); boSim.GetSIMREG_NEWFORMs(model.MSISDNTITLE, model.REQUESTEDBYID, model.REQUESTEDBYID, model.DELIVEREDBYID, model.REQUESTEDDATE.ToString(), model.DELIVEREDBYDATE.ToString(), ds); ex.ExportData(ds.Tables[0], Response); }
protected void ExportCSVButton_Click(object sender, EventArgs e) { string strReportHtml = string.Empty; try { ExcelManager objExcelManager = new ExcelManager(); //string strParametersPath = this.Page.Server.MapPath("../Reports/Templates/"); // Pass the data and get the path for generated temporary file. // DataTable vdtData, string vstrfilePath, string vstrExportCaption, string vstrDBColumn, string vstrExcelColumn) if (null != ViewState["DataId"]) { string strRand = ViewState["DataId"].ToString(); if (null != this.Page.Session[strRand]) { DataTable dt = this.Page.Session[strRand] as DataTable; if ((null != dt) & (string.IsNullOrEmpty(ExportTemplatePath) == false) && (string.IsNullOrEmpty(ExportTemplate) == false) && (string.IsNullOrEmpty(DBColumn) == false) & (string.IsNullOrEmpty(ExcelColumn) == false)) { /*string strFilePath = objExcelManager.GenerateExcelDataFileFromGrid(dt, this.Page.Server.MapPath(ExportTemplatePath), ExportTemplate, ExportCaption, DBColumn, ExcelColumn, ExcelHeaderRow, StartRow, StartColumn, MaxLevel, SheetNumber, CurrentDateRow, CurrentDateCol, StartDateRow, StartDateCol, EndDateRow, EndDateCol, ReportStartDate, ReportEndDate);*/ string strFilePath = objExcelManager.GenerateCSVFileFromGrid(dt, this.Page.Server.MapPath(ExportTemplatePath), ExportTemplate, ExportCaption, DBColumn, ExcelColumn, ExcelHeaderRow, StartRow, StartColumn, MaxLevel, SheetNumber, CurrentDateRow, CurrentDateCol, StartDateRow, StartDateCol, EndDateRow, EndDateCol, ReportStartDate, ReportEndDate); System.IO.FileInfo objfInfo = new System.IO.FileInfo(strFilePath); if (objfInfo.Exists) { this.Page.Response.Clear(); string attachment = "attachment; filename=" + objfInfo.Name; this.Page.Response.AddHeader("content-disposition", attachment); //if (vExportType == Constants.ExportType.Excel) //{ this.Page.Response.ContentType = "text/csv"; //} //else //{ // Response.ContentType = "text/csv"; //} this.Page.Response.BinaryWrite(System.IO.File.ReadAllBytes(strFilePath)); objfInfo.Delete(); // Once the file content is written to response stream delete it. //Response.End(); } } } } } catch (Exception ex) { //throw; SendMail.MailMessage("ExcelPackage > Error > ExportCSVButton_Click(object sender, EventArgs e)", ex.ToString()); } finally { this.Page.Response.End(); } }
private void AddNewInputParametersLine(ExcelManager.CExcelManager.Parameter a_parameters) { Label label = new Label(); label.Width = inputWidth; label.Height = inputHeight; label.Padding = new Thickness(2); WrapPanel labelPanel = new WrapPanel(); labelPanel.Orientation = Orientation.Horizontal; labelPanel.Width = inputWidth; labelPanel.Height = inputHeight; AutoSuggestControl.AutoSuggestBox parameterKeyBox = new AutoSuggestControl.AutoSuggestBox(); parameterKeyBox.ListItemSelected += new RoutedPropertyChangedEventHandler<object>(parameterKeyBox_ListItemSelected); parameterKeyBox.InitOptionAutoSuggest(); parameterKeyBox.Width = textboxParameterKeyWidth; parameterKeyBox.Height = textboxHeight; Label labelSeparator = new Label(); labelSeparator.Width = labelParameterSaparatorWidth; labelSeparator.Height = textboxHeight; labelSeparator.Content = ":"; AutoSuggestControl.AutoSuggestBox parameterValueBox = new AutoSuggestControl.AutoSuggestBox(); parameterValueBox.ListItemSelected += new RoutedPropertyChangedEventHandler<object>(parameterValueBox_ListItemSelected); parameterValueBox.Width = textboxParameterValueWidth; parameterValueBox.Height = textboxHeight; Label labelDescription = new Label(); //labelDescription.Width = labelParameterDescriptionWidth; labelDescription.Height = textboxHeight; labelDescription.FontSize = 13; labelDescription.FontFamily = new System.Windows.Media.FontFamily("Calibri"); labelDescription.Foreground = new SolidColorBrush(Color.FromArgb(0xff, 0x40, 0x3e, 0x3c)); Label space = new Label(); space.Width = 10; space.Height = textboxHeight; Button removeButton = new Button(); removeButton.Content = "-"; removeButton.Width = removeButtonWidth; removeButton.Height = removeButtonHeight; removeButton.Background = Brushes.White; removeButton.BorderBrush = new SolidColorBrush(Color.FromArgb(0xff, 0xff, 0xcb, 0x8b)); removeButton.Foreground = new SolidColorBrush(Color.FromArgb(0xff, 0xff, 0x52, 0x00)); labelPanel.Children.Add(removeButton); labelPanel.Children.Add(space); labelPanel.Children.Add(parameterKeyBox); label.Content = labelPanel; label.Tag = m_noOfParameters; labelPanel.Tag = m_noOfInstruments; parameterKeyBox.Tag = m_noOfParameters; labelSeparator.Tag = m_noOfParameters; parameterValueBox.Tag = m_noOfParameters; labelDescription.Tag = m_noOfParameters; removeButton.Tag = m_noOfParameters; removeButton.PreviewMouseDown += new MouseButtonEventHandler(removeButton_Parameters_MouseDownEvent); //parameterKeyBox.PreviewKeyUp += new KeyEventHandler(keyTextbox_Parameters_KeyInput); parameterLabel.Add(label); parameterWrapPanel.Add(labelPanel); parameterKeyTextBox.Add(parameterKeyBox); parameterSeparatorLabel.Add(labelSeparator); parameterValueTextBox.Add(parameterValueBox); parameterDescriptionLabel.Add(labelDescription); parameterRemoveButton.Add(removeButton); Grid.SetColumn(label, 0); Grid.SetRow(label, m_noOfParameters); if (a_parameters != null) { parameterKeyBox.Text = a_parameters.Name; labelPanel.Children.Add(labelSeparator); parameterValueBox.Text = a_parameters.Value; labelPanel.Children.Add(parameterValueBox); //string description = FindParameterDescription() } Parameterslb.Items.Add(label); ++m_noOfParameters; }
/* * Exports the selected query data to excel; use random file name by timestamp */ private void ExportDataTableToExcel(DataTable sInputTable, DataTable objNodeTable) { // export to Excel // create random timestamp TimeSpan sTime = DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0); string timeStamp = ((long)sTime.TotalMilliseconds).ToString(); ExcelManager em = new ExcelManager(); if (em.ExcelExport(sInputTable, objNodeTable, "MiningReport_" + timeStamp + ".xls")) LabelStatus.Text = "Success!"; else LabelStatus.Text = "Failed!"; }