One thing we do is write @@resultset to a file, leaving it formatted as an HTML table; but name it with a .XLS extension. Excel is pretty good at loading an HTML table of data and keeping all the data in the right cells. Or is that what you're already doing?
----- Original Message ----- From: "Tom Ferguson" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, January 17, 2006 2:13 PM Subject: RE: Witango-Talk: Need some ideas > BTW, I can do this to a web page, no problem. My problem is getting it into > an array so I can write it to a spreadsheet. Guess I don't do array process > enough. > > > -----Original Message----- > > From: Tom Ferguson [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, January 17, 2006 04:57 > > To: [email protected] > > Subject: Witango-Talk: Need some ideas > > > > I have a SQL table similar to this: > > > > Field1 | Field2 | Field3 | Field4 | Field5 > > > > I currently let Witango read the table into ResultSet, add > > some column headers with <@AddRows>, then write the ResultSet > > to an Excel file that the client can download as a spreadsheet. > > > > In this particular instance, however, Field 4 is very long, > > 8000 characters max and most get used. > > > > What the client would like to see is this: > > > > | Field1 | Field2 | Field3 | Field5 | > > | Field4 | > > | (empty row) | > > | Field1 | Field2 | Field3 | Field5 | > > | Field4 | > > | | > > | Field1 | Field2 | Field3 | Field5 | > > | Field4 | > > | | > > > > Any suggestions? > > > > TIA > > > > Tom Ferguson > > > > > > > > Thomas Ferguson > > Vice President > > Enroll DR, LLC > > 710 94th Ave. N. #304 > > St. Petersburg, Florida 33701 > > > > www.enrolldr.com > > > > ______________________________________________________________ > > __________ > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
