[PCB_FORUM] Re: placement file in excel format

 
FWIW, if you just open the .txt file inside Excel it will pop a form
allowing you to set delimiters or fixed width columns.  Probably the
same form as Data>Text to columns, but you skip a step. :)
 
-- 
George Patrick
Tektronix, Inc.
Central Engineering, EDS Applications Support
P.O. Box 500, M/S 39-512
Beaverton, OR 97077-0001
* 503-627-5272 (voice)     * 503-627-5587 (fax)
<http://www.tektronix.com/> 
http://www.tektronix.com     <http://www.pcb-designer.com/>
http://www.pcb-designer.com
 
"Off-Grid and Proud of it!"

-----Original Message-----
From: icu-pcb-forum-bounce@xxxxxxxxxxxxx
[mailto:icu-pcb-forum-bounce@xxxxxxxxxxxxx] On Behalf Of Andrew Noonan
(annoonan)
Sent: Wednesday, March 21, 2007 09:50
To: icu-pcb-forum@xxxxxxxxxxxxx
Subject: [PCB_FORUM] Re: placement file in excel format


Shiva,
 
Excel is highly underrated, as it has some neat features that many
people don't use. I use Excel (and Word) regularly to manipulate text
files into manageable lists of organized data. Here's what I would do:
 
- Open the place_txt.txt file. Edit>Select All. Copy
- Open Excel and Paste into cell A1
- in Excel, Data>Text to Columns>Delimited>check on Tab and Space> and
select Finish (you could check Next, but  that only sets up formatting
for each column; the defaults are ok)
 
Excel splits the data into columns. The only issue with this is that the
'm' character (signifying whether a component is mirrored or not) messes
things up a bit. In any case it's an easy fix. Excel can sort too.
Here's more you can do to get that in order quickly. 
 
- Delete the first row of data, you don't need it. (UUNITS, etc ).
- Highlight columns B through G. 
- Click Data>Sort>Column F>Ascending. 
 
Everything above and below the 'm' can be shifted over to the right one
column to line up with the rest of the package symbols. 
 
Voila (or should I say 'walla'). 
 
When you're ready to tackle a long list of thousands of items in a text
file from doing a Show Element, let me know. MS Word has some neat
features to replace Tabs and Paragraph ends, which come in quite useful.
 
Andrew
 
 

  _____  

From: icu-pcb-forum-bounce@xxxxxxxxxxxxx
[mailto:icu-pcb-forum-bounce@xxxxxxxxxxxxx] On Behalf Of shiva shiva
Sent: Wednesday, March 21, 2007 3:04 AM
To: icu-pcb-forum@xxxxxxxxxxxxx
Subject: [PCB_FORUM] placement file in excel format


Hi all,

Is anyway to export placement file in excel format. with x and y
co-ordinates in separate columns.

Thanks
shiva.




  _____  

Here's a new way to find what you're looking for - Yahoo!
<http://us.rd.yahoo.com/mail/in/yanswers/*http://in.answers.yahoo.com/>
Answers

Other related posts: