如何查看excel,cells属性，请位大侠！

nameld001

  就是在连接excelj时，f 为个一个"sheet1" 的对像,(setq a (vlax-get-property f "cells")"后怎样查看a里面的属性及方法，每次运行都说虚拟内存不足，但又想查看里面的属性，怎么办呢

liu_kunlun

参考帮助的例子:

(vlax-get-property acadObject 'ActiveDocument)

是不是应该写成

(vlax-get-property f 'cells)?

nameld001

谢谢，好像都一样的吧

mmmmmm

去http://www.atablex.com参考VLXLS Project的源代码。

xtjd

(vlax-dump-object f t)
; _Worksheet: nil
;性质值:
;   Application (RO) = #<VLA-OBJECT _Application 05f7173c>
;   AutoFilter (RO) = nil
;   AutoFilterMode = 0
;   Cells (RO) = #<VLA-OBJECT Range 0017e85c>
;   CircularReference (RO) = nil
;   CodeName (RO) = ""
;   Columns (RO) = #<VLA-OBJECT Range 0017e7cc>
;   Comments (RO) = #<VLA-OBJECT Comments 0017e714>
;   ConsolidationFunction (RO) = -4157
;   ConsolidationOptions (RO) = 在 \develop\global\src\coreapps\lpp\LPPCOM\SRC\IDISP.CPP 档案，138 行中的要求失败:
lBound == 0

;   ConsolidationSources (RO) = nil
;   Creator (RO) = 1480803660
;   CustomProperties (RO) = #<VLA-OBJECT CustomProperties 0017e684>
;   DisplayPageBreaks = 0
;   DisplayRightToLeft = 0
;   EnableAutoFilter = 0
;   EnableCalculation = -1
;   EnableOutlining = 0
;   EnablePivotTable = 0
;   EnableSelection = 0
;   FilterMode (RO) = 0
;   HPageBreaks (RO) = #<VLA-OBJECT HPageBreaks 05753d6c>
;   Hyperlinks (RO) = #<VLA-OBJECT Hyperlinks 05e3242c>
;   Index (RO) = 1
;   ListObjects (RO) = #<VLA-OBJECT ListObjects 05e18864>
;   MailEnvelope (RO) = #<VLA-OBJECT IMsoEnvelopeVB 05e186fc>
;   Name = "Sheet1"
;   Names (RO) = #<VLA-OBJECT Names 05e32504>
;   Next (RO) = #<VLA-OBJECT _Worksheet 05efd64c>
;   Outline (RO) = #<VLA-OBJECT Outline 05e326ac>
;   PageSetup (RO) = #<VLA-OBJECT PageSetup 0017f214>
;   Parent (RO) = #<VLA-OBJECT _Workbook 05ef74d4>
;   Previous (RO) = nil
;   ProtectContents (RO) = 0
;   ProtectDrawingObjects (RO) = 0
;   Protection (RO) = #<VLA-OBJECT Protection 0017edb4>
;   ProtectionMode (RO) = 0
;   ProtectScenarios (RO) = 0
;   QueryTables (RO) = #<VLA-OBJECT QueryTables 05dd1bc4>
;   Range (RO) = ...未展示索引内容...
;   Rows (RO) = #<VLA-OBJECT Range 0572c674>
;   Scripts (RO) = #<VLA-OBJECT Scripts 056a6c24>
;   ScrollArea = ""
;   Shapes (RO) = #<VLA-OBJECT Shapes 05f34eb4>
;   SmartTags (RO) = #<VLA-OBJECT SmartTags 056a63ec>
;   StandardHeight (RO) = 16.5
;   StandardWidth = 8.38
;   Tab (RO) = #<VLA-OBJECT Tab 0017ed6c>
;   TransitionExpEval = 0
;   TransitionFormEntry = 0
;   Type (RO) = -4167
;   UsedRange (RO) = #<VLA-OBJECT Range 0572c7bc>
;   Visible = -1
;   VPageBreaks (RO) = #<VLA-OBJECT VPageBreaks 05f88114>
;   _CodeName = ""
;支援的方法:
;   Activate ()
;   Calculate ()
;   ChartObjects (1)
;   CheckSpelling (4)
;   CircleInvalid ()
;   ClearArrows ()
;   ClearCircles ()
;   Copy (2)
;   Delete ()
;   Evaluate (1)
;   Move (2)
;   OLEObjects (1)
;   Paste (2)
;   PasteSpecial (7)
;   PivotTables (1)
;   PivotTableWizard (16)
;   PrintOut (8)
;   PrintPreview (1)
;   Protect (16)
;   ResetAllPageBreaks ()
;   SaveAs (10)
;   Scenarios (1)
;   Select (1)
;   SetBackgroundPicture (1)
;   ShowAllData ()
;   ShowDataForm ()
;   Unprotect (1)
;   XmlDataQuery (3)
;   XmlMapQuery (3)
;   _Evaluate (1)
T

明27662

我也碰到这个问题 查看的时候卡住了，怎么解决