System.Reflection.Missing.Value的应用

最新推荐文章于 2019-07-21 08:05:49 发布
转载 最新推荐文章于 2019-07-21 08:05:49 发布 · 1.7k 阅读 · 1

本文介绍如何在C#中通过指定COM中的可选参数来操作Excel，并提供了一个具体的示例代码，展示了如何打开一个Excel文件并处理可能出现的文化设置问题。

在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   

 

转自：http://hi.baidu.com/limeng_hoho/item/479dd9776821d25a0c0a076a

文档管理系统 之一 doc、xls、ppt文档转换成html及System.Runtime.InteropServices.COMException (0x80004005): 360的问题
iPhone7z的专栏
05-05 1420
公司最近需要一套文档管理系统，其实功能很简单，能上传、显示文档，根据权限能否下载、复制、查看   网上也有很多，试用了一下感觉功能都太花哨，都是着重协同办公功能   因为功能不多，所以自己写一个也不费劲，思路如下： 1.先解决文档上传、转换的功能 2.权限管理功能   文档上传转换，将上传的doc、xls、ppt文档转换成html格式，显示时通过js脚本禁止复制   昨天上传转
c# 处理Excel数据
weixin_41708020的博客
05-15 1460
c# 处理Excel数据 处理方法 （1）可以导入一些插件，如下载NPOI文件包,下载那个微软的Microsoft.Office.Interop.Excel，也可以 （2）用类似mysql的方式连接，这个可以减少很多痛苦… （1）代码如下： public static void DealExcelToMySQL() { //创建 Excel对象 Application App = new Application();
Type.Missing和System.Reflection.Missing.Value
weixin_34302561的博客
10-23 276
Type.Missing https://msdn.microsoft.com/en-us/library/system.type.missing(v=vs.110).aspx   Missing.Value https://msdn.microsoft.com/en-us/library/system.reflection.missing.value(v=vs.110).aspx   ...
System.Reflection.Missing
weixin_30627381的博客
07-21 492
在写外来对象组件操作过程中，有时对调用的方法中不用的参数调用Null错误，填充此参数即可。 Excel.Workbookwb=ThisApplication.Workbooks.Open(@"c:\YourPath\YourWorkbook.xls",Type.Missing,Type.Missing,Type.Missing,Type.Missing,Typ...
System.Reflection.Missing.Value与Type.Missing
weixin_30302609的博客
04-21 491
表示type 信息中的缺少值。字段为只读。 使用 Missing 字段通过反射进行调用，以获取参数的默认值。如果传入一个参数值的 Missing 字段，并且该参数没有默认值，则引发异常。 Type.Missing定义为: public static readonly object Missing; Type类的构造函数中为此字段进行了初始化，代码为： Type.Missi...
反射中"System.Reflection.Missing.Value"是怎么获值的?
Sharpend的专栏
10-04 1785
反射中"System.Reflection.Missing.Value"是怎么获值的?
Application wordApp = new Application(); wordApp.Visible = false; object missing = System.Reflection.Missing.Value; Document wordDoc = wordApp.Documents.Open(filePath); // 获取文档中的第一个表格 Table table = wordDoc.Tables[1]; Cell cell = table.Cell(2, 2);往cell中写入小四宋体“$123456$”
06-01
### 在Word文档的表格单元格中写入特定格式文本的方法 在C#中，可以使用Aspose.Words库来操作Word文档中的表格，并向单元格写入带有特定格式的文本。以下是一个示例代码，展示如何将小四宋体格式的文本“$123456$”...
此段代码报错CS1061“ContentControl"未包含”checkedSymbol“的定义，并且找不到可接受第一个”ContentControl“类型参数的可访问扩展方法”CheckedSymbol“(是否缺少using指令或程序集引用)请帮忙修改并给出修改后的代码using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.Office.Interop.Word; using System.Windows.Forms; using System.IO; using System.Xml.Linq; using Word = Microsoft.Office.Interop.Word; using static System.Windows.Forms.VisualStyles.VisualStyleElement.Button; using System.Security.Cryptography; using System.Drawing; namespace Export { class MyAPQP { public static void WdExport() { //新增一个word文档 object noThing = System.Reflection.Missing.Value; Document wdDoc = MyWord.WdApplication.Documents.Add(Template: ref noThing, NewTemplate: ref noThing, DocumentType: ref noThing, Visible: ref noThing); #region 页面及样式设置 MyWord.SetPageSetup(document: wdDoc); //页面设置 MyWord.SetStyle(document: wdDoc, styleType: WdBuiltinStyle.wdStyleNormal, fontSize: 9.0f, paragraphAlignment: WdParagraphAlignment.wdAlignParagraphLeft); //正文样式(WdBuiltinStyle.wdStyleNormal)设置 小五 MyWord.SetStyle(document: wdDoc, styleType: WdBuiltinStyle.wdStyleHeader, fontSize: 9.0f, paragraphAlignment: WdParagraphAlignment.wdAlignParagraphCenter); //页眉样式(WdBuiltinStyle.wdStyleHeader)设置 小五 MyWord.SetStyle(document: wdDoc, styleType: WdBuiltinStyle.wdStyleFooter, fontSize: 9.0f, paragraphAlignment: WdParagraphAlignment.wdAlignParagraphCenter); //页脚样式(WdBuiltinStyle.wdStyleFooter)设置 小五 MyWord.SetStyle(document: wdDoc, styleType: WdBuiltinStyle.wdStyleTitle, fontSize: 14.0f, paragraphAlignment: WdParagraphAlignment.wdAlignParagraphCenter, spaceBefore: 4.0f, spaceAfter: 4.0f); //标题样式(WdBuiltinStyle.wdStyleTitle)设置 四号 MyWord.SetStyle(document: wdDoc, styleType: WdBuiltinStyle.wdStyleHeading1, fontSize: 12.0f, paragraphAlignment: WdParagraphAlignment.wdAlignParagraphL
03-13
set { SetValue(CheckedSymbolProperty, value); } } } } ``` ### XAML使用示例 ```xml <!-- 在窗口/用户控件头部添加命名空间 --> xmlns:controls="clr-namespace:Export.Controls" <!-- 替换原有...
Assembly 'Assets/Plugins/System.Collections.Immutable.dll' will not be loaded due to errors: Unable to resolve reference 'System.Runtime.CompilerServices.Unsafe'. Is the assembly missing or incompatible with the current platform? Reference validation can be disabled in the Plugin Inspector.
08-31
using System.Reflection; using System.IO; using UnityEngine; public class AssemblyDependencyChecker : EditorWindow { [MenuItem("Tools/Check Assembly Dependencies")] public static void Check...
exception was thrown while activating Castle.Proxies.AirCityAPPAttendanceServiceProxy -> Castle.Proxies.EquipmentAnalysisServiceProxy -> AirCity.Services.Asset.Application.Device.DeviceManagementAppService -> AirCity.Services.Asset.Application.Device.InventoryRecordAppService.] [ operacityproduct] [e0127d8f52964b0b978a8b770a5f208c] Autofac.Core.DependencyResolutionException: An exception was thrown while activating Castle.Proxies.AirCityAPPAttendanceServiceProxy -> Castle.Proxies.EquipmentAnalysisServiceProxy -> AirCity.Services.Asset.Application.Device.DeviceManagementAppService -> AirCity.Services.Asset.Application.Device.InventoryRecordAppService. ---------- Exception Data ---------- ActivatorChain = Castle.Proxies.AirCityAPPAttendanceServiceProxy -> Castle.Proxies.EquipmentAnalysisServiceProxy -> AirCity.Services.Asset.Application.Device.DeviceManagementAppService -> AirCity.Services.Asset.Application.Device.InventoryRecordAppService ---> Autofac.Core.DependencyResolutionException: None of the constructors found with 'Autofac.Core.Activators.Reflection.DefaultConstructorFinder' on type 'AirCity.Services.Asset.Application.Device.InventoryRecordAppService' can be invoked with the available services and parameters: 2025-11-21 11:52:02.680 +08:00Cannot resolve parameter 'Volo.Abp.Domain.Repositories.IRepository`2[Suncere.AirCityProduct.Models.InventoryRecord,System.Int32] inventoryRecordRepository' of constructor 'Void .ctor(Volo.Abp.Domain.Repositories.IRepository`2[Suncere.AirCityProduct.Models.InventoryRecord,System.Int32], Microsoft.Extensions.Logging.ILogger`1[AirCity.Services.Asset.Application.Device.InventoryRecordAppService], Volo.Abp.Domain.Repositories.IRepository`1[Suncere.AirCityProduct.Models.BSDDevice])'. [ at Autofac.Core.Activators.Reflection.ReflectionActivator.GetValidConstructorBindings(ConstructorInfo[] availableConstructors, IComponentContext context, IEnumerable`1 parameters) INF at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters) at Autofac.Core.Resolving.InstanceLookup.CreateInstance(IEnumerable`1 parameters) ] [ --- End of inner exception stack trace --- operacityproduct at Autofac.Core.Resolving.InstanceLookup.CreateInstance(IEnumerable`1 parameters) ] [ at Autofac.Core.Resolving.InstanceLookup.Execute() e0127d8f52964b0b978a8b770a5f208c at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, ResolveRequest request) at Autofac.Core.Resolving.ResolveOperation.Execute(ResolveRequest request) ] at Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance) Executing ObjectResult, writing value of type ' at Autofac.ResolutionExtensions.ResolveService(IComponentContext context, Service service, IEnumerable`1 parameters) Suncere.Abp.Application.Contracts.Dtos.RemoteServiceResponseDto`1[[System.Object, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]] at Microsoft.AspNetCore.Mvc.Controllers.ServiceBasedControllerActivator.Create(ControllerContext actionContext) '. at Microsoft.AspNetCore.Mvc.Controllers.ControllerFactoryProvider.<>c__DisplayClass5_0.<CreateControllerFactory>g__CreateController|0(ControllerContext controllerContext) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location where exception was thrown --- 2025-11-21 11:52:02.686 +08:00 at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) [[INF11:52:02 ] [operacityproductERR] [] e0127d8f52964b0b978a8b770a5f208c---------- Exception Data ---------- ActivatorChain = Castle.Proxies.AirCityAPPAttendanceServiceProxy -> Castle.Proxies.EquipmentAnalysisServiceProxy -> AirCity.Services.Asset.Application.Device.DeviceManagementAppService -> AirCity.Services.Asset.Application.Device.InventoryRecordAppService ] Executed action [AirCity.Services.OperaBase.Application.KaoQin.AirCityAPPAttendanceService.GetAttendanceManagement (AirOpera.Services.OperaBase.Application)11:52:02 in 29.8185INFms] Executing ObjectResult, writing value of type '2025-11-21 11:52:02.689 +08:00Suncere.Abp.Application.Contracts.Dtos.RemoteServiceResponseDto`1[[System.Object, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]] [DBG'. ] [[11:52:02operacityproduct ] [INFe0127d8f52964b0b978a8b770a5f208c] ] HandleAfterActionEvent: Missing span contextExecuted action 2025-11-21 11:52:02.690 +08:00AirCity.Services.OperaBase.Application.KaoQin.AirCityAPPAttendanceService.GetAttendanceManagement (AirOpera.Services.OperaBase.Application) [INF in ] [29.8185operacityproductms] [ [11:52:02e0127d8f52964b0b978a8b770a5f208c DBG] ] HandleAfterActionEvent: Missing span contextExecuted endpoint ' AirCity.Services.OperaBase.Application.KaoQin.AirCityAPPAttendanceService.GetAttendanceManagement (AirOpera.Services.OperaBase.Application)' [2025-11-21 11:52:02.692 +08:0011:52:02 [ INFINF] ] [Executed endpoint 'operacityproduct] [AirCity.Services.OperaBase.Application.KaoQin.AirCityAPPAttendanceService.GetAttendanceManagement (AirOpera.Services.OperaBase.Application)'] Request finished in 44.1754ms 500 application/json; charset=utf-8 [11:52:02 INF] Request finished in 44.1754ms 500 application/json; charset=utf-8 2025-11-21 11:52:02.694 +08:00 [DBG] [operacityproduct] [] HandleStartEvent: Ignoring path: /api/v2/spans [11:52:02 DBG] HandleStartEvent: Ignoring path: /api/v2/spans 2025-11-21 11:52:04.335 +08:00 [DBG] [operacityproduct] [] HandleStartEvent: Ignoring path: /api/v2/spans [11:52:04 DBG] HandleStartEvent: Ignoring path: /api/v2/spans 2025-11-21 11:52:05.242 +08:00 [DBG] [operacityproduct] [] HandleExceptionEvent: Missing span context [11:52:052025-11-21 11:52:05.244 +08:00 [ DBGDBG] [] operacityproduct] [HandleExceptionEvent: Missing span context ] HandleStopEvent: Missing span context [11:52:05 DBG] HandleStopEvent: Missing span context 2025-11-21 11:52:05.256 +08:00 [DBG] [operacityproduct] [] HandleExceptionEvent: Missing span context [2025-11-21 11:52:05.257 +08:0011:52:05 [DBG ] [DBGoperacityproduct] [] ] HandleExceptionEvent: Missing span context HandleStopEvent: Missing span context [11:52:05 DBG] HandleStopEvent: Missing span context
最新发布
11-22
Autofac.Core.DependencyResolutionException: None of the constructors found with 'Autofac.Core.Activators.Reflection.DefaultConstructorFinder' on type 'AirCity.Services.Asset.Application.Device....
C#中创建、打开、读取、写入、保存Exce，C#如何向EXCEL写入数据
热门推荐
kirawoo的专栏
06-19 5万+
C#中创建、打开、读取、写入、保存Excel的一般性代码 首先，在引用的COM中找到Microsoft Excel 11.0 Object Library，添加。 using System;  using System.Reflection; // 引用这个才能使用Missing字段  using Excel; namespace CExcel1  {  class Class1
C#中操作Excel（5）—— 操作Excel的两种技术（一）--COM技术
Hyman的博客
11-24 2948
一、引言         本文主要介绍操作Excel的两种技术，第一种就是我们之前的文章中一直在使用的COM技术，而另一种是使用OLEDB技术。两种方法各有优势和缺点，前者利用COM接口操作Excel，更加自由和灵活，可以自由的设置单元格格式等等，但是数据量较大时存在性能瓶颈。后者把Excel当成一个数据库，读取速度较快，但是无法设置Excel的格式。下面分别介绍两种技术，在此之前我们先布置试验
C#读取excel文件，报“外部表不是预期的格式”的解决办法
question00的专栏
05-18 1万+
C#读取excel文件，报“外部表不是预期的格式”的解决办法
C#操作Excel总结
weixin_34144450的博客
06-03 1521
0. 导入命名空间：  using Microsoft.Office.Core; using Microsoft.Office.Interop.Excel; using System.IO; using System.Reflection;   1. 如何打开已有excel文档，或者创建一个新的excel文档    Application app = new Applicati...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值