Patti, The *.rgw file stores the specifications that allow you to recreate the export file. You set up your export parameters one time (for each specific export/format) using the Gateway wizard and then you store the parameters in a *.rgw file. Next time you want to export the same file you just specify the *.rgw that you created and that has you settings and the export file is generated; makes sense? Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Patti Jakusz Sent: Wednesday, March 02, 2016 3:26 PM To: [email protected] Subject: [RBASE-L] - RE: problem exporting decimals into Excel Workbook I will try this tomorrow when I'm back at work. I never heard of an .rgw file. Can it contain multiple spreadsheet pages and be opened with Excel? Patti _____
From: Javier Valencia <[email protected]> To: [email protected] Sent: Wednesday, March 2, 2016 2:57 PM Subject: [RBASE-L] - RE: problem exporting decimals into Excel Workbook Patti, Use the Gateway Wizard to generate a spreadsheet export where you can specify the columns and formatting and save the export as a *.rgw file. Next time you can just specify the file you saved with all the saved formatting. Works very well. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Patti Jakusz Sent: Wednesday, March 02, 2016 1:47 PM To: [email protected] Subject: [RBASE-L] - problem exporting decimals into Excel Workbook I sent this yesterday with my Excel attachment, but I don't think anyone ever got it. So I'll try again without the attachment. _____ From: Patti Jakusz <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, March 1, 2016 10:49 AM Subject: problem exporting decimals into Excel Workbook Hello, I have to export data into Excel Workbook format, producing multiple spreadsheet pages. My file has two columns (MomAge and BabyAge) that are numeric (5,1) values. When I open the resulting spreadsheet, I find those two columns formatted as a Number with zero decimal places and the result has been rounded. I tried exporting to a regular Excel Spreadsheet and it works fine. But that doesn't give me what I need. How can I get the decimals to show up without having the data-entry clerk go in and reformat the columns in Excel? Here is the syntax for one of the sheets: GATEWAY EXPORT xlsw HealthyStartHeadSt.xlsx + SELECT HVSiteName, MomName, MomAge, + ProgStart, ProgEnd, BabyFNM, BABYLNM, BabyDOB, DaysProg, BabyAge + from HEADSTWork order by MOMNAME whe EXIT2DAT is not null + OPTION COL_NAMES ON + |TAB_NAME Dismissed and > 2.5, < 4.0 Patti
