Migrating 6i to 11g:
I've been trying to find a way to write a collection directly to excel the same way I did back in 6i, but client_ole has more limits.
The reason is that going cell by cell, with all that roundtrips, the excel file generation takes a lot of time and users coming from 6i will not accept it.
So I'd like to try another approach, to compare performance:
Generate a plain xml file,
write it with webutil in a local temporal folder
Open it with excel (or in the browser?)
Could anyone point me to a site where is explained the xml structure for a quite simple excel file generation in plain xml?
(if I save a file as xml, there seems to be more tags that I would need for a basic excel file)