c#导出Excel数据之常用对象

需要引入Microsoft Office 11.0 Object LibraryCOM组件

 

           // 定义Application 对象,此对象表示整个Excel 程序

            Excel.Application ExApp = new Excel.Application();

 

            if (ExApp == null)

            {

                MessageBox.Show("无法创建Excel对象，可能你的电脑未安装Excel或你的Excel版本不是Office2003的!");

                return;

            }

 

            //程序运行方式为前台显示

            ExApp.Visible = true;

 

            //定义的Excel工作对象

            Excel.Workbooks ExBooks = ExApp.Workbooks;

            Excel.Workbook ExBook = ExBooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);

 

            // 定义Worksheet 对象,此对象表示Execel 中的第一张工作表

            Excel.Worksheet ExSheet = (Excel.Worksheet)ExBook.Worksheets[1];

            // 命名工作表的名称为 "工作表一"

            ExSheet.Name = "工作表一";

            //设置单元格格式为文本格式

　　　　　ExSheet.Cells.NumberFormatLocal := '@' ;

 

            //设置单元格的值

            ExSheet.Cells[1, 3] = "江波";

 

            //选择单元格

            Excel.Range range = ExSheet.get_Range(ExSheet.Cells[5, 6], ExSheet.Cells[8, 9]);

            //合并单元格

            range.Merge(System.Reflection.Missing.Value);

            //选中的单元格内的值

            range.Value2 = "QQ;261025448";

            //设置内容对齐方式为居中

            range.HorizontalAlignment = Excel.XlVAlign.xlVAlignCenter;

 

            #region 调整单元格格式，并保存文件

            ExSheet.Cells.EntireColumn.AutoFit();

            ExBook.Saved = true;

            ExBook.SaveCopyAs("C:\\test.xls");

            System.Runtime.InteropServices.Marshal.ReleaseComObject(ExSheet);

            ExSheet = null;

            Marshal.ReleaseComObject(ExBook);

            ExBook = null;

            ExBooks.Close();

            Marshal.ReleaseComObject(ExBooks);

            ExBooks = null;

            ExApp.Quit();

            Marshal.ReleaseComObject(ExApp);

            ExApp = null;

            #endregion