C# 将list数组保存成xls表格

            List<string> listName=new List<string>();
            listName.Add("时间");
            listName.Add("标签ID");
            listName.Add("X轴");
            listName.Add("Y轴");
            listName.Add("Z轴");
            listName.Add("温度");
            listName.Add("湿度");
            listName.Add("电量");
            //将listView1中的数据保存到excel表格中
            object misValue = System.Reflection.Missing.Value;
            Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
            Workbook xlWorkBook = xlApp.Workbooks.Add(misValue);
            Worksheet xlWorkSheet = (Worksheet)xlWorkBook.Worksheets.get_Item(1);
            for (int i = 0; i < listName.Count; i++)
            {
                xlWorkSheet.Cells[1, i + 1] = listName[i]; //write the column name
            }
            for (int i = 0; i < listView1.Items.Count; i++)
            {
                listView1.Items[i].Selected = true;//触发选中第一行 
                xlWorkSheet.Cells[i + 2, 1] = listView1.SelectedItems[0].SubItems[0].Text.ToString();//第i行第一列
                xlWorkSheet.Cells[i + 2, 2] = listView1.SelectedItems[0].SubItems[1].Text.ToString();//第i行第二列
                xlWorkSheet.Cells[i + 2, 3] = listView1.SelectedItems[0].SubItems[2].Text.ToString();
                xlWorkSheet.Cells[i + 2, 4] = listView1.SelectedItems[0].SubItems[3].Text.ToString();
                xlWorkSheet.Cells[i + 2, 5] = listView1.SelectedItems[0].SubItems[4].Text.ToString();
                xlWorkSheet.Cells[i + 2, 6] = listView1.SelectedItems[0].SubItems[5].Text.ToString();
                xlWorkSheet.Cells[i + 2, 7] = listView1.SelectedItems[0].SubItems[6].Text.ToString();
                xlWorkSheet.Cells[i + 2, 8] = listView1.SelectedItems[0].SubItems[7].Text.ToString();
		......
            }
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.InitialDirectory = Directory.GetCurrentDirectory() + "\\data\\";
                sfd.Filter = "Excel表格|*.xls";
                sfd.ShowDialog();
                string path = sfd.FileName;
                xlWorkBook.SaveAs(path, XlFileFormat.xlExcel7, misValue, misValue, misValue, misValue, XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
                xlWorkBook.Close(true, misValue, misValue);
                xlApp.Quit();
                MessageBox.Show("保存成功!");
            }
            catch (Exception)
            { }







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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值