基本信息
源码名称：winform 文件导出类源码 Export
源码大小：0.01M
文件格式：.cs
开发语言：C#
更新时间：2013-11-10
友情提示：（无需注册或充值，赞助后即可获取资源下载链接）
嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300
本次赞助数额为： 2 元×
微信扫码支付：2 元
×
请留下您的邮箱，我们将在2小时内将文件发到您的邮箱
源码介绍
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;
}
}
}
}