在C#中,您可以用以下方法来指定COM中的可选参数:
using System.Reflection;
. . .
. . .
//System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
Excel.Application excel = new Excel.Application();
Excel.Workbook ewb = excel.Workbooks.Open(@"f:\sample.xls",Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
另外,目前在非en-US culture下,在.NET中使用Excel还存在一些问题,所以,如果您遇到了问题,可以如上加入System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");一句来事先改变一下culture.
关于在C#.NET中使用Excel的更详细的示例代码,您可以参考以下一些文档:
HOWTO: Automate Microsoft Excel from Visual C# .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q302084
HOWTO: Fill/Retrieve Excel Data Using Arrays With C# .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q302084
HOW TO: Handle Events for Excel by Using Visual C# .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q302815
- 微软全球技术中心 VB技术支持
原地址:http://hi.baidu.com/limeng_hoho/item/479dd9776821d25a0c0a076a