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