nameld001 发表于 2006-9-20 10:29:00

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

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

liu_kunlun 发表于 2006-9-20 12:14:00

<P>参考帮助的例子:</P>
<P>(vlax-get-property acadObject 'ActiveDocument)</P>
<P>是不是应该写成</P>
<P>(vlax-get-property f 'cells)?</P>

nameld001 发表于 2006-9-20 15:57:00

谢谢，好像都一样的吧

mmmmmm 发表于 2006-9-21 17:09:00

<P>去<A href="http://www.atablex.com/" target="_blank" >http://www.atablex.com</A>参考VLXLS Project的源代码。</P>

xtjd 发表于 2006-9-25 07:43:00

<P>(vlax-dump-object&nbsp;f t)<BR>; _Worksheet: nil<BR>;性质值:<BR>;&nbsp;&nbsp; Application (RO) = #&lt;VLA-OBJECT _Application 05f7173c&gt;<BR>;&nbsp;&nbsp; AutoFilter (RO) = nil<BR>;&nbsp;&nbsp; AutoFilterMode = 0<BR>;&nbsp;&nbsp; Cells (RO) = #&lt;VLA-OBJECT Range 0017e85c&gt;<BR>;&nbsp;&nbsp; CircularReference (RO) = nil<BR>;&nbsp;&nbsp; CodeName (RO) = ""<BR>;&nbsp;&nbsp; Columns (RO) = #&lt;VLA-OBJECT Range 0017e7cc&gt;<BR>;&nbsp;&nbsp; Comments (RO) = #&lt;VLA-OBJECT Comments 0017e714&gt;<BR>;&nbsp;&nbsp; ConsolidationFunction (RO) = -4157<BR>;&nbsp;&nbsp; ConsolidationOptions (RO) = 在 \develop\global\src\coreapps\lpp\LPPCOM\SRC\IDISP.CPP 档案，138 行中的要求失败:<BR>lBound == 0</P>
<P>;&nbsp;&nbsp; ConsolidationSources (RO) = nil<BR>;&nbsp;&nbsp; Creator (RO) = 1480803660<BR>;&nbsp;&nbsp; CustomProperties (RO) = #&lt;VLA-OBJECT CustomProperties 0017e684&gt;<BR>;&nbsp;&nbsp; DisplayPageBreaks = 0<BR>;&nbsp;&nbsp; DisplayRightToLeft = 0<BR>;&nbsp;&nbsp; EnableAutoFilter = 0<BR>;&nbsp;&nbsp; EnableCalculation = -1<BR>;&nbsp;&nbsp; EnableOutlining = 0<BR>;&nbsp;&nbsp; EnablePivotTable = 0<BR>;&nbsp;&nbsp; EnableSelection = 0<BR>;&nbsp;&nbsp; FilterMode (RO) = 0<BR>;&nbsp;&nbsp; HPageBreaks (RO) = #&lt;VLA-OBJECT HPageBreaks 05753d6c&gt;<BR>;&nbsp;&nbsp; Hyperlinks (RO) = #&lt;VLA-OBJECT Hyperlinks 05e3242c&gt;<BR>;&nbsp;&nbsp; Index (RO) = 1<BR>;&nbsp;&nbsp; ListObjects (RO) = #&lt;VLA-OBJECT ListObjects 05e18864&gt;<BR>;&nbsp;&nbsp; MailEnvelope (RO) = #&lt;VLA-OBJECT IMsoEnvelopeVB 05e186fc&gt;<BR>;&nbsp;&nbsp; Name = "Sheet1"<BR>;&nbsp;&nbsp; Names (RO) = #&lt;VLA-OBJECT Names 05e32504&gt;<BR>;&nbsp;&nbsp; Next (RO) = #&lt;VLA-OBJECT _Worksheet 05efd64c&gt;<BR>;&nbsp;&nbsp; Outline (RO) = #&lt;VLA-OBJECT Outline 05e326ac&gt;<BR>;&nbsp;&nbsp; PageSetup (RO) = #&lt;VLA-OBJECT PageSetup 0017f214&gt;<BR>;&nbsp;&nbsp; Parent (RO) = #&lt;VLA-OBJECT _Workbook 05ef74d4&gt;<BR>;&nbsp;&nbsp; Previous (RO) = nil<BR>;&nbsp;&nbsp; ProtectContents (RO) = 0<BR>;&nbsp;&nbsp; ProtectDrawingObjects (RO) = 0<BR>;&nbsp;&nbsp; Protection (RO) = #&lt;VLA-OBJECT Protection 0017edb4&gt;<BR>;&nbsp;&nbsp; ProtectionMode (RO) = 0<BR>;&nbsp;&nbsp; ProtectScenarios (RO) = 0<BR>;&nbsp;&nbsp; QueryTables (RO) = #&lt;VLA-OBJECT QueryTables 05dd1bc4&gt;<BR>;&nbsp;&nbsp; Range (RO) = ...未展示索引内容...<BR>;&nbsp;&nbsp; Rows (RO) = #&lt;VLA-OBJECT Range 0572c674&gt;<BR>;&nbsp;&nbsp; Scripts (RO) = #&lt;VLA-OBJECT Scripts 056a6c24&gt;<BR>;&nbsp;&nbsp; ScrollArea = ""<BR>;&nbsp;&nbsp; Shapes (RO) = #&lt;VLA-OBJECT Shapes 05f34eb4&gt;<BR>;&nbsp;&nbsp; SmartTags (RO) = #&lt;VLA-OBJECT SmartTags 056a63ec&gt;<BR>;&nbsp;&nbsp; StandardHeight (RO) = 16.5<BR>;&nbsp;&nbsp; StandardWidth = 8.38<BR>;&nbsp;&nbsp; Tab (RO) = #&lt;VLA-OBJECT Tab 0017ed6c&gt;<BR>;&nbsp;&nbsp; TransitionExpEval = 0<BR>;&nbsp;&nbsp; TransitionFormEntry = 0<BR>;&nbsp;&nbsp; Type (RO) = -4167<BR>;&nbsp;&nbsp; UsedRange (RO) = #&lt;VLA-OBJECT Range 0572c7bc&gt;<BR>;&nbsp;&nbsp; Visible = -1<BR>;&nbsp;&nbsp; VPageBreaks (RO) = #&lt;VLA-OBJECT VPageBreaks 05f88114&gt;<BR>;&nbsp;&nbsp; _CodeName = ""<BR>;支援的方法:<BR>;&nbsp;&nbsp; Activate ()<BR>;&nbsp;&nbsp; Calculate ()<BR>;&nbsp;&nbsp; ChartObjects (1)<BR>;&nbsp;&nbsp; CheckSpelling (4)<BR>;&nbsp;&nbsp; CircleInvalid ()<BR>;&nbsp;&nbsp; ClearArrows ()<BR>;&nbsp;&nbsp; ClearCircles ()<BR>;&nbsp;&nbsp; Copy (2)<BR>;&nbsp;&nbsp; Delete ()<BR>;&nbsp;&nbsp; Evaluate (1)<BR>;&nbsp;&nbsp; Move (2)<BR>;&nbsp;&nbsp; OLEObjects (1)<BR>;&nbsp;&nbsp; Paste (2)<BR>;&nbsp;&nbsp; PasteSpecial (7)<BR>;&nbsp;&nbsp; PivotTables (1)<BR>;&nbsp;&nbsp; PivotTableWizard (16)<BR>;&nbsp;&nbsp; PrintOut (8)<BR>;&nbsp;&nbsp; PrintPreview (1)<BR>;&nbsp;&nbsp; Protect (16)<BR>;&nbsp;&nbsp; ResetAllPageBreaks ()<BR>;&nbsp;&nbsp; SaveAs (10)<BR>;&nbsp;&nbsp; Scenarios (1)<BR>;&nbsp;&nbsp; Select (1)<BR>;&nbsp;&nbsp; SetBackgroundPicture (1)<BR>;&nbsp;&nbsp; ShowAllData ()<BR>;&nbsp;&nbsp; ShowDataForm ()<BR>;&nbsp;&nbsp; Unprotect (1)<BR>;&nbsp;&nbsp; XmlDataQuery (3)<BR>;&nbsp;&nbsp; XmlMapQuery (3)<BR>;&nbsp;&nbsp; _Evaluate (1)<BR>T</P>

明27662 发表于 2021-3-29 21:54:04

我也碰到这个问题 查看的时候卡住了，怎么解决
页: [1]
查看完整版本: 如何查看excel,cells属性，请位大侠！