I've got an Excel table which is edited by a lot of people who don't care about databases and want to stick with Excel. It's about 60 columns wide and more than 100 rows long. This table needs to be displayed on our website.

I've already got the databind and extremely basic presentation down via:
http://support.microsoft.com/kb/306572/EN-US/

I'm now faced with two problems:

First: Is there any way to page across columns the same way you can page through rows? As of now, I'm working on my own control using logic along the lines of:

if( (colNum > (pageWidth * (pageNum - 1)) && (colNum <= (pageWidth * pageNum) ) { display(colNum) }

To get this idea working, I need to figure out custom postbacks, but that's academic...


Second: Some of the entries in the table are hyperlinks. I know DataGrid supports HyperLinkColumn's, but everything I can find wants to build them out of two separate columns in the dataset. If I just read the column directly into a HyperLinkColumn, all I get is the text, not the URL. Any ideas?

Thanks in advance.

   -r