Karen, It may not be a great deal of trial and error, it may just be a little trial and error. It depends on your R:BASE formatting and fonts, and how easily that converts into Excel sheets and cells. Try printing your report to XLS with a few option variations, and see how close you are to start with.
Bill On Tue, Mar 9, 2010 at 11:06 AM, <[email protected]> wrote: > Thanks Bill. I'll keep that in my notes. I know it will be a great dial > of trial > and error, but to save the operator from doing 100 individual Excel > cleanups, > I'm sure they'll say it will be worth it! > > So you're saying that although it might take a while, I should be able to > get > a report with headers, break headers and totals, to be able to come into > an Excel spreadsheet without losing formatting or data? > > 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* > * > > > >
