| accomdating more than 70,000 rows in an excel [message #410656] |
Mon, 29 June 2009 09:51  |
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
|
Senior Member |
|
|
We are creating an excel using OLE2. One excel can accomdate round about 60,000 rows. Now if the rows exceed the limit then we need to create multiple files.
I want to ask that is there any particular way to solve this problem or do we need to develop some home made logic?
|
|
|
|
|
|
|
|
|
|
|
|
| Re: accomdating more than 70,000 rows in an excel [message #410669 is a reply to message #410656] |
Mon, 29 June 2009 10:39  |
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
|
Senior Member |
|
|
Can we do that?
You mean we can do it as
CURSOR Cu
SELECT ROWNUM
FROM TABLE;
workbooks := OLE2.GET_OBJ_PROPERTY(application, 'Workbooks');
workbook := OLE2.GET_OBJ_PROPERTY(workbooks , 'Add');
worksheets := OLE2.GET_OBJ_PROPERTY(workbook , 'Worksheets');
worksheet := OLE2.GET_OBJ_PROPERTY(worksheets , 'Add');
FOR C1 IN Cu LOOP
.....
.....
IF ROWNUM = 60000 THEN
workbooks := OLE2.GET_OBJ_PROPERTY(application, 'Workbooks');
workbook := OLE2.GET_OBJ_PROPERTY(workbooks , 'Add');
worksheets := OLE2.GET_OBJ_PROPERTY(workbook , 'Worksheets');
worksheet := OLE2.GET_OBJ_PROPERTY(worksheets , 'Add');
END IF;
END LOOP;
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
