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;
}
}
}
