Karen, It will take a little trial and error to get everything to line up and format correctly, but there's always (from the Help screen, highlights of important options mine):
*PRINT *Invoice* WHERE *CustID *= *127* + OPTION *XLS* + **|**FILENAME *Invoice.XLS* + **|**SHOW_CANCEL_DIALOG *OFF* + **|**ALL_TEXT_IN_GENERAL_FORMAT *OFF* + **|**CELL_ATTR *ON* + **|**INCLUDE_IMAGES *OFF* + **|**INCLUDE_LINES *OFF* + **|**INCLUDE_RICH_TEXT *ON* + **|**RICHTEXT_ENCODING_TYPE *IMAGE* + **|**INCLUDE_SHAPES *OFF* + **|**LINE_SPACE *ACTUAL* + **|**ONE_SHEET_PER_PAGE *ON* + **|**OPEN *ON* * On Tue, Mar 9, 2010 at 10:20 AM, <[email protected]> wrote: > I don't have any 7.6 reports in production that print to an Excel > file because "in the beginning" it was difficult to design a report > that looked good to the screen but also could be outputted to > an Excel file. And an Excel-only report had to have fixed fonts > and plenty of white space. > > So now I have a client asking, and we would be able to design an > Excel-only report. We are now creating a .csv file, writing column > headers to it and unloading data as ascii. However, the user has > to bring up the .csv file, change fonts, apply font attributes, resave > as Excel. > > So since I haven't visited this topic in a while, could I design a report > that would always be outputted to an Excel file, have headers in a > different font, bolded, larger size, white space between headers and > data, data wouldn't be dropped and could be in a proportional font, etc. > I'm trying to output to an Excel file that would look good and have the > users not do anything to pretty it up. They run this routine once a > month on 100 different factory listings! Cannot use a PDF file > because the factories add columns of data to the spreadsheets and > return back to the company. > > Thanks! > > Karen > > >
