如何将repeater控件中的一部分内容以Excel形式输出

[deathnotefire]

比如说repeater控件中每一行都有一个checkbox控件,只有选中的栏位才输入到Excel中.

[lbq0801]

一行一行的控制，前面checkbox加个判断
if (dgv.Rows.Count == 0)
return false;
//建立Excel对象
Excel.Application excel = new Excel.Application();
excel.Application.Workbooks.Add(true);
excel.Visible = isShowExcle;
//生成字段名称
for (int i = 0; i < dgv.ColumnCount; i++)
{
excel.Cells[1, i + 1] = dgv.Columns[i].HeaderText;
}
//填充数据
for (int i = 0; i < dgv.RowCount - 1; i++)
{
for (int j = 0; j < dgv.ColumnCount; j++)
{
if (dgv[j, i].ValueType == typeof(string))
{
excel.Cells[i + 2, j + 1] = "'" + dgv[j, i].Value.ToString();
}
else
{
excel.Cells[i + 2, j + 1] = dgv[j, i].Value.ToString();
}
}
}

[子夜__]

自己构建DataTable

把选中的数据添加里面

然后DataTable导出excel

 public static bool ExportToExcel(DataTable table, string excelName, int[] columnIndexs, string[] columnHeads)
    {
      
        Excel.ApplicationClass oExcel = new Excel.ApplicationClass();
        Excel.Workbook obook = null;
        Excel.Worksheet oSheet = null;
        Excel.Range range = null;
        try
        {
            obook = oExcel.Workbooks.Add("");
            oSheet = (Excel.Worksheet)obook.Worksheets[1];
            int rCount, cCount;
            rCount = table.Rows.Count;
            cCount = table.Columns.Count;
            object obj = System.Reflection.Missing.Value;

            if (cCount < columnIndexs.Length || cCount < columnHeads.Length)
            {
                throw new ArgumentOutOfRangeException("columnIndexs 与 columnHeads 长度必须一致。");
            }
            for (int i = 1; i <= columnIndexs.Length; i++)
            {
                //Excel.Range = (Excel.Range)oSheet.Columns.get_Item(i, obj);  
                range = (Excel.Range)oSheet.Columns.get_Item(i, obj);
                range.NumberFormatLocal = "@";
            }
            for (int c = 0; c < columnIndexs.Length; c++)
            {
                oSheet.Cells[1, c + 1] = columnHeads[c];
                for (int r = 1; r <= rCount; r++)
                {
                    oSheet.Cells[r + 1, c + 1] = table.Rows[r - 1][columnIndexs[c]].ToString();
                }
            }
            obook.SaveCopyAs(excelName);
            obook.Close(false, System.Reflection.Missing.Value, System.Reflection.Missing.Value);
            return true;
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            System.Runtime.InteropServices.Marshal.ReleaseComObject(range);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(oSheet);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obook);
            oExcel.Quit();
            System.Runtime.InteropServices.Marshal.ReleaseComObject(oExcel);
            GC.Collect();
        }
    }

[chen_ya_ping]

可以再读取一下数据，比如只读取你checkbox 选中的数据，到dataset，然后再从dataset导出到excel。