C# ListView-导出Excel

public static void ExpToExcel(ListView listviewname)
  {
   if (listviewname.Items.Count == 0) return;
   Excel.Application excel = new Excel.Application();
   Excel.Workbooks workbooks = excel.Workbooks;  
   Excel.Workbook workbook = workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
   Excel.Sheets worksheets = workbook.Worksheets;
   Excel.Worksheet sheet = (Excel.Worksheet) worksheets.get_Item(1);
   excel.Visible = true;

   Excel.Range range;
   excel.Cells.Select();
   excel.Cells.RowHeight = 30;
   excel.Cells.Font.Size = 10;
   excel.Cells.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter; 

   int rowPos = 2;
   range = excel.get_Range(sheet.Cells[rowPos,1],sheet.Cells[rowPos,1]);
   range.Select();

   for(int i=1;i<=listviewname.Columns.Count;i++)
   {
    range = excel.get_Range(sheet.Cells[rowPos,i],sheet.Cells[rowPos,i]);
    range.Borders.LineStyle = 1;
    range.Font.Name = "华文仿宋";
    range.Font.Size = 16;
    range.Font.Bold = true;
    range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
    range.ColumnWidth = 18;
    sheet.Cells[rowPos,i] = listviewname.Columns[i-1].Text.ToString();
   }
   rowPos++;

   foreach(ListViewItem item in listviewname.Items)
   {
    for(int i=1;i<=listviewname.Columns.Count;++i)
    {
     range = excel.get_Range(sheet.Cells[rowPos,i],sheet.Cells[rowPos,i]);
     range.Borders.LineStyle = 1;
     range.Font.Name = "华文仿宋";
     range.Font.Size = 12;
     range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
     sheet.Cells[rowPos,i] = item.SubItems[i-1].Text;
    }
    rowPos++;
   }

  }

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值