On Mon, 17 Jul 2006 16:21:41 -0400 Bill <[EMAIL PROTECTED]> spake: > > Hello, > > I have had the misfortune of being given a large amount of data in an > XLS file. My goal, in the end is to get this all out to CSV files for > processing and inclusion into a database. > > The problem is that part of the information is contained in hyperlinks > in the spreadsheet. So I have a field like: > > "Website" > > and it points at: > > "www.websitename.com" > > I need to have the latter in my output when I export, yet cannot find a > way to do it. > > The closest I have come so far is exporting it as xhtml, and then I > would need to run something on it to parse the html. Yeech > > Hopefully there is a cleaner way, > > Thanks much for any help >
Ironically, I was able to get it through macro's on Excel. For fun I imported it into OpenOffice and it basically forced me to kill openoffice to get it to stop. Basically everyline that called the function generated a popup that it would not work. Ah well, if anyone has any other ideas for this, that would be great. Thanks anyway --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
