实例介绍
【实例简介】
【实例截图】
【实例截图】
【核心代码】
using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Diagnostics;
using System.Runtime.InteropServices;
namespace File.Helper
{
public class Export
{
public enum FileType
{
Excel,
Txt,
Csv
}
#region 导出到txt文件
[DllImport("User32.DLL")]
public static extern int SendMessage(IntPtr hWnd, uint Msg, int wParam, string lParam);
[DllImport("User32.DLL")]
public static extern IntPtr FindWindowEx(IntPtr hwndParent, IntPtr hwndChildAfter, string lpszClass, string lpszWindow);
public const uint WM_SETTEXT = 0x000C;
public void ToNotepad(string strText)
{
Process vProcess = Process.Start("notepad.exe");
while (vProcess.MainWindowHandle == IntPtr.Zero) vProcess.Refresh();
IntPtr vHandle = FindWindowEx(vProcess.MainWindowHandle, IntPtr.Zero, "Edit", null);
SendMessage(vHandle, WM_SETTEXT, 0, strText);
}
#endregion
public bool ExportToFile(DataGridView dv, FileType type, ProgressBar pb)
{
bool m = false;
switch (type)
{
case FileType.Excel:
m = ExportToExcel(dv);
break;
case FileType.Csv:
m = ExportToCsv(dv, pb);
break;
case FileType.Txt:
m = ExportToTxt(dv, pb);
break;
}
return m;
}
public bool ExportToFile(DataGridView dv, FileType type, ProgressBar pb,string defaultFileName)
{
bool m = false;
switch (type)
{
case FileType.Excel:
m = ExportToExcel(dv);
break;
case FileType.Csv:
m = ExportToCsv_Visible(dv, defaultFileName);
break;
case FileType.Txt:
m = ExportToTxt(dv, pb);
break;
}
return m;
}
private bool ExportToExcel(DataGridView dgv)
{
return false;
}
private bool ExportToCsv(DataGridView dgv, ProgressBar pb)
{
return ExportToCsv_Visible(dgv);
SaveFileDialog dlg = new SaveFileDialog();
dlg.Filter = "CSV(逗号分隔)(*.csv)|*.csv";
dlg.FilterIndex = 0;
dlg.RestoreDirectory = true;
dlg.CreatePrompt = true;
dlg.Title = "保存为CSV(逗号分隔)文件";
if (dlg.ShowDialog() == DialogResult.OK)
{
Stream myStream;
myStream = dlg.OpenFile();
StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
string columnTitle = "";
try
{
//写入列标题
for (int i = 0; i < dgv.ColumnCount; i )
{
if (i > 0)
{
columnTitle = ",";
}
columnTitle = dgv.Columns[i].HeaderText;
}
columnTitle.Remove(columnTitle.Length - 1);
sw.WriteLine(columnTitle);
//写入列内容
for (int j = 0; j < dgv.Rows.Count; j )
{
string columnValue = "";
pb.Value = j * 100 / dgv.Rows.Count;
for (int k = 0; k < dgv.Columns.Count; k )
{
if (k > 0)
{
columnValue = ",";
}
if (dgv.Rows[j].Cells[k].Value == null)
{
columnValue = "";
}
else
{
string m = dgv.Rows[j].Cells[k].Value.ToString().Trim();
columnValue = m.Replace(",", "，");
}
}
columnValue.Remove(columnValue.Length - 1);
sw.WriteLine(columnValue);
}
sw.Close();
myStream.Close();
}
catch (Exception e)
{
//MessageBox.Show(e.ToString());
return false;
}
finally
{
sw.Close();
myStream.Close();
}
return true;
}
else
{
return false;
}
}
private bool ExportToCsv_Visible(DataGridView dgv,string defaultFileName="")
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.Filter = "CSV(逗号分隔)(*.csv)|*.csv";
dlg.FilterIndex = 0;
dlg.RestoreDirectory = true;
dlg.CreatePrompt = true;
dlg.Title = "保存为CSV(逗号分隔)文件";
if (!String.IsNullOrEmpty(defaultFileName)) dlg.FileName = defaultFileName;
if (dlg.ShowDialog() == DialogResult.OK)
{
Stream myStream;
myStream = dlg.OpenFile();
StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
string columnTitle = "";
try
{
//写入列标题
//for (int i = 0; i < dgv.ColumnCount; i )
//{
// if (i > 0)
// {
// columnTitle = ",";
// }
// columnTitle = dgv.Columns[i].HeaderText;
//}
string[] array = new string[] { };
List<string> list = new List<string>();
//获取Visble =true 的列
foreach (DataGridViewColumn column in dgv.Columns)
{
if (column.Visible == true)
{
//array[column.DisplayIndex] = column.Name;
list.Add(column.Name);
if (columnTitle != "") columnTitle = ",";
columnTitle = column.HeaderText;
}
}
array = list.ToArray();
if (array.Length <= 0)
{
MessageBox.Show("NO Data");
return false;
}
columnTitle.Remove(columnTitle.Length - 1);
sw.WriteLine(columnTitle);
//写入列内容
//for (int j = 0; j < dgv.Rows.Count; j )
//{
// string columnValue = "";
// //pb.Value = j * 100 / dgv.Rows.Count;
// for (int k = 0; k < dgv.Columns.Count; k )
// {
// if (k > 0)
// {
// columnValue = ",";
// }
// if (dgv.Rows[j].Cells[k].Value == null)
// {
// columnValue = "";
// }
// else
// {
// string m = dgv.Rows[j].Cells[k].Value.ToString().Trim();
// columnValue = m.Replace(",", "，");
// }
// }
// columnValue.Remove(columnValue.Length - 1);
// sw.WriteLine(columnValue);
//}
for (int j = 0; j < dgv.Rows.Count; j )
{
string columnValue = "";
//pb.Value = j * 100 / dgv.Rows.Count;
if (dgv.Rows[j].Visible == true)
{
for (int k = 0; k < array.Length; k )
{
if (k > 0)
{
columnValue = ",";
}
if (dgv.Rows[j].Cells[array[k]].Value == null)
{
columnValue = "";
}
else
{
string m = dgv.Rows[j].Cells[array[k]].Value.ToString().Trim();
columnValue = m.Replace(",", "，");
}
}
columnValue.Remove(columnValue.Length - 1);
sw.WriteLine(columnValue);
}
}
sw.Close();
myStream.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
return false;
}
finally
{
sw.Close();
myStream.Close();
}
return true;
}
else
{
return false;
}
//string[] array = new string[ordgv.Columns.Count];
////获取Visble =true 的列
//foreach (DataGridViewColumn column in ordgv.Columns)
//{
// if (column.Visible == true)
// {
// array[column.DisplayIndex] = column.HeaderText;
// }
//}
//if (array.Length <= 0)
//{
// MessageBox.Show("NO Data");
// return;
//}
//DataGridView dgv = new DataGridView();
//dgv = ordgv;
////创建并打开Excel
//Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();
//myExcel.Application.Workbooks.Add(true);
//myExcel.Visible = true;
//int RowsCount = dgv.Rows.Count;
//int ColumnsCount = array.Length;
//int mm = 1;
//for (int i = 0; i < ColumnsCount; i )
//{
// string ColumnName;
// try
// {
// ColumnName = array.GetValue(i).ToString();
// }
// catch
// { continue; }
// //导出列名
// myExcel.Cells[1, mm] = ColumnName;
// //导出列内容
// for (int m = 0; m < RowsCount; m )
// {
// try { myExcel.Cells[m 2, mm] = dgv.Rows[m].Cells[ColumnName].Value.ToString(); }
// catch { }
// } //履行完一列 mm
// mm ;
//}
//myExcel.Columns.EntireColumn.AutoFit();
}
private bool ExportToTxt(DataGridView dgv, ProgressBar pb)
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.Filter = "文本文件(*.txt)|*.txt";
dlg.FilterIndex = 0;
dlg.RestoreDirectory = true;
dlg.CreatePrompt = true;
dlg.Title = "保存为文本文件";
if (dlg.ShowDialog() == DialogResult.OK)
{
Stream myStream;
myStream = dlg.OpenFile();
StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
string columnTitle = "";
try
{
//写入列标题
for (int i = 0; i < dgv.ColumnCount; i )
{
if (i > 0)
{
columnTitle = ",";
}
columnTitle = dgv.Columns[i].HeaderText;
}
columnTitle.Remove(columnTitle.Length - 1);
sw.WriteLine(columnTitle);
//写入列内容
for (int j = 0; j < dgv.Rows.Count; j )
{
string columnValue = "";
pb.Value = j * 100 / dgv.Rows.Count;
for (int k = 0; k < dgv.Columns.Count; k )
{
if (k > 0)
{
columnValue = "\t";
}
if (dgv.Rows[j].Cells[k].Value == null)
{
columnValue = "";
}
else
{
string m = dgv.Rows[j].Cells[k].Value.ToString().Trim();
columnValue = m.Replace("\t", "");
}
}
columnValue.Remove(columnValue.Length - 1);
sw.WriteLine(columnValue);
}
sw.Close();
myStream.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
return false;
}
finally
{
sw.Close();
myStream.Close();
}
return true;
}
else
{
return false;
}
}
}
}
好例子网口号：伸出你的我的手 — 分享！
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
网友评论
我要评论