C#操作文件

来源:互联网 发布:java自学书籍 编辑:程序博客网 时间:2024/04/30 05:20

try
            {
                Excel.ApplicationClass MyExcel = new Excel.ApplicationClass();
                MyExcel.Visible = true;
                if (MyExcel == null)
                {
                    MessageBox.Show("EXECEL无法启动!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                Excel.Workbooks MyWorkBooks = MyExcel.Workbooks;
                Excel.Workbook MyWorkBook = MyWorkBooks.Add(Missing.Value);
                Excel.Worksheet MyWorkSheet = (Excel.Worksheet)MyWorkBook.Worksheets[1];
                Excel.Range MyRange = MyWorkSheet.get_Range("A1", "C1");
                object[] MyHeader = { "姓名", "专业", "毕业院校" };
                MyRange.Value2 = MyHeader;
                if (this.listView1.Items.Count > 0)
                {
                    MyRange = MyWorkSheet.get_Range("A2", Missing.Value);
                    object[,] MyData = new Object[this.listView1.Items.Count, 3];

                    foreach (ListViewItem lvi in this.listView1.Items)
                    {
                        MyData[lvi.Index, 0] = lvi.Text;
                        MyData[lvi.Index, 1] = lvi.SubItems[1].Text;
                        MyData[lvi.Index, 2] = lvi.SubItems[2].Text;
                    }
                    MyRange = MyRange.get_Resize(this.listView1.Items.Count, 3);
                    MyRange.Value2 = MyData;
                    MyRange.EntireColumn.AutoFit();
                }
                MyExcel = null;
            }
            catch (Exception Err)
            {
                MessageBox.Show("调用EXCEL程序出错!" + Err.Message, "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }