Formatting reports for Excel

[Taber, Phil]

	Insert the following lines before your report statement in quiz:
	define Asc_009 int*3  = 009 
	define T       char*1 = character(Asc_009)
     
	then within the report statement, do NOT use any TAB statements,
rather just insert the variable T between each item you want to form a
column on your spreadsheet.  You need to also do this on the page header
between column headings (do not use KEEP COLUMN HEADINGS, rather hard code
them with the T between each header).
	Also insert a 
	set page width 250 length 0 
	command to keep from getting multiple page headings within the
document.  
	Set output to a disk file (set report device disc name fred)
	You then can import the fred.txt file into excel as a tab delimitted
file and it will load properly.


	-----Original Message-----
	From:	Chris Sharman
[SMTP:Chris.Sharman%ccagroup.co.uk@interlockp.lubrizol.com]
	Sent:	Thursday, January 28, 1999 9:42 AM
	To:	powerh-l%lists.swau.edu@interlockp.lubrizol.com
	Cc:	Chris.Sharman%ccagroup.co.uk@interlockp.lubrizol.com
	Subject:	Formatting reports for Excel

	Does anyone have any useful tips or tools for re-formatting text for
Excel ?
	The reports (done in Powerhouse Quiz) look fine on a VT or to print,
but
	oh-so-clever Excel has its own ideas about how to lay it out.

	'Sparse' reports with many cells left blank seem to be a particular
problem,
	in that blanks seem to get removed.

	Someone mentioned rich text: would it help ? Is there an encoder for
VMS ?
	Or is there a way to provide hints to Excel along with the reports,
so that
	it goes straight into Excel all pretty, rather than needing lots of
manual
	adjustment.

	I could turn it all into comma separated quoted text, but that's
fairly
	tedious, and makes the report pretty unreadable except via a
spreadsheet.
	I'd really like a report readable to both humans & Excel.

	Excel is the customer's choice, not mine, so I can't use a
Powerhouse PC
	product instead: the reports are done overnight & emailed to the
customer
	who wants to look at them with Excel first thing Monday morning.

	Thanks
	
______________________________________________________________________
	Chris Sharman			Chris.Sharman@CCAgroup.co.uk
	CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
	= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
= = = =
	Subscribe: "subscribe powerh-l" in message body to
majordomo@lists.swau.edu
	Unsubscribe: "unsubscribe powerh-l" in message to
majordomo@lists.swau.edu
	powerh-l@lists.swau.edu is gatewayed one-way to
bit.listserv.powerh-l
	This list is closed, thus to post to the list, you must be a
subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.