Beispiel #1
0
        /// <summary>
        /// 获取Excel工作簿文档属性
        /// </summary>
        /// <param name="key"></param>
        /// <returns></returns>
        public object GetWorkbookDocementProperties(string key)
        {
            var collection = Workbook.Worksheets.BuiltInDocumentProperties;

            if (collection.Contains(key))
            {
                DocumentProperty doc = collection[key];
                switch (doc.Type)
                {
                case PropertyType.Boolean:
                    return(doc.ToBool());

                case PropertyType.DateTime:
                    return(doc.ToDateTime());

                case PropertyType.Double:
                    return(doc.ToDouble());

                case PropertyType.Number:
                    return(doc.ToInt());

                case PropertyType.String:
                    return(doc.ToString());

                default:
                    return(null);
                }
            }
            return(null);
        }
Beispiel #2
0
    private static void smethod_5(DocumentProperty A_0, Class398 A_1, bool A_2)
    {
        int num = 11;

        A_1.method_4(smethod_6(A_0.Name));
        switch (A_0.ValueType)
        {
        case PropertyValueType.Boolean:
            A_1.method_18(BookmarkStart.b("唰䜲༴匶䴸", num), BookmarkStart.b("匰尲娴嬶尸娺匼", num));
            A_1.method_15(A_0.ToBool() ? BookmarkStart.b("0", num) : BookmarkStart.b("İ", num));
            break;

        case PropertyValueType.Date:
            A_1.method_18(BookmarkStart.b("唰䜲༴匶䴸", num), BookmarkStart.b("唰刲䄴制洸刺值娾潀㝂㽄", num));
            A_1.method_15(Class1041.smethod_0(A_0.ToDateTime()));
            break;

        case PropertyValueType.Float:
        case PropertyValueType.Int:
            A_1.method_18(BookmarkStart.b("唰䜲༴匶䴸", num), BookmarkStart.b("地弲娴嘶䴸", num));
            A_1.method_15(A_0.ToString());
            break;

        case PropertyValueType.Double:
            A_1.method_18(BookmarkStart.b("唰䜲༴匶䴸", num), BookmarkStart.b("地弲娴嘶䴸", num));
            A_1.method_15(Class1041.smethod_44(A_0.ToDouble()));
            break;

        case PropertyValueType.String:
            A_1.method_18(BookmarkStart.b("唰䜲༴匶䴸", num), BookmarkStart.b("䈰䜲䜴帶圸尺", num));
            A_1.method_40(BookmarkStart.b("崰娲嬴尶", num), A_0.LinkSource);
            A_1.method_15(smethod_3(A_0.ToString(), A_2));
            break;

        default:
            throw new InvalidOperationException(BookmarkStart.b("搰崲倴伶䤸帺帼䬾⑀❂敄㝆㭈⑊㵌⩎⍐❒ⱔ睖ⵘ≚ⵜ㩞你", num));
        }
        A_1.method_5();
    }