Home » Developer & Programmer » Forms » export huge data to spreadsheet (Oracle 10g forms, Unix.)
export huge data to spreadsheet [message #305438] Mon, 10 March 2008 15:05 Go to next message
a4abid
Messages: 1
Registered: March 2008
Location: India
Junior Member

Hi,

I am using Text_IO builtin to export data from form to excel file.My output file is not able to handle the huge data i.e more than 65k lines.Please suggest a solution to automatically continue the printing of records on next tab page(Spreadsheet of the same excel file).

Thanks in advance..
Abid
Re: export huge data to spreadsheet [message #307152 is a reply to message #305438] Tue, 18 March 2008 00:48 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

These are the main Excel links:
Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/67467/
http://www.orafaq.com/forum/m/84230/67467/
Merge two cells in Excel using ole2
http://www.orafaq.com/forum/t/77825/67467/
Error closing Excel file generated using OLE2
http://www.orafaq.com/forum/t/77351/67467/
How to wrap text in excel cell using ole2
http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200830d62336f40f5aad44efb36ee981f4e6c19e.e34QbhuKaxmMai0MaNeMb3eKb390?mess ageID=1242535&#1242535
Excel via DDE
http://www.orafaq.com/forum/m/260061/67467/#msg_260061
Import from Excel
http://www.orafaq.com/forum/mv/msg/32353/86299/67467/#msg_86299
Forms to Excel example with webutil
http://forums.oracle.com/forums/thread.jspa?messageID=1430799
Another Forms to Excel example
http://www.orafaq.com/forum/t/81537/67467/
How to kill EXCEL.exe from Task Manager from Oracle Forms
http://www.orafaq.com/forum/t/88643/67467/
how do i display all excel worksheets name in form
http://www.orafaq.com/forum/t/89775/67467/
More Excel stuff
http://www.orafaq.com/forum/t/90502/67467/
To run an excel macro
http://www.orafaq.com/forum/t/47685/67467/
Worked example for using Excel through ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358

David
Previous Topic: popup menu comes when we press left-mouse button?
Next Topic: How I can run oracle form in behind (not on screen) or Not giving the option of close....
Goto Forum:
  


Current Time: Sat Dec 10 18:14:30 CST 2016

Total time taken to generate the page: 0.11299 seconds