public void WriteDataXlsxBeta(ListBox listBox, string uriInput) { ParseWork parseWork = new ParseWork(); XLWorkbook workbook = new XLWorkbook(); //new XLWorkbook(@"C:\Users\xaNe\Documents\Visual Studio 2017\Projects\FreelanceProj1\FreelanceProj1\bin\Debug\helloCloseXML.xlsx"); var editWorkSheet = workbook.Worksheets.Add("sheetName"); var listCountResult = parseWork.ParseTag(listBox, uriInput); //object resSrt = null; #region OtherAlgo //for (int i = 0; i < listCountResult.Count; i++) //{ // string resultRelease = listCountResult[i]; // editWorkSheet.Cell($"A{listCountResult.Count}").Value = resultRelease; //} //Experimintal //var editWorkSheetFix = listCountResult.Where(x => x.ToString() != "").Select(x => x); #endregion if (listCountResult.Where(c => c.ToString() != "") is var f) { foreach (var itemStr in f) { editWorkSheet.Cell($"A{itemStr.Count()}").Value = itemStr; } } #region DebugAlgo //foreach (var itemStr in listCountResult) //{ // listBox.Items.Add(itemStr); // try // { // /*resSrt =*/ editWorkSheet.Cell($"A{itemStr.Count()}").Value = itemStr; // } // catch (Exception ssae) // { // MessageBox.Show("Detect crash " + ssae.ToString()); // } // finally // { // listBox.Items.Add(itemStr); // } //} #endregion workbook.SaveAs("helloCloseXML.xlsx"); workbook.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null || CnInterfaceUser.GetUserLevel(Session["username"].ToString().Trim())!=1) { Response.Redirect("~/Index.aspx"); } if (Session["GetDataBuildHtml"] == null) { w = new ParseWork("videohtml"); Session["GetDataBuildHtml"] = w; } else { w = (ParseWork)Session["GetDataBuildHtml"]; } switch (w.State) { case 0: { this.div_load.Visible = false; break; } case 1: { this.lab_state.Text = "已运行<font color=blue>" + ((TimeSpan)(DateTime.Now - w.StartTime)).TotalSeconds.ToString("0.000") + " </font><font color='#666699'>秒,数据抓取完成:<font color=blue>" + w.Percent + " </font>%</font>"; this.btn_startwork.Enabled = false; this.btn_startwork.Text = "数据抓取生成中..."; Page.RegisterStartupScript("", "<script>window.setTimeout('location.href=location.href',1000);</script>"); this.lab_jg.Text = ""; break; } case 2: { this.lab_jg.Text = "<font color='#666699'>任务结束,成功抓取生成视频HTML<font color=blue>" + w.finishcount.ToString() + "</font>个 (<a href=\"../html/VideoIndex.html\" target=\"_blank\"><font color=blue>查看</font></a>),用时<font color=blue>" + ((TimeSpan)(w.FinishTime - w.StartTime)).TotalSeconds.ToString("0.000") + " </font>秒</font>"; labparselog.Text = w.ParseLogicstr; this.btn_startwork.Enabled = true; this.btn_startwork.Text = "点击开始抓取生成视频HTML"; this.div_load.Visible = false; Session["GetDataBuildHtml"] = null; break; } case 3: { this.lab_jg.Text = "<font color='#666699'>任务结束,在<font color=blue>" + ((TimeSpan)(w.ErrorTime - w.StartTime)).TotalSeconds.ToString("0.000") + "</font>秒的时候发生错误导致任务失败</font>'"; labparselog.Text = w.ParseLogicstr; this.btn_startwork.Enabled = true; this.btn_startwork.Text = "点击开始抓取生成视频HTML"; this.div_load.Visible = false; Session["GetDataBuildHtml"] = null; break; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null || CnInterfaceUser.GetUserLevel(Session["username"].ToString().Trim())!=1) { Response.Redirect("~/Index.aspx"); } if(Session["AutomatismParse"]==null) { w = new ParseWork("huasky"); Session["AutomatismParse"]=w; } else { w = (ParseWork)Session["AutomatismParse"]; } switch(w.State) { case 0: { this.div_load.Visible=false; break; } case 1: { this.lab_state.Text = "已运行<font color=blue>" + ((TimeSpan)(DateTime.Now - w.StartTime)).TotalSeconds.ToString("0.000") + " </font><font color='#666699'>秒,数据抓取完成:<font color=blue>" + w.Percent + " </font>%</font>"; this.btn_startwork.Enabled=false; this.btn_startwork.Text = "huasky数据抓取中..."; Page.RegisterStartupScript("", "<script>window.setTimeout('location.href=location.href',1000);</script>"); this.lab_jg.Text=""; break; } case 2: { this.lab_jg.Text = "<font color='#666699'>任务结束,成功抓取huasky数据<font color=blue>" + w.finishcount.ToString() + "</font>条,用时<font color=blue>" + ((TimeSpan)(w.FinishTime - w.StartTime)).TotalSeconds.ToString("0.000") + " </font>秒</font>"; this.btn_startwork.Enabled=true; this.btn_startwork.Text = "点击开始抓取huasky数据"; this.div_load.Visible=false; Session["AutomatismParse"] = null; break; } case 3: { this.lab_jg.Text = "<font color='#666699'>任务结束,在<font color=blue>" + ((TimeSpan)(w.ErrorTime - w.StartTime)).TotalSeconds.ToString("0.000") + "</font>秒的时候发生错误导致任务失败</font>'"; this.btn_startwork.Enabled=true; this.btn_startwork.Text = "点击开始抓取huasky数据"; this.div_load.Visible=false; Session["AutomatismParse"] = null; break; } } }