 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Borders/grids in EXL 2K | Login/Join |
| Gold member |
The following piece of code generates the output with no borders/grids. How do we get the borders/grids in EXL2K format? TABLE FILE CAR SUM RETAIL_COST DEALER_COST SALES BY COUNTRY NOPRINT BY CAR ON COUNTRY SUBTOTAL AS '*TOTAL' ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT EXL2K ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, PAGESIZE='Legal', LEFTMARGIN=0.097222, RIGHTMARGIN=0.000000, TOPMARGIN=0.000000, BOTTOMMARGIN=0.000000, SQUEEZE=OFF, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=ON, $ ENDSTYLE ENDThis message has been edited. Last edited by: Kerry, | ||
|
| Guru |
Unless someone knows something I don't, you can use BORDER attributes in a StyleSheet in an HTML, PDF, or PS reports only. Grids can be used in HTML only. If someone knows of a work around, I'd been interested too. Glenda Glenda In FOCUS Since 1990 Production 8.2 Windows | |||
|
| Member |
Thanks a lot for your help. Now I am able to do it | |||
|
| Expert |
Hi Code Digger, Styles do not translate to Excel, you will need to employ templates. Hope this helps.  Cheers, Kerry Kerry Zhan Focal Point Moderator Information Builders, Inc. | |||
|
| Platinum Member |
kerry , i was wondering whether we can use macros to generate Gridlines and every time the report is opened in EXL2K format ..macros run automatically and the gridlines are displayed... Is it possible??even i am facing the same problem of Grid lines?? Please Advice WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | |||
|
| Expert |
Arvind, Yes you can but, as Kerry mentions, you would have to use Excel Templates so that you can program in your Miscrosoft VBA code into the .mht file used for the template. T
| |||||||||
|
| Virtuoso |
There have been at least three threads within the last week regarding this EXACT same question and probably that many as well regarding use of Excel templates. This information is also documented in the user manuals. PLEASE people - do a cursory search of information that is already available before posting new questions. I understand that not everyone is aware that this is available (though it's not too hard to find), but you only have to use the forum a few times before the topics of using "Find" and searching documentation are brought up. Maybe the forum moderator should create a ! document with some of these common helps and courtesies for using the forum. Or have them sent to new users as they sign up to use the forum. This isn't an attack on CodeDigger, but it occurs frequently and something of this nature may address the issue. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Expert |
Darin, Reign it in mate. Arvind was asking a question of Kerry's post above. You have to read the context and flow of the posts to realise that his question is/was fairly valid. Rule: Get a good understanding of the flow before placing foot into mouth 
| |||||||||
|
| Master |
I think Darin's got a point that having a FAQ section might be a good idea. (My favourite candidate is functions in DM not preserving alpha type - this has cropped up loads - remember wasting 1/2 day on it myself back in 1988! ). Kerry Would it be possible to have a FAQ section which I think would have to be under the control of the moderator, but uses the input of posters? John IMHO so far the list reads 1. Excel templates for styling spreadsheets. 2. Using functions with Alpha Arguments in DM. Any more suggestions? Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Expert |
Hi John and all, A FAQ section sounds interesting. Let me bring this suggestion in and see what/how/where we can start from. Keep the suggestions/comments coming please.  Cheers, Kerry Kerry Zhan Focal Point Moderator Information Builders, Inc. | |||
|
| Virtuoso |
I've never seen the HTMLFORMTYPE setting before. Learned something new. Anyway, this is interesting since we've been telling everyone that borders could not be carried into Excel. In fact, they aren't but you've found a way around it by specifying HTML format which then opens as a spreadsheet. I had to add a -MRNOEDIT to the beginning of the -HTMLFORM line to get it to work properly in MRE. I wouldn't be TOO surprised if there are still some things that don't translate but this is the quick answer to the "borders and grids in excel" question. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Platinum Member |
hey thanks for the MRNOEDIT tip..but still the report is not exported to Excel format.. and whenever i copy and paste it in another Excel2000 file,,the grid lines are not visible in the print preview ...i guess the only way is to create Excel templates ..any suggestions???This message has been edited. Last edited by: arvind, WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | |||
|
| Expert |
Arvind, This is, as has been mentioned before, an Excel / MS Clipboard problem in as much as you will have to set Excel to print grid lines. T
| |||||||||
|
| Platinum Member |
thank you sir WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | |||
|
| Virtuoso |
Forgot about the grid lines part. I do get borders with the technique, but still no grid lines. Back to the templates solution... Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Virtuoso |
Second thought, you might try adding TYPE=REPORT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT,$ to the stylesheet. This adds borders around the fields and sort groups. It may get you closer to what you're looking for. This LOOKS like grids are on, but is really just adding borders around EVERYTHING. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Expert |
Darin, The important piece about Arvind's problem is that he is cutting and pasting content from the output into an MS Excel worksheet (why? I wouldn't want to guess  ) and then using print preview.T
| |||||||||
|
| Gold member |
Based on this method to get borders on Excel, is it possible to use for Set Compound reports?? SET COMPOUND='OPEN NOBREAK' Report 1: Report 2: SET COMPOUND=CLOSE WF 8105M - Portal, Dashboard - Rcaster, Data Migrator - Windows 2012 Client Server - Dev/App Studio 8105 - Data: SQL, Oracle, Neteeza,MVS | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |