I'm trying to make an XLS that is updated by many people who don't know/care how databasing works available as a pagable DataGrid. The problem of the moment is that some of the columns in the XLS tables are full of hyperlinks. When I extract the data (as explained here) all I get is the text. I lose the URL. I know how to build a DataGrid HyperLinkColumn out of two different columns in the dataset, but is it possible to pull the full hyperlink information out of only one column? Also, what if only some of the cells in a given column are hyperlinks? I don't want the non-links to be dead links, I want them to be plain text. Thanks -- -r Post Edited (Randy C. Will) : 7/19/2005 4:39:58 PM GMT
