Caching a half-million rows into a .xls?

[(PeteCresswell)]

Just had a brief walk through of a monster .xls (about 50 megs) that caches
about 500,000 lines of data and does various presentations of it.

I couldn't find any way to actually see said data - but I'm taking somebody's
word that it's there.

Anybody have any idea how that might have been done?

 

[Peo Sjoblom]

It might be the beta of next excel version (Office 2007 for now but might be
2008 before it arrives)
it has 1 million rows and about 16000 columns. Otherwise they need to
portion out the data over multiple sheets

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Puppet_Sock]

Just had a brief walk through of a monster .xls (about 50 megs) that caches
about 500,000 lines of data and does various presentations of it.

I couldn't find any way to actually see said data - but I'm taking somebody's
word that it's there.

Anybody have any idea how that might have been done?

Well, I can guess ways that it *might* be done, but that really does
not give you any information about how it is done. For example:
It might open a new workbook, copy some chunk into a sheet
of that book, save that book, and close it. Getting stuff back
is just the reverse. The other workbooks might even be
pre-existing with base data or helper VBA code in them,
maybe graphs etc. pre-created.

But that is certainly not the only way.
Socks

 

[(PeteCresswell)]

Per Puppet_Sock:

is just the reverse. The other workbooks might even be
pre-existing with base data or helper VBA code in them,
maybe graphs etc. pre-created.

But that is certainly not the only way.
Socks

I was thinking more in terms of some kind of object that I'd never heard of...