Help: Exporting EXCEL file to .prn

[Philip]

hi
i have a matrix data with headers in Excel. The numbers in the first row
are Y labels while those in the first column are X labels. The data in
this matrix thus constitute a 3 dimensional graph or a contour plot. The
first cell in the first column (1A) is left blank.

The problem i have is that my software can read only .prn files. When i
save the excel file as prn, the columns do not align properly , some
numbers in adjacent columns are even joined. Is there any other way i
can export my data with the correct alignment?

I have a total of 186 rows and 66 columns excluding the headers/labels.

Thank you
philip

 

[Philip]

hi john:
i did "Save as" a prn by choosing the file type. The "printers" i have
are Adobe PDF and Microsoft Office Document Image Writer and the
corresponding drivers. The software that i'm reading into is a
non-commercial engineering program that can read only prn.

any ideas?
philip

 

[John McGhie [MVP - Word and Word Macintosh]]

Hi Philip:

No, no ideas at all... You're on a PC, and this is a Macintosh support
group

I was not even aware that Excel 2003 would "Save As" to a .prn. My believe
was that you MUST "Print" to produce a .prn file, since it is made by
postscrpt.drv on the Windows Box (the content of the file is normally
PostScript or RAW).

I suggest that you install an Apple LaserWriter "printer" and print to that,
nominating "Print to file" when you do so.

I suggest the LaserWriter not because I'm on a Mac (there's a PC in the
other corner...) but because the LaserWriter is the most "standard" of the
printers out there. If something can read a printer file, it can read
LaserWriter.

That will probably solve your alignment problem, since the printer driver is
where the printing subsystem gets all its dimensions from.

The Microsoft Office Document Image Writer, by the way, I think produces a
Group IV TIFF file (a Fax...)

Cheers

hi john:
i did "Save as" a prn by choosing the file type. The "printers" i have
are Adobe PDF and Microsoft Office Document Image Writer and the
corresponding drivers. The software that i'm reading into is a
non-commercial engineering program that can read only prn.

any ideas?
philip

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

 

[CyberTaz]

G'Day John -

Just in case there is any question in your mind:


On 9/11/06 8:09 AM, in article C12B8F37.4B62B%[email protected], "John McGhie

I was not even aware that Excel 2003 would "Save As" to a .prn.

It *won't* - there is no such file type available in the Save As list of
file types. In order to create a .prn in 2003 you do the same as always...
File>Print - Check the Print to File checkbox.

Regards |:>)
Bob Jones
[MVP] Office:Mac