[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! Answers
<http://us.rd.yahoo.com/mail/in/yanswers/*http://in.answers.yahoo.com/>

Other related posts: