public SearchIP() { var res = new ListTable(); urls.ForEachPathsAndSleep(url => { HtmlWeb webClient = new HtmlWeb(); HtmlDocument doc = webClient.Load(url); HtmlNodeCollection headList = doc.DocumentNode.SelectNodes("//*[@id=\"list\"]/table/thead/tr/th"); HtmlNodeCollection valueList = doc.DocumentNode.SelectNodes("//*[@id=\"list\"]/table/tbody/tr"); if (res.Columns.Count == 0) { foreach (HtmlNode node in headList) { res.Columns.Add(node.InnerText); } } foreach (HtmlNode node in valueList) { var temp = new List <object>(); foreach (HtmlNode child in node.SelectNodes("td")) { temp.Add(child.InnerText); } res.Rows.Add(temp); } }); ExcelUtils.ExportToExcel(res.ToDataTable(), "temp.xlsx"); //File.WriteAllText("temp.txt", JsonHelper.ToJson((JsonData) res, indentLevel: 2)); }
public void WriteAllLines(Dictionary <string, string> dic, string path) { //直接写入excel var listTable = new ListTable() { Rows = dic.Select(p => new List <object>() { p.Key, p.Value }).ToList(), Columns = new List <string>() { "key", "value" } }; ExcelUtils.ExportToExcel(listTable.ToDataTable(), Path.ChangeExtension(path, ".xlsx")); }