private void button2_Click(object sender, RibbonControlEventArgs e) { string url = @"http://www.matrix67.com/blog/feed"; string txt = MyGrab.GetContent(url); System.Windows.Forms.MessageBox.Show(txt); }
private void btnGetText_Click(object sender, EventArgs e) { Excel.Range rng = Globals.ThisAddIn.Application.Range["a1"]; if (url != null) { string[] str = MyGrab.GetContent(url); //提取网抓内容 //string[] strArr =str.Split('_');//分割成数组 rng.ExportDataInSht <string>(str); //输出到Excel单元格 rng.EntireColumn.AutoFit(); //自动调整列宽 } }
private void button3_Click(object sender, RibbonControlEventArgs e) { //string url1 = @"http://www.matrix67.com/blog/feed"; //Excel.Range rng = (Excel.Range)Globals.ThisAddIn.Application.Selection; //rng.Value = MyGrab.GetContent(url1); //rng.AutoFitRange(100); string url2 = @"http://blog.sina.com.cn/rss/1748013412.xml"; Excel.Range rng = (Excel.Range)Globals.ThisAddIn.Application.Selection; rng.Value = MyGrab.GetContent(url2); rng.AutoFitRange(100); }