 |
|||||
|
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. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Exporting 1.2 million records to excel
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Exporting 1.2 million records to excel Read-Only TopicGo | Search | Notify | Tools |
| Exporting 1.2 million records to excel | Login/Join |
| Gold member |
Hi, We know excel has a limitation on number of rows it can take ( it is around 65K). but is there any way to split the records and put it in different excel sheet on the click of export button. Regards, Navaneeth | ||
|
| Expert |
Navaneeth, This question has been answered multiple times on this Forum. Do a search and look for excel, limits, BYTOC, etc. and I'm sure you will find an answer that you can use. But essentially, the answer is to count the rows and split them into multiple worksheets or divide into multiple worksheets by high-level sort field. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Expert |
Navaneenth, Take the time to read the sticky topics at the top of this Forum. Particularly the ones about updating your signature and also performing a search first. You could have saved yourself a lot of time! TThis message has been edited. Last edited by: Tony A,
| |||||||||
|
| Master |
Using BYTOC will break on your first sort field, if you want a different grouping you will need to create it, but it will make more sense if you break your report by something meaningful rather than by a count. Also keep in mind that BYTOC only works with EXL2K (and higher) it will not work with EXL97 or EXCEL. Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes | |||
|
| Platinum Member |
Hi Navaneeth Try this code to break the multiple worksheet TABLE FILE HOLD * COMPUTE COUNTER/I7=COUNTER + 1; NOPRINT COMPUTE WORKSHEET/I3=COUNTER/65000; NOPRINT BY TOTAL WORKSHEET NOPRINT ON TABLE PCHOLD FORMAT EXL2K BYTOC END Thanks Gobinath Velusamy WebFOCUS 7610 Windows | |||
|
| Platinum Member |
Navaneeth, you ask a good question, but there's a tab above called: "Search". Were you able to find the topic you were asking about by clicking on it as suggested by Tony? Were you able to find it once directed there by Ginny and PBrightwell? There is also a rate it below the 'go/new' tabs. Feel free to rate the search once you have looked up the bytoc option. Moderator - just a suggestion - maybe a bright color background behind the 'search' tab to help those that just don't "no"tice it. Ira AIX 533 WF 533(P)This message has been edited. Last edited by: ira, aix-533,websphere 5.1.1,apache-2.0, wf 538(d), 537 (p), ============== 7.6.11 (t) aix 5312 websphere 6.1.19 apache 2.0 | |||
|
| Virtuoso |
Maybe we should have it Blink...in Pink. 
| |||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Exporting 1.2 million records to excel
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Exporting 1.2 million records to excelCopyright © 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 |