Declan try it with another query and see if you get the same result. Also can you look at the source of the html generated and see if its formatted correctly (i.e. no missing tr tags etc.) . Finally is there any styling applied to the table?
Kola >> -----Original Message----- >> From: Declan Maher [mailto:[EMAIL PROTECTED] >> Sent: 31 July 2003 15:10 >> To: CF-Talk >> Subject: RE: Export to Excel - only alternate rows exported WHy?... >> >> Can view the output before passing it to the custom tag. The query which >> generates the data is an include file as below.When I view the include >> file the data is all correct. But when I view the output using the tag >> it only returns every second row. >> >> >> <cf_html2Excel sheetname="report" >> Directory="#thedirectory#\exceltemp\"> >> <CFSET EXCEL=1> >> >> ------> <cfinclude template="high_grade_excel.cfm"> <-------- >> >> >> </CF_HTML2Excel> >> <CFHEADER NAME="Content-Disposition" >> VALUE="inline;filename=customsearch.xls"> >> <CFCONTENT TYPE="application/unknown" FILE="#ExcelFile#" >> DELETEFILE="Yes"> >> >> >> >> >> -----Original Message----- >> From: Kola Oyedeji [mailto:[EMAIL PROTECTED] >> Sent: 31 July 2003 01:12 PM >> To: CF-Talk >> Subject: RE: Export to Excel - only alternate rows exported WHy?... >> >> >> Can you view the output before passing it to the custom tag? >> >> If not can you replicate the code in the custom tag which creates the >> table and view the html generated? >> >> Kola >> >> >> -----Original Message----- >> >> From: Declan Maher [mailto:[EMAIL PROTECTED] >> >> Sent: 31 July 2003 11:39 >> >> To: CF-Talk >> >> Subject: RE: Export to Excel - only alternate rows exported WHy?... >> >> >> >> Kola, >> >> >> >> Here's how it does it. >> >> >> >> This custom tag creates a dynamic Excel file from the generated >> content >> >> of a block of ColdFusion code. >> >> The generated content is first saved as an HTML file. >> >> Then it is opened in Excel and saved with the .xls extension. >> >> >> >> -----Original Message----- >> >> From: Kola Oyedeji [mailto:[EMAIL PROTECTED] >> >> Sent: 31 July 2003 11:18 AM >> >> To: CF-Talk >> >> Subject: RE: Export to Excel - only alternate rows exported WHy?... >> >> >> >> >> >> I'm not sure how that custom tag works. Does it take a html table and >> >> convert it into an excel spreadsheet? If so does the original have >> >> alternate row colours? >> >> >> >> Kola >> >> >> >> >> -----Original Message----- >> >> >> From: Declan Maher [mailto:[EMAIL PROTECTED] >> >> >> Sent: 31 July 2003 10:43 >> >> >> To: CF-Talk >> >> >> Subject: RE: Export to Excel - only alternate rows exported >> WHy?... >> >> >> >> >> >> I am exporting to excel using the custom tag <cf_html2Excel>. >> >> Although >> >> >> all the correct data shows on the include page I am using, in >> other >> >> >> words the query that selects the data is correct, when I actually >> do >> >> the >> >> >> export all that shows in excel is every second row. >> >> >> >> >> >> Any help would be apprectiated. >> >> >> >> >> >> >> >> >> >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
