Hello Gunnar: I use that approach quite a bit; in fact, yesterday I posted the procedure that I use to populate pre-formatted spreadsheets. This particular application is for very unsophisticated users that require a one click of the mouse to do the entire thing. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Gunnar Ekblad Sent: Thursday, February 10, 2005 9:56 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: GATEWAY question Javier Instead of using Gateway to export to Excel, I now and then use ODBC from Excel to import from the database, in that case 0 comes as 0. Gunnar Ekblad Kontema IT AB H�stholmsv�gen 32 S-131 30 NACKA 070 545 50 38 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: den 11 februari 2005 03:38 To: RBG7-L Mailing List Subject: [RBG7-L] - Re: GATEWAY question Larry: CSV is what I was using before, but the XLSW (or XLS) option sounded better as you can label the worksheet tab and so on...oh well, I might have to go back to CSV... Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Lawrence Lustig Sent: Thursday, February 10, 2005 8:34 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: GATEWAY question > Some of the cell in the R:Base table have a value of 0; the export works > fine except that all the cells that have a 0 value show up in the > spreadsheet as blanks, I have used the XLS option with similar results. If I > use the Gateway Icon on the top menu and do the same thing, the values > export correctly and show up in the spreadsheet as 0 rather that blanksis > there and option that I am missing??? TIA. As a workaround, have you tried CSV? I think most installations of Excel treat CSV as a native format (that is, if you "launch" a CSV file either from R:Base or from Windows, Excel will open it). -- Larry
