layouts

I have look at this forum, found some simular answer but not exacly like my question.

I have 21x dwg's files and each it got layouts.

Now i want extract layout name to xls, and rename all the dwg's with layouts.

a lsp for me that could work like this:

1. open a empty acad file.

2. with command: extractto (Load the lsp)

3. lsp ask where to extract give a location (..xls)

excel

In column A1 the filename(dwg), in B1 layout name??, C2 layout name?? etc.

In column A1 the filename(dwg), in B1 layout name??, C2 layout name?? etc.

In column A1 the filename(dwg), in B1 layout name??, C2 layout name?? etc.

when extract finish then i rename the excel layouts.

4. with command: importto (load the lsp)

5. lsp ask 1.select xls 2.select the dwg/ dwg's files

Why not just use Sheet Set Manager to Rename/Renumber your Layouts instead?

If i rename layouts, i still have to click the button rename, that is a whole of click when iam finish.

I think it could manage the drawings well but not handy modified layouts.

If i rename layouts, i still have to click the button rename, that is a whole of click when iam finish.

I'm not sure that you understand the vast difference between what you are attempting in the OP, and how simple SSM makes this task to perform.

Sheet manager isn't realy handy to modified layout, i still have to hit the rename many times. i think it could manage drawings well.

I respectfully disagree, and 'the number of times' is entirely dependent on how many Sub-Sets you break your project out into... As an example if on were to import all Layouts, and they reside within the same Sub-Set, only one selection of Rename & Renumber is needed to iterate _all_ Layouts, in _all_ Drawings (hence the suggestion in the first place).

Good luck with your original endeavor, should you wish to continue pursuing that instead.

Hey blackbox,

Good u respons so quickly .

See attachment i put 2 example in it.

Example i want find and replace pr1414 to pr1510 , and pr1415 to pr2016. With

SSM i dont think i could do that. In excel i could do it fast because it have many option for me like find/replace. In the other 21x dwg. I would do the same like

pr1010-00-20 to pr6001-00-31.

is it possible with SSM?

Drawing1.dwg

drawing2.dwg

Hello Dear,

here i need the help from you for the new lisp.
The AIM is to export the layout name to excel from single/multiple drawings.

Consider the below requirement for the program.

1. Implement the command name, since i can use when it required by loading the lisp in startup suite
2. By executing the command, the excel need to create & save in same directory by automatically
3. Excel data arrangement need to be in such format. i.e, in a row, 1st drawing name (A1), then layout name (B1), then paper size (C1) etc.

Thanks in advance

Getting the layout names is easy this is an example it is much simpler to write a csv file to that location than to make an excel. C1 paper size how to get that,  is there a title block etc?

need a dwg

(vlax-for lay (vla-get-Layouts (vla-get-activedocument (vlax-get-acad-object)))
(princ "\n")
(princ (vla-get-name lay)) ; write csv here 
)

Hi,

The program works fine. thank you
few thing if possible will you implement here

1. Introducing the command name to execute.

2. will it possible to write the csv file to same directory, if considering for multiple drawing i can save where i needed

3. yes there is a title block for getting the paper size

here i have attached the file "test & test2" files  and also attached the sample requirement in csv file

you can consider the program for multiple drawings by selecting the folder, and it should consider all the sub-folders too.

Test2.dwg Test.dwg