• 格式太旧或是类型库无效。 (Exception from HRESULT: 0x80028019 (TYPE_E_UNSUPFORMAT))


    错误提示信息

    格式太旧或是类型库无效。 (Exception from HRESULT: 0x80028019 (TYPE_E_UNSUPFORMAT)) 。

    Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))。

    出现时间

    并行大批量数据处理操作时随机出现(使用的是ArcGIS COM库)。

    原因:

    这是网络中找到的使用Excel进行COM对象互操作时的解释:

    After digging the internet I found out that there is a bug in Microsoft Interop with COM objects (at least with my case which is MS Excel 2010).

    The bug is that .NET checks that your thread (C# or VB code) localization is suitable to MS Excel localization you installed earlier, and if not it tells that the Microsoft.Office.Interop library is old or invalid.

    Your thread localization is derived from your computer regional settings (from the control panel --> regional and language)

    Then there are two options to solve this problem:

    1. To change your thread localization (by code)
    2. Install language pack for your Office

    解决方案:

    线程启动时,设置当前线程的CultureInfo与互操作库一致。

    When a thread is started, its culture is initially determined by using GetUserDefaultLCID from the Windows API. I found no way (I assume there is no way) to override this behavior. Only thing you can do is to set the thread culture afterwards.

    I wrote an extension. For that:

    public static class ParallelQueryCultureExtensions
    {
        public static ParallelQuery<TSource> SetCulture<TSource>(this ParallelQuery<TSource> source, CultureInfo cultureInfo)
        {
            SetCulture(cultureInfo);
            return source
                .Select(
                    item =>
                        {
                            SetCulture(cultureInfo);
                            return item;
                        });
        }
    
        private static void SetCulture(CultureInfo cultureInfo) {
            if (Thread.CurrentThread.CurrentCulture != cultureInfo) {
                Thread.CurrentThread.CurrentCulture = cultureInfo;
            }
        }
    } 
    

    So if you use it just after splitting up the original source using .AsParallel() you will get what you want.

    注:

    当内存溢出时,也可能导致该错误的出现。

  • 相关阅读:
    只打开一次浏览器,生成html测试报告<小紧张中......>
    hadoop学习第四天-Writable和WritableComparable序列化接口的使用&&MapReduce中传递javaBean的简单例子
    hadoop学习第三天-MapReduce介绍&&WordCount示例&&倒排索引示例
    hadoop学习第二天-了解HDFS的基本概念&&分布式集群的搭建&&HDFS基本命令的使用
    hadoop学习第一天-hadoop初步环境搭建&伪分布式计算配置(详细)
    大三了,写写博客
    方向问题
    第一天注册博客
    jquery跨域请求事例
    ECharts学习记录
  • 原文地址:https://www.cnblogs.com/dadream/p/4843937.html
Copyright © 2020-2023  润新知