全文预览已结束
下载本文档
版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领
文档简介
C#操作Excel电子表格2011-01-21 12:51:47|分类： 默认分类 |标签： |字号大中小订阅 添加引用：Microsoft Excel 11.0 Object Library ;添加：using Microsoft.Office.Interop.Excel;打开Excel文件Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Open(E:aaa.xls, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);excel1.Visible = true;新建Excel对象Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Add(XlWBATemplate.xlWBATWorksheet或true);worksheet1.Activate();/激活sheet1表excel1.Visible = true;新建Excel表Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Add(true);Worksheet worksheet1 = (Worksheet)workbook1.Worksheetssheet1;Worksheet worksheet1 =(Worksheet)workbook1.Worksheets.Add(Type.Missing,workbook1.Worksheet1, 1, Type.Missing);excel1.Visible = true;保存Excel Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Add(true);Worksheet worksheet1 = (Worksheet)workbook1.Worksheetssheet1;worksheet1 = (Worksheet)workbook1.Worksheets.Add(Type.Missing, workbook1.Worksheets1, 1, Type.Missing);worksheet1.Activate();worksheet1.Cells2, 2 = 3455555;excel1.Visible = true;excel1.DisplayAlerts = false;/不显示提示框workbook1.Close(true, d:1.xls, null);/关闭 worksheet1 = null;workbook1 = null;excel1.Quit();System.Runtime.InteropServices.Marshal.ReleaseComObject(excel1);excel1 = null; System.GC.Collect(); 关闭ExcelMicrosoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Open(E:aaa.xls, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);excel1.Visible = true;worksheet1 = null;workbook1 = null;excel1.Quit();System.Runtime.InteropServices.Marshal.ReleaseComObject(excel1);excel1 = null; System.GC.Collect();重命名Excel表名Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Add(true);Worksheet worksheet1 = (Worksheet)workbook1.Worksheetssheet1或1;worksheet1.Name = 工作计划表;excel1.Visible = true;设置或修改Excel表单元格内容Microsoft.Office.Interop.Excel.Application excel1 = newMicrosoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Add(true);Worksheet worksheet1 = (Worksheet)workbook1.Worksheetssheet1;worksheet1.Cells1, 1 = 姓名;worksheet1.Cells1, 2 = 性别;excel1.Visible = true;设置Excel表行宽和列高Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Add(true);Worksheet worksheet1 = (Worksheet)workbook1.Worksheetssheet1;worksheet1.Columns.ColumnWidth = 20;/全局行宽worksheet1.Columns.RowHeight = 20;/全局列高Range range1 = (Range) worksheet1.Cells2, 1;range1.Columns.ColumnWidth = 40;/单元格行宽range1.Columns.RowHeight = 40;/单元格列高excel1.Visible = true;设置Excel表单元格边框Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Add(true);Worksheet worksheet1 = (Worksheet)workbook1.Worksheetssheet1;Range range1 = (Range)worksheet1.Cells2, 2;range1.Borders.Color = System.Drawing.ColorTranslator.ToOle(Color.Red);range1.Borders.get_Item(XlBordersIndex.xlEdgeTop).LineStyle = XlLineStyle.xlContinuous;range1.Borders.get_Item(XlBordersIndex.xlEdgeRight).LineStyle = XlLineStyle.xlContinuous;range1.Borders.get_Item(XlBordersIndex.xlEdgeBottom).LineStyle = XlLineStyle.xlContinuous;range1.Borders.get_Item(XlBordersIndex.xlEdgeLeft).LineStyle = XlLineStyle.xlContinuous;/也可用后面的代码代替上面四项range1.BorderAround(XlLineStyle.xlContinuous, XlBorderWeight.xlThin, XlColorIndex.xlColorIndexAutomatic,null);range1.Borders.get_Item(XlBordersIndex.xlDiagonalDown).LineStyle = XlLineStyle.xlContinuous;/斜杠range1.Borders.get_Item(XlBordersIndex.xlDiagonalUp).LineStyle = XlLineStyle.xlContinuous;/反斜杠range1.Borders.get_Item(XlBordersIndex.xlDiagonalDown).Color = System.Drawing.ColorTranslator.ToOle(Color.Gold);excel1.Visible = true;Excel表块操作Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Add(true);Worksheet worksheet1 = (Worksheet)workbook1.Worksheetssheet1;Range range1 = worksheet1.get_Range(A2, E8);/选择操作块range1.Font.Bold = true;/设置黑体range1.Font.Size = 18;/设置字体大小range1.Font.Name = 仿宋;/设置字体range1.Font.Color = System.Drawing.ColorTranslator.ToOle(Color.Blue);/设置字体颜色range1.HorizontalAlignment = XlHAlign.xlHAlignCenter;/设置水平对齐方式range1.VerticalAlignment = XlVAlign.xlVAlignCenter;/设置垂直对齐方式 range1.Value2 = 123rn456;range1.Borders.get_Item(XlBordersIndex.xlEdgeTop).LineStyle = XlLineStyle.xlContinuous;range1.Borders.get_Item(XlBordersIndex.xlEdgeRight).LineStyle = XlLineStyle.xlContinuous;range1.Borders.get_Item(XlBordersIndex.xlEdgeBottom).LineStyle = XlLineStyle.xlContinuous;range1.Borders.get_Item(XlBordersIndex.xlEdgeLeft).LineStyle = XlLineStyle.xlContinuous;/也可用后面的代码代替上面四项range1.BorderAround(XlLineStyle.xlContinuous, XlBorderWeight.xlThin, XlColorIndex.xlColorIndexAutomatic,null);range1.Borders.get_Item(XlBordersIndex.xlInsideHorizontal).LineStyle = XlLineStyle.xlContinuous;/块内竖线range1.Borders.get_Item(XlBordersIndex.xlInsideVertical).LineStyle = XlLineStyle.xlContinuous;/块内横线excel1.Visible = true;Excel表单元格合并Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Add(true);Worksheet worksheet1 = (Worksheet)workbook1.Worksheetssheet1;Range range1 = worksheet1.get_Range(A2, E8);/选择操作块range1.Value2 = 123rn456;excel1.Application.DisplayAlerts = false;/使合并操作不提示警告信息range1.Merge(false);/参数为True则为每一行合并为一个单元格excel1.Application.DisplayAlerts = true;excel1.Visible = true;复制Excel表Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Add(true);Worksheet worksheet1 = (Worksheet)workbook1.Worksheetssheet1;worksheet1.Cells1, 1 = 123;worksheet1.Copy(Type.Missing, worksheet1);Worksheet worksheet2 =(Worksheet)worksheet1.Next; /worksheet2.Name = Sheet2;excel1.Visible = true; 页面设置Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();Workbook workbook1 = excel1.Workbooks.Add(true);excel1.Caption = 我的报表;Worksheet worksheet1 = (Worksheet)workbook1.Worksheetssheet1; worksheet1.PageSetup.PaperSize = XlPaperSize.xlPaperA3;/纸张大小worksheet1.PageSetup.PrintTitleRows =
温馨提示
- 1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2025广西百色市平果市民政局公益性岗位人员招聘1人考前自测高频考点模拟试题附答案详解（模拟题）
- 2025河南郑州市新郑市面向社会聘任政务服务社会监督员、政务服务体验员10人考前自测高频考点模拟试题附答案详解（完整版）
- 2025年冀北博望电力产业管理（北京）有限公司高校毕业生招聘（第三批）模拟试卷及答案详解（易错题）
- 2025中电信翼智教育科技有限公司招聘6人笔试题库历年考点版附带答案详解
- 2025中国电信股份有限公司广东分公司校园招聘笔试题库历年考点版附带答案详解
- 2025中国东航东航股份规划部2025校园招聘笔试题库历年考点版附带答案详解
- 2025中外合作项目合同协议书
- 2025-2026学年云南省文山州富宁县上海市新纪元总校高二（上）月考数学试卷（9月份）（含答案）
- 定期安全人员培训课件
- 2025年国际贸易合作协议
- 电商行业员工行为规范与工作手册
- 借款合同中国农业银行担保借款合同3篇
- 建筑装修工程质量监督管理制度
- 不锈钢栏杆施工全流程方案
- 2025住院医师规范化培训院内师资培训考核测试题附答案
- 《一定要争气》（第2课时） 课件 小学语文部编版三年级上册
- 血透室护士手卫生
- USP232-233标准文本及中英文对照
- 部编版八上语文名著《红岩》问答题精练（教师版）
- 2025-2026学年人教精通版四年级英语上册（全册）教学设计（附目录）
- 2025年秋期人教版2年级上册数学核心素养教案(校园小导游)（教学反思有内容+二次备课版）
评论
0/150
提交评论