using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
namespace Utility.Util
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
{
public
class Excelcs
#region
public
class Excelcs
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
{
public
static
bool DataGridviewShowToExcel(DataTable dt,
bool isShowExcle)
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
{
if (dt.Rows.Count == 0)
return
false;
//建¡§立¢¡éExcel对?象¨®
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
Microsoft.Office.Interop.Excel.Application excel =
new Microsoft.Office.Interop.Excel.Application();
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
excel.Application.Workbooks.Add(
true);
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
excel.Visible = isShowExcle;
//生¦¨²成¨¦字Á?段?名?称?
for (
int i = 0; i < dt.Columns.Count; i++)
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
{
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
excel.Cells[1, i + 1] = dt.Columns[i].Caption;
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
}
//填¬?充?数ºy据Y
for (
int i = 0; i < dt.Rows.Count - 1; i++)
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
{
for (
int j = 0; j < dt.Columns.Count; j++)
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
{
if (dt.Rows[j][i].GetType() ==
typeof(
string))
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
{
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
excel.Cells[i + 2, j + 1] =
"'" + dt.Rows[j][i].ToString();
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
}
else
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
{
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
excel.Cells[i + 2, j + 1] = dt.Rows[j][i].ToString();
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
}
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
}
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
}
return
true;
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
}
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
}
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
#endregion
![InBlock.gif](http://blog.51cto.com/images/editer/InBlock.gif)
}