John I do hate excel and all my users love Excel. So getting information from R:BASE to excel I use 3 diffrent methods: BROWSE and export to XLS Gateway to export Query from excel through ODBC Printing a report I always found to cumbersome to understand how the report will look columnwise in excel. Of cource this might be due to my lack of understanding but still I keep to the 3 methods above
Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För John Engwer Skickat: den 7 mars 2009 15:51 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Print to XLS I am trying to use the print command to create an XLS file with customer names. As the file is being created, I get an error as follows: File Error: Data may have been lost. When I inspect the XLS file some of the data is misaligned (1st name does not match the last name). And some of the data is missing. In my test table there are 250 rows and the XLS file only contains 245 rows. I even stripped the table down to one column (FirstName) and I still get the error and the corrupted data. Here is the last print command that I tried. I experimented with dozens of other print options and they all produce the error. I suspect the resolution may be in the option settings. PRINT xls_out + OPTION XLS + |FILENAME MAILER.XLS + |SHOW_CANCEL_DIALOG Off + |CELL_ATTR ON + |LINE_SPACE actual + |OPEN ON return Does anyone have a suggestion. John Engwer Engwer & Associates 2449 Scenic Ridge Drive North Huntingdon, PA 15642-2120 Phone: 412 751-2433 Email: <mailto:[email protected]> [email protected] <http://www.ENGWER.US> WWW.ENGWER.US
