如何打开一个已有的excel文件并进行操作? excel.application.open(你的excel文件的路径) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 老外操作的是Excel 2000,所有Excel的程序操作都来源于Excel的对象库Excel9.olb.本例也只是对这个东东做一个简单的操作了解。 首先的一步就是使用Tlbimp.exe这个工具将Excel9.0的对象库文件Excel8.olb转换成为dll,这样才能做为.Net平台Assembly来使用:)操作如下: TlbImp Excel9.olb Excel.dll 只要有了这个Excel.dll,现在我们就能使用Excel的各种操作函数了。 下面就让我们具体看看C#是如何使用这些东东吧。 1. 创建一个新Excel的Application: Application exc = new Application(); if (exc == null) { Console.WriteLine("ERROR: EXCEL couldn''''t be started"); return 0; } 2. 让这个工程可见: exc.set_Visible(0, true); 3. 获取WorkBooks集合: Workbooks workbooks = exc.Workbooks; 4. 加入新的WorkBook: _Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet, 0); 5. 获取WorkSheets集合: _Worksheet worksheet = (_Worksheet) sheets.get_Item(1); if (worksheet == null) { Console.WriteLine ("ERROR in worksheet == null"); } 6. 给单元格设置变量: Range range1 = worksheet.get_Range("C1", Missing.Value); if (range1 == null) { Console.WriteLine ("ERROR: range == null"); } const int nCells = 1; Object[] args1 = new Object[1]; args1[0] = nCells; range1.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, range1, args1); 例程: using System; using System.Reflection; using System.Runtime.InteropServices; using Excel; class Excel { public static int Main() { Application exc = new Application(); if (exc == null) { Console.WriteLine("ERROR: EXCEL couldn''''t be started!"); return 0; } exc.set_Visible(0, true); Workbooks workbooks = exc.Workbooks; _Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet, 0); Sheets sheets = workbook.Worksheets; _Worksheet worksheet = (_Worksheet) sheets.get_Item(1); if (worksheet == null) { Console.WriteLine ("ERROR: worksheet == null"); } Range range1 = worksheet.get_Range("C1", Missing.Value); if (range1 == null) { Console.WriteLine ("ERROR: range == null"); } const int nCells = 1; Object[] args1 = new Object[1]; args1[0] = nCells; range1.GetType().InvokeMember("Value", BindingFlags.SetProperty, null,range1, args1); return 100; } } 现在我们来看看如何使用数组,他有些类似于设置单元格。仅仅需要的改变只是args2[0] = array2; const int nCell = 5; Range range2 = worksheet.get_Range("A1", "E1"); int[] array2 = new int [nCell]; for (int i=0; i < array2.GetLength(0); i++) { array2[i] = i+1; } Object[] args2 = new Object[1]; args2[0] = array2; range2.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, range2, args2); 输出结果: 总结: 大家需要了解Tlbimp.exe 这个工具的使用啊:)这个东东很有用,可以将普通Win32程序移植到.Net下面来盗用的!:):):) 经过n的平方个晚上,我终于从一篇介绍VC调用Excel的文件中找到了解决办法: object vtMissing=Missing.Value; myExcel.Run("宏1",vtMissing,vtMissing, vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing, vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing, vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing, vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing); 遗憾的是不能修改宏,但我可以在录制宏时先选中单元格再录制,这样就很灵活了。 数据库在软件开发中的作用 怎么在from窗体中找到自定义控件中的 label 控件,还要给他的text 属性赋值! 各位大神请帮帮我!! GraphicsPath问题。。。 抠图的问题 c#强签名问题 正则匹配问题 怎样在安装过程中,能根据修改WEB.CONFIG. 在GDI+中如何实现SetRop2的功能 给大家一个买C#书籍的提醒。 怎样调用对话框? 请问,为什么通过抓网页的程序抓回来的内容与直接访问的内容不同
首先的一步就是使用Tlbimp.exe这个工具将Excel9.0的对象库文件Excel8.olb转换成为dll,这样才能做为.Net平台Assembly来使用:)操作如下:
TlbImp Excel9.olb Excel.dll
只要有了这个Excel.dll,现在我们就能使用Excel的各种操作函数了。
下面就让我们具体看看C#是如何使用这些东东吧。
1. 创建一个新Excel的Application:
Application exc = new Application();
if (exc == null) {
Console.WriteLine("ERROR: EXCEL couldn''''t be started");
return 0;
}
2. 让这个工程可见:
exc.set_Visible(0, true);
3. 获取WorkBooks集合:
Workbooks workbooks = exc.Workbooks;
4. 加入新的WorkBook:
_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet, 0);
5. 获取WorkSheets集合:
_Worksheet worksheet = (_Worksheet) sheets.get_Item(1);
if (worksheet == null) {
Console.WriteLine ("ERROR in worksheet == null");
}
6. 给单元格设置变量:
Range range1 = worksheet.get_Range("C1", Missing.Value);
if (range1 == null) {
Console.WriteLine ("ERROR: range == null");
}
const int nCells = 1;
Object[] args1 = new Object[1];
args1[0] = nCells;
range1.GetType().InvokeMember("Value", BindingFlags.SetProperty, null,
range1, args1);
例程:
using System;
using System.Reflection;
using System.Runtime.InteropServices;
using Excel; class Excel {
public static int Main() {
Application exc = new Application();
if (exc == null) {
Console.WriteLine("ERROR: EXCEL couldn''''t be started!");
return 0;
}
exc.set_Visible(0, true);
Workbooks workbooks = exc.Workbooks;
_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet, 0);
Sheets sheets = workbook.Worksheets; _Worksheet worksheet = (_Worksheet) sheets.get_Item(1);
if (worksheet == null) {
Console.WriteLine ("ERROR: worksheet == null");
}
Range range1 = worksheet.get_Range("C1", Missing.Value);
if (range1 == null) {
Console.WriteLine ("ERROR: range == null");
}
const int nCells = 1;
Object[] args1 = new Object[1];
args1[0] = nCells;
range1.GetType().InvokeMember("Value", BindingFlags.SetProperty, null,range1, args1);
return 100;
}
}
现在我们来看看如何使用数组,他有些类似于设置单元格。仅仅需要的改变只是args2[0] = array2;
const int nCell = 5;
Range range2 = worksheet.get_Range("A1", "E1");
int[] array2 = new int [nCell];
for (int i=0; i < array2.GetLength(0); i++) {
array2[i] = i+1;
}
Object[] args2 = new Object[1];
args2[0] = array2;
range2.GetType().InvokeMember("Value", BindingFlags.SetProperty,
null, range2, args2);
输出结果:
总结:
大家需要了解Tlbimp.exe 这个工具的使用啊:)这个东东很有用,可以将普通Win32程序移植到.Net下面来盗用的!:):):)
object vtMissing=Missing.Value;
myExcel.Run("宏1",vtMissing,vtMissing, vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing, vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing, vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing, vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing);
遗憾的是不能修改宏,但我可以在录制宏时先选中单元格再录制,这样就很灵活了。