从datagridview导出数据的问题

[yixian2007]

请问如何实现的.

比如现在一个datagridview已经有了数据,且存放在dataset的表中,请问如何将此表导成xls文档?或者xms文档?

[surlew]

public void ExportExcel(DataSet ds)        //以DataSet- 导出Excel文件   
        {
            if (ds == null) return;
            Microsoft.office.Interop.Excel.Application xlApp = new Microsoft.office.Interop.Excel.Application();

            if (xlApp == null)
            {
                MessageBox.Show("无法创建Excel对象，可能您的机子未安装Excel", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            Microsoft.office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
            Microsoft.office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
            Microsoft.office.Interop.Excel.Worksheet worksheet = (Microsoft.office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得Sheet1
            Microsoft.office.Interop.Excel.Range range;
            long totalCount = ds.Tables[0].Rows.Count;

            long rowRead = 0;
            float percent = 0;

            //写入字段
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                worksheet.Cells[1, i + 1] = ds.Tables[0].Columns[i].ColumnName;
                range = (Microsoft.office.Interop.Excel.Range)worksheet.Cells[1, i + 1];
                range.Interior.ColorIndex = 15;
                range.Font.Bold = true;
            }
            //写入数值
            for (int r = 0; r < ds.Tables[0].Rows.Count; r++)
            {
                for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
                {
                    worksheet.Cells[r + 2, i + 1] = "'" + ds.Tables[0].Rows[r][i];
                }
                rowRead++;
                percent = ((float)(100 * rowRead)) / totalCount;

            }

            


            xlApp.Visible = true;
        }