private void ResultExport(object sender, RoutedEventArgs e) { if (dt1.Rows.Count == 0) { MessageBox.Show("没有数据!"); } else { string filename = ""; //Microsoft.Win32.OpenFileDialog dialogOpenFile = new Microsoft.Win32.OpenFileDialog(); //dialogOpenFile.ShowDialog(); Microsoft.Win32.SaveFileDialog dialogSaveFile = new Microsoft.Win32.SaveFileDialog(); dialogSaveFile.Filter = "Excel文件(*.xls)|*.xls"; if (dialogSaveFile.ShowDialog() == true) { filename = dialogSaveFile.FileName; } else { return; } ExcelWriterOC excel = new ExcelWriterOC(); excel.ExcelWriter(filename); excel.BeginWrite(); excel.WriteString(0, 0, "ID"); excel.WriteString(0, 1, "关键词"); excel.WriteString(0, 2, "规则"); excel.WriteString(0, 3, "搜索引擎"); excel.WriteString(0, 4, "排名"); excel.WriteString(0, 5, "标题"); excel.WriteString(0, 6, "描述1"); excel.WriteString(0, 7, "描述2"); excel.WriteString(0, 8, "竞价域名"); excel.WriteString(0, 9, "单位名称"); short excelline = 1; foreach (DataRow dr in dt1.Rows) { excel.WriteString(excelline, 0, dr[0].ToString()); excel.WriteString(excelline, 1, dr[1].ToString()); excel.WriteString(excelline, 2, dr[2].ToString()); excel.WriteString(excelline, 3, dr[3].ToString()); excel.WriteString(excelline, 4, dr[4].ToString()); excel.WriteString(excelline, 5, dr[5].ToString()); excel.WriteString(excelline, 6, dr[6].ToString()); excel.WriteString(excelline, 7, dr[7].ToString()); excel.WriteString(excelline, 8, dr[8].ToString()); excel.WriteString(excelline, 9, dr[9].ToString()); excelline++; } excel.EndWrite(); } }
/// <summary> /// 导出:注意导出是把搜索引擎图标的地址改为文本 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btExport(object sender, RoutedEventArgs e) { if (dt1.Rows.Count == 0) { MessageBox.Show("没有数据!"); } else { string filename = ""; //Microsoft.Win32.OpenFileDialog dialogOpenFile = new Microsoft.Win32.OpenFileDialog(); //dialogOpenFile.ShowDialog(); Microsoft.Win32.SaveFileDialog dialogSaveFile = new Microsoft.Win32.SaveFileDialog(); dialogSaveFile.Filter = "Excel文件(*.xls)|*.xls"; if (dialogSaveFile.ShowDialog() == true) { filename = dialogSaveFile.FileName; } else { return; } ExcelWriterOC excel = new ExcelWriterOC(); excel.ExcelWriter(filename); excel.BeginWrite(); excel.WriteString(0, 0, "关键词"); excel.WriteString(0, 1, "域名"); excel.WriteString(0, 2, "搜索引擎"); excel.WriteString(0, 3, "排名"); short excelline = 1; foreach (DataRow dr in dt1.Rows) { excel.WriteString(excelline, 0, dr[0].ToString()); excel.WriteString(excelline, 1, dr[1].ToString()); if (dr[2].ToString() == "/WpfQuery;component/Images/baidu.png") { excel.WriteString(excelline, 2, "Baidu"); } else if (dr[2].ToString() == "/WpfQuery;component/Images/360.png") { excel.WriteString(excelline, 2, "360"); } else if (dr[2].ToString() == "/WpfQuery;component/Images/sogou.png") { excel.WriteString(excelline, 2, "Sogou"); } excel.WriteString(excelline, 3, dr[3].ToString()); excelline++; } excel.EndWrite(); } }
private void ResultExport(object sender, RoutedEventArgs e) { if (dt1.Rows.Count == 0) { MessageBox.Show("没有数据!"); } else { string filename = ""; //Microsoft.Win32.OpenFileDialog dialogOpenFile = new Microsoft.Win32.OpenFileDialog(); //dialogOpenFile.ShowDialog(); Microsoft.Win32.SaveFileDialog dialogSaveFile = new Microsoft.Win32.SaveFileDialog(); dialogSaveFile.Filter = "Excel文件(*.xls)|*.xls"; if (dialogSaveFile.ShowDialog() == true) { filename = dialogSaveFile.FileName; } else { return; } ExcelWriterOC excel = new ExcelWriterOC(); excel.ExcelWriter(filename); excel.BeginWrite(); excel.WriteString(0, 0, "链接"); excel.WriteString(0, 1, "标题"); excel.WriteString(0, 2, "收录"); excel.WriteString(0, 3, "排名"); short excelline = 1; foreach (DataRow dr in dt1.Rows) { if (dr[0].ToString() != "") { excel.WriteString(excelline, 0, dr[0].ToString()); excel.WriteString(excelline, 1, dr[1].ToString()); excel.WriteString(excelline, 2, dr[2].ToString()); excel.WriteString(excelline, 3, dr[3].ToString()); excelline++; } } excel.EndWrite(); } }
private void btExport(object sender, RoutedEventArgs e) { string filename = ""; Microsoft.Win32.SaveFileDialog dialogSaveFile = new Microsoft.Win32.SaveFileDialog(); dialogSaveFile.Filter = "Excel文件(*.xls)|*.xls"; if (dialogSaveFile.ShowDialog() == true) { filename = dialogSaveFile.FileName; } else { return; } ExcelWriterOC excel = new ExcelWriterOC(); excel.ExcelWriter(filename); excel.BeginWrite(); excel.WriteString(0, 0, "描述"); excel.WriteString(0, 1, "标识"); excel.WriteString(0, 2, "状态"); excel.WriteString(0, 3, "主机头值"); excel.WriteString(0, 4, "IP地址"); excel.WriteString(0, 5, "端口"); excel.WriteString(0, 6, "目录"); short excelline = 1; foreach (DataRow dr in datat.Rows) { excel.WriteString(excelline, 0, dr[0].ToString()); excel.WriteString(excelline, 1, dr[1].ToString()); excel.WriteString(excelline, 2, dr[2].ToString()); excel.WriteString(excelline, 3, dr[3].ToString()); excel.WriteString(excelline, 4, dr[4].ToString()); excel.WriteString(excelline, 5, dr[5].ToString()); excel.WriteString(excelline, 6, dr[6].ToString()); excelline++; } excel.EndWrite(); }