Re: How to get a cell list of one library in skill?



Joffre,
Unless you have any special reason to have the list of cell names in the text file, It is easier to loop through all the cells in a library this way:
libName = "myLibName"

foreach(cellId ddGetObj(libName)->cells
foreach(viewId cellId->views
;Do processing here:
; cv = dbOpenCellViewByType(libName cellId->name viewId->name)
printf("Processing %s %s %s\n" libName cellId->name viewId->name)
)
)

regards,
Suresh
tech11 wrote:
Hi,

I'm one novice to skill and wanna write one code to open the cells in some library one by one, but I don't know how to get a cell list.

Firstly I get all the cell name in one file 'a1' and keep every one a line. This's my code below:

inPort=infile("a1")
when(inPort
while(gets(oneline inPort)
cvId=deOpenCellView("lib1" oneline "schematic" "" list(0:0 700:800) "r")
hiCloseWindow(cvId1)
)
)
close(inPort)

My meaning is to open the cell one by one and check the warning to find the missing masters.

But I get some output:
*WARNING* ddGetObj: cell name 'test
' is not a legal cell name.

Maybe it recognize the whole line as one item while including spaces. How should I do to check all the cells in one library as one list? either how to check if one library is clean, that is, there's no any missing cells used by the library.

Have a good day!

B.R.

Joffre


.



Relevant Pages

  • Re: Add text based on imput in another cell
    ... The problem as I saw it was, if the warning ... That means when the user leaves the cell, ... went to edit the text in C21 and restore it when they were finished. ... Private Sub Worksheet_SelectionChange ...
    (microsoft.public.excel.programming)
  • Re: Add text based on imput in another cell
    ... The problem as I saw it was, if the warning were allowed to remain during editing, there would be no practical way to protect if from being modified. ... Consider if the user accidentally deleted the closing parenthesis from the warning message... ... That means when the user leaves the cell, a new warning message would be added to the remaining text in the cell. ... To protect the warning message against this scenario, I decided to remove it when the user went to edit the text in C21 and restore it when they were finished. ...
    (microsoft.public.excel.programming)
  • Re: copying named cells into new workbook
    ... If you are using the GUI, the warning you refer to cannot be ... Sub testIt() ... > without having the origin file name pasting in as well? ... > cell named XYZfrom One.xls into Two.xls will Two.xls have a cell called ...
    (microsoft.public.excel.programming)
  • Re: Limiting Size of Text Fields
    ... I'd assume that using less would always suffice. ... And with the warning in mind while typing, ... You can warn users that the cell is limited to 50 characters, ...
    (microsoft.public.excel.misc)
  • Re: Pop-Up Message
    ... You could use an event macro with a msgbox or maybe ... > (Change the A1 to whatever cell you're working with) ... > Now on the Error Alert tab in the "Style" area choose Warning ...
    (microsoft.public.excel.worksheet.functions)