Re: NEC-LIST: NEC output to Excel format

Thanks all for the suggestions. Jim Lux's suggestion worked very well.
Open the Output file in Wordpad, highlight the desired data section and
"copy". Open Excel and "paste" the copied selection. Go to "DATA" and
select "Text to Columns". Select "Fixed Length" and Excel will show
proposed columns in your text data. Adjust as necessary and Finish.
It worked the first time and the data is good.
Again, Many thanks to all.
Paul Lynas

"Lux, Jim (337C)" <james.p.lux_at_jpl.nasa.gov> writes:

On 10/12/09 8:28 PM, "glynas_at_sbcglobal.net" <glynas_at_sbcglobal.net> wrote:

> Is there a straight forward way or program to extract NEC output to an
> Excel
> spreadsheet format?
> I'm using 4NEC2. This program generates the Output file in the standard
> NEC2
> text format.
> I'd like to extract sections of the output files to a spread sheet for
> later
> analysis and report generation.
>
Not automatically. There are some excel macros around that parse output of
NEC.
I've had pretty good luck with cut and paste.

Open the NEC file in notepad
Open Excel
Highlight the output from NEC that you want, Ctrl-C to copy
Ctrl-V to paste into Excel, then do "convert text to columns" using fixed
columns.

-- 
The NEC-List mailing list
NEC-List_at_robomod.net
http://www.robomod.net/mailman/listinfo/nec-list