日期:2014-05-20  浏览次数:21022 次

datagrid的数据怎么样导出到Excel 那个大哥知道代码要怎么写不喽
我还想请教各位一个问题啊
我就是一个datagrid的数据怎么样导出到Excel     和Html   里面去啊
随便导出那里面去都可以
可以指教指教小弟不

------解决方案--------------------
/// <summary>
/// 将DataGrid中的数据导入Excel中,并显示Excel应用程序,

/// 注意调用该方法必须有安装Excel 2000应用程序,并且假定DataGrid中绑定的是一DataSet
/// </summary>
/// <param name= "grid "> </param>
/// <param name= "ReportTitle "> </param>
public static void ExportDataGridToExcel(DataGrid grid, string ReportTitle)
{
DataTable myTable = ((DataSet)grid.DataSource). Tables[0];

try
{
Excel. Application xlApp = new Excel.ApplicationClass ();

int rowIndex;
int colIndex;

rowIndex = 2;
colIndex = 0;

Excel. Workbook xlBook =xlApp.Workbooks.Add(true);


if (grid.TableStyles.Count > 0 )
{
Excel.Range range = xlApp.get_Range(xlApp.Cells[1,1],xlApp.Cells[1,grid.TableStyles[0].GridColumnStyles.Count]);
range.MergeCells = true;
xlApp.ActiveCell.FormulaR1C1 = ReportTitle;
xlApp.ActiveCell.Font.Size = 18;
xlApp.ActiveCell.Font.Bold = true;

foreach(DataGridColumnStyle colu in grid.TableStyles[0].GridColumnStyles)
{
colIndex=colIndex +1;
xlApp.Cells[2,colIndex] = colu.HeaderText ;
}

//得到的表所有行,赋值给单元格

for (int row = 0;row < myTable.Rows.Count;row++)
{
rowIndex = rowIndex + 1;
colIndex = 0;
for (int col=0;col <grid.TableStyles[0].GridColumnStyles.Count;col++)
{
colIndex = colIndex + 1;
xlApp.Cells[rowIndex, colIndex] = grid[row,col].Tostring();
}
}
}
else
{
Excel.Range range = xlApp.get_Range(xlApp.Cells[1,1],xlApp.Cells[1,myTable.Columns.Count]);
range.MergeCells = true;
xlApp.ActiveCell.FormulaR1C1 = ReportTitle;
xlApp.ActiveCell.Font.Size = 18;
xlApp.ActiveCell.Font.Bold = true;

//将表中的栏位名称填到Excel的第一行

foreach(DataColumn Col in myTable.Columns)
{
colIndex = colIndex + 1;
xlApp.Cells[2, colIndex] = Col.ColumnName;
}

//得到的表所有行,赋值给单元格

for (int row = 0;row < myTable.Rows.Count;row++)
{
rowIndex = rowIndex + 1;
colIndex = 0;
for (int col=0;col <myTable.Columns.Count;col++)
{
colIndex = colIndex + 1;
xlApp.Cells[rowIndex, colIndex] = grid[row,col].Tostring();
}
}
}

------解决方案--------------------
http://dotnet.aspx.cc/article/8a4cbf47-b888-4832-3389-ed3a3a3c8aab/read.aspx