Re: Format Tables (Was RE: CF to excel)
> Can you show us the looping code? It's probably an > error in reusing too much of the sample code > > --- Janine Jakim <[EMAIL PROTECTED]> wrote: > > Thanks for all the input. Now for the next question. > > I am having a hard > > time formatting my html table correctly. I am using > > #Skill[1]# > > #Skill[2]# in the heading (I have also > > tried making it just a > > regular . But unfortunately it is > > giving each student a > > heading. > > ie: Reading MathSpelling > > JSmith A A A > > Reading MathSpelling > > SJones B B B > > > > So I have 2 questions: > > 1. Is there a way to get the heading to be for the > > whole page when I am > > using a variable? > > 2. Is there a way to make the #skill[1]# > > #Skill[2]#, etc. expand/constrict > > accordingly. > > (ie: 5th grade Math has 3 skills/ reading has 16 > > skills whereas 1st grade > > math has 21 skills and 19 reading skills) I > > don't want to have to make a > > different page for each subject/grade. If I just > > put #Skill# in the header > > it only gives me the 1st skill... Any ideas??? > > > > -Original Message- > > From: John Anderson [mailto:[EMAIL PROTECTED] > > Sent: Monday, September 17, 2001 4:00 PM > > To: CF-Talk > > Subject: RE: CF to excel > > > > > > You can create an html table and output that is an > > excel file as follows: > > > > > > > > > > > > > > First Name"> > > Last > > Name"> > > Office > > Phone"> > > Mobile > > Phone"> > > > &"Pager"> > > > > > &"<> td>#empfirstname##emplastname##officep##ce > > ll##pager#"> > > > > "> > > > > > > > > > > > > #excelstring# > > > > > > > > This output string that you have built will come > > across as an excel file. > > > > The key is in the cfcontent tag and cfheader tag. > > > > John Anderson > > aloha-webdesign.com > > > > -Original Message- > > From: Janine Jakim [mailto:[EMAIL PROTECTED] > > Sent: Monday, September 17, 2001 12:40 PM > > To: CF-Talk > > Subject: CF to excel > > > > > > How flexible is the process of generating excel > > files? > > I need to have an output that is dynamic for the > > columns and rows. > > For example: > > > > #student# #student# #student# #student# > > #Skill# #grade# #grade# #grade# #grade# > > #Skill# #grade# #grade# #grade# #grade# > > #Skill# #grade# #grade# #grade# #grade# > > > > Translating into: > > JohnSmith JanSmithSamJonessandyJones > > Reading C A A B > > MathB A B A > > English B B A C > > > > My tables are normalized. There are many tables that > > make this info. > > 1. One reference table that lists all the skills. > > 2. One table that shows student information. > > 3. One table that lists the studentID/skillID/Grade > > (hooks the student info > > with the skills reference table). > > 4. One reference table that lists the quarter and > > dates of the quarter so > > only the current quarter prints out. > > Is this possible? > > What are the steps to making it so? Do I need to > > make the information into > > an array(s) first? > > I've read the how to from Ben's CF5 book and the > > tutorial from cfcomet.com- > > but of course I want to make things more difficult. > > Thanks in advance. > > > > > > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305565 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF to excel
One possibility amongst others is that cfcontent is disabled in the administrator. The first thing to do is to get the actual error message from coldfusion as well as the error code (HTTP 500 = "something went wrong" - a little more info might come in handy). Check the error log file for that. Also, it looks like you have so called "friendly HTTP errors" on in IE - don't do that. Go to Tools -> Internet Options... -> Advanced -> Browsing (in IE) and make sure the "Show friendly HTTP error messages" checkbox is unchecked. Or maybe you are using a site wide error handler? /t >-Original Message- >From: Eric Creese [mailto:[EMAIL PROTECTED] >Sent: Tuesday, March 15, 2005 4:47 AM >To: CF-Talk >Subject: Re: CF to excel > >Okay I tried your suggestion and got the same error > > The page cannot be displayed > There is a problem with the page you are trying to reach >and it cannot >be displayed. > >--- >--- > > > > > > HTTP 500 - Internal server error > Internet Explorer > >- Original Message - >From: "Dawson, Michael" <[EMAIL PROTECTED]> >To: "CF-Talk" >Sent: Monday, March 14, 2005 9:32 PM >Subject: RE: CF to excel > > >> I use this with success: >> >> >> >> >> [html content goes here...] >> >> >> This code snippet should prompt you to download/save each spreadsheet >> w/o opening Excel directly. >> >> M!ke >> >> -Original Message- >> From: Eric Creese [mailto:[EMAIL PROTECTED] >> Sent: Monday, March 14, 2005 9:22 PM >> To: CF-Talk >> Subject: CF to excel >> >> How come the following will not work. I get a 500 error >> >> >> >> CLASS of #getYRInfo.class_year# Spread >> Sheet >> >> >> VALUE="filename=classroster.xls"> >> >> >> >> >> #fname# >> #lname# >> #mname# >> #addr1# >> #addr2# > >#city# >> #state# >> #country# >> #zip# > >#email# >> #phone# >> >> >> > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198833 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF to excel
Good question. If the page is not well-formed enough for Excel to work, it may have errors when running the page only in the browser. Also, make sure you are not just refreshing the actual page with the excel data in it. You will need to click on a link, or submit a form, that eventually calls the page. Refreshes can generate errors when sending non-HTML data through the response. M!ke -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 5:57 AM To: CF-Talk Subject: Re: CF to excel without the cfheader tags is the page loaind in the broiwser properly? Adam H ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198799 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF to excel
How about removing the reset="yes"? -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 6:57 AM To: CF-Talk Subject: Re: CF to excel without the cfheader tags is the page loaind in the broiwser properly? Adam H On Mon, 14 Mar 2005 21:47:16 -0600, Eric Creese <[EMAIL PROTECTED]> wrote: > Okay I tried your suggestion and got the same error > > The page cannot be displayed > There is a problem with the page you are trying to reach and it cannot > be displayed. > > -- > > HTTP 500 - Internal server error > Internet Explorer > > - Original Message - > From: "Dawson, Michael" <[EMAIL PROTECTED]> > To: "CF-Talk" > Sent: Monday, March 14, 2005 9:32 PM > Subject: RE: CF to excel > > > I use this with success: > > > > > > > > > > [html content goes here...] > > > > > > This code snippet should prompt you to download/save each spreadsheet > > w/o opening Excel directly. > > > > M!ke > > > > -Original Message- > > From: Eric Creese [mailto:[EMAIL PROTECTED] > > Sent: Monday, March 14, 2005 9:22 PM > > To: CF-Talk > > Subject: CF to excel > > > > How come the following will not work. I get a 500 error > > > > > > > > CLASS of #getYRInfo.class_year# Spread > > Sheet > > > > > > > > > > > > > > > > #fname# > > #lname# > > #mname# > > #addr1# > > #addr2# > >#city# > > #state# > > #country# > > #zip# > >#email# > > #phone# > > > > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198790 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF to excel
without the cfheader tags is the page loaind in the broiwser properly? Adam H On Mon, 14 Mar 2005 21:47:16 -0600, Eric Creese <[EMAIL PROTECTED]> wrote: > Okay I tried your suggestion and got the same error > > The page cannot be displayed > There is a problem with the page you are trying to reach and it cannot > be displayed. > > -- > > HTTP 500 - Internal server error > Internet Explorer > > - Original Message - > From: "Dawson, Michael" <[EMAIL PROTECTED]> > To: "CF-Talk" > Sent: Monday, March 14, 2005 9:32 PM > Subject: RE: CF to excel > > > I use this with success: > > > > > > > > > > [html content goes here...] > > > > > > This code snippet should prompt you to download/save each spreadsheet > > w/o opening Excel directly. > > > > M!ke > > > > -Original Message- > > From: Eric Creese [mailto:[EMAIL PROTECTED] > > Sent: Monday, March 14, 2005 9:22 PM > > To: CF-Talk > > Subject: CF to excel > > > > How come the following will not work. I get a 500 error > > > > > > > > CLASS of #getYRInfo.class_year# Spread > > Sheet > > > > > > > > > > > > > > > > #fname# > > #lname# > > #mname# > > #addr1# > > #addr2# > >#city# > > #state# > > #country# > > #zip# > >#email# > > #phone# > > > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198788 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF to excel
Okay I tried your suggestion and got the same error The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. -- HTTP 500 - Internal server error Internet Explorer - Original Message - From: "Dawson, Michael" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, March 14, 2005 9:32 PM Subject: RE: CF to excel > I use this with success: > > > > > [html content goes here...] > > > This code snippet should prompt you to download/save each spreadsheet > w/o opening Excel directly. > > M!ke > > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Monday, March 14, 2005 9:22 PM > To: CF-Talk > Subject: CF to excel > > How come the following will not work. I get a 500 error > > > > CLASS of #getYRInfo.class_year# Spread > Sheet > > > > > > > > #fname# > #lname# > #mname# > #addr1# > #addr2# >#city# > #state# > #country# > #zip# >#email# > #phone# > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF to excel
I use this with success: [html content goes here...] This code snippet should prompt you to download/save each spreadsheet w/o opening Excel directly. M!ke -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:22 PM To: CF-Talk Subject: CF to excel How come the following will not work. I get a 500 error CLASS of #getYRInfo.class_year# Spread Sheet #fname# #lname# #mname# #addr1# #addr2# #city# #state# #country# #zip# #email# #phone# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198766 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CF to excel
How come the following will not work. I get a 500 error CLASS of #getYRInfo.class_year# Spread Sheet #fname# #lname# #mname# #addr1# #addr2# #city# #state# #country# #zip# #email# #phone# ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198764 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF to excel formatting questions
It's not just you... However, the following code is a prototype custom tag to place an excel XP web component in a web page...Enjoy. ss:Type="Number"ss:Type="String">#variable s.thedata# http://www.w3.org/TR/REC-html40";> Untitled http://www.w3.org/TR/REC-html40"> ; <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> <Author>Fig Leaf Software</Author> <Created>2002-09-28T12:37:05Z</Created> <Company>Personal</Company> <Version>10.4219</Version> </DocumentProperties> <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> <DownloadComponents/> <LocationOfComponents HRef="file:///\\"/> </OfficeDocumentSettings> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> <PublishObjects> <PublishObject> <Id>10875</Id> <DivID>Book1_10875</DivID> <SourceType>SourceWorkbook</SourceType> <HtmlType>HtmlCalc</HtmlType> <Location x:HRef="C:\WINNT\Profiles\sdrucker\Desktop\Book1.htm"/> 0; </PublishObject> </PublishObjects> <WindowHeight>9855</WindowHeight> <WindowWidth>11340</WindowWidth> <WindowTopX>480</WindowTopX> <WindowTopY>15</WindowTopY> <ProtectStructure>False</ProtectStructure> <ProtectWindows>False</ProtectWindows> </ExcelWorkbook> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font/> <Interior/> <NumberFormat/> <Protection/> </Style> </Styles> <Worksheet ss:Name="Sheet1"> <Table ss:ExpandedColumnCount="#listlen(attributes.lcolumns)#" ss:ExpandedRowCount="#attributes.qdata.recordcount#" x:FullColumns="1" x:FullRows="1"> #queryxml# </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> <Worksheet ss:Name="Sheet2"> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <TopRowVisible>0</TopRowVisible> <LeftColumnVisible>0</LeftColumnVisible> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> <Worksheet ss:Name="Sheet3"> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <TopRowVisible>0</TopRowVisible> <LeftColumnVisible>0</LeftColumnVisible> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> </Workbook> "> To use this Web page interactively, you must have Microsoft(r) Internet Explorer 4.01 Service Pack 1 (SP1) or later and the Microsoft Office XP Web Components. Click here to install the Office XP Web Components. See the http://office.microsoft.com/office/redirect/10/MSOWCPub.asp?HelpLCID=1 033">Microsoft Office Web site for more information. > -Original Message- > From: Brook Davies [mailto:brook@;maracasmedia.com] > Sent: Tuesday, October 22, 2002 2:26 PM > To: CF-Talk > Subject: RE: CF to excel formatting questions > > Is it just me or does CFGRID actually suck? > > I just did a search on google for ""Microsoft Office web components", the > results are scary. > http://www.google.ca/search?hl=en&ie=UTF-8&oe=UTF- > 8&q=%22Microsoft+Office+we > b+components%22&meta= > > -Brook > > At 02:07 PM 22/10/02 -0400, you wrote: > >If all of your users have Excel, then you might look into using the > >Microsoft Office web components. Web components allow you to embed an > >activeX excel control on a web page -- inheriting the basic Excel > >functionality. It's really the ultimate CFGRID replacement. Information > >can be passed to the control as XML. > > > >Regards, > >Steve Drucker > >CEO > >Fig Leaf Software > >www.figleaf.com > > > > > -Original Message- > > > From: Janine Jakim [mailto:jjakim@;albemarle.org] > > > Sent: Tuesday, October 22, 2002 11:14 AM > > > To: CF-Talk > > > Subject: CF to excel formatting questions > > > > > > I'm using the basic call to excel (as explained by BF in his book) > because > > > I > > > do know that all my users have excel. > > > My questions: > > > 1. Can you add an excel toolbar- I want the users to be able to sort > the > > > information on any of the columns. > > > 2. Is there any way to get it so that the headings can wrap. Some of > my > > > headings are long so instead of making a long stretchy heading. > > > Thanks in advance for any help. > > > J > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CF to excel formatting questions
Is it just me or does CFGRID actually suck? I just did a search on google for ""Microsoft Office web components", the results are scary. http://www.google.ca/search?hl=en&ie=UTF-8&oe=UTF-8&q=%22Microsoft+Office+we b+components%22&meta= -Brook At 02:07 PM 22/10/02 -0400, you wrote: >If all of your users have Excel, then you might look into using the >Microsoft Office web components. Web components allow you to embed an >activeX excel control on a web page -- inheriting the basic Excel >functionality. It's really the ultimate CFGRID replacement. Information >can be passed to the control as XML. > >Regards, >Steve Drucker >CEO >Fig Leaf Software >www.figleaf.com > > > -Original Message- > > From: Janine Jakim [mailto:jjakim@;albemarle.org] > > Sent: Tuesday, October 22, 2002 11:14 AM > > To: CF-Talk > > Subject: CF to excel formatting questions > > > > I'm using the basic call to excel (as explained by BF in his book) because > > I > > do know that all my users have excel. > > My questions: > > 1. Can you add an excel toolbar- I want the users to be able to sort the > > information on any of the columns. > > 2. Is there any way to get it so that the headings can wrap. Some of my > > headings are long so instead of making a long stretchy heading. > > Thanks in advance for any help. > > J > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CF to excel formatting questions
If all of your users have Excel, then you might look into using the Microsoft Office web components. Web components allow you to embed an activeX excel control on a web page -- inheriting the basic Excel functionality. It's really the ultimate CFGRID replacement. Information can be passed to the control as XML. Regards, Steve Drucker CEO Fig Leaf Software www.figleaf.com > -Original Message- > From: Janine Jakim [mailto:jjakim@;albemarle.org] > Sent: Tuesday, October 22, 2002 11:14 AM > To: CF-Talk > Subject: CF to excel formatting questions > > I'm using the basic call to excel (as explained by BF in his book) because > I > do know that all my users have excel. > My questions: > 1. Can you add an excel toolbar- I want the users to be able to sort the > information on any of the columns. > 2. Is there any way to get it so that the headings can wrap. Some of my > headings are long so instead of making a long stretchy heading. > Thanks in advance for any help. > J > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CF to excel formatting questions
At 05:25 PM 10/22/02 +0100, Kola Oyedeji wrote: >Thane > >What exactly are web queries? A web query is created in Excel and allow Excel to read and import data from a webpage. E-mail me offlist if you want more info. T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CF to excel formatting questions
Thane What exactly are web queries? Thanks Kola >> -Original Message- >> From: Thane Sherrington [mailto:tsherr@;auracom.com] >> Sent: 22 October 2002 16:24 >> To: CF-Talk >> Subject: Re: CF to excel formatting questions >> >> At 11:13 AM 22/10/02 -0400, Janine Jakim wrote: >> >I'm using the basic call to excel (as explained by BF in his book) >> because I >> >do know that all my users have excel. >> >My questions: >> >1. Can you add an excel toolbar- I want the users to be able to sort >> the >> >information on any of the columns. >> >2. Is there any way to get it so that the headings can wrap. Some of >> my >> >headings are long so instead of making a long stretchy heading. >> >Thanks in advance for any help. >> >> I did my CF to Excel functionality by using webqueries. They work well, >> and since the data is in Excel, one can use all of Excel's >> functions/formatting on it. >> >> T >> >> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
Re: CF to excel formatting questions
At 11:13 AM 22/10/02 -0400, Janine Jakim wrote: >I'm using the basic call to excel (as explained by BF in his book) because I >do know that all my users have excel. >My questions: >1. Can you add an excel toolbar- I want the users to be able to sort the >information on any of the columns. >2. Is there any way to get it so that the headings can wrap. Some of my >headings are long so instead of making a long stretchy heading. >Thanks in advance for any help. I did my CF to Excel functionality by using webqueries. They work well, and since the data is in Excel, one can use all of Excel's functions/formatting on it. T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CF to excel formatting questions
I'm using the basic call to excel (as explained by BF in his book) because I do know that all my users have excel. My questions: 1. Can you add an excel toolbar- I want the users to be able to sort the information on any of the columns. 2. Is there any way to get it so that the headings can wrap. Some of my headings are long so instead of making a long stretchy heading. Thanks in advance for any help. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: cf to excel formatting problem
thinking aloud. 1) export / import as a text field 2) single quote at the front of the field How are you importing / exporting? Eric Dawson From: Nathan Shaw <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: cf to excel formatting problem Date: Mon, 29 Oct 2001 10:48:29 -0800 (PST) I am exporting some data to Excel and one of the fields is zip code. Excel is stripping all leading 0's (zeros) off of the zip codes. I need it to leave the zip code alone, i.e. treat it as text instead of a number. Any ideas anyone? So far, I have tried: 1) Using an obscure ASCII char in front of the zip. RESULT: Excel puts in a box when it encounters an ASCII char it does not understand 2) Enclosing the zip in both single quotes and double quotes. RESULT: Excel leaves the quotes in instead of treating them as a text qualifier 3) Looked at the Allaire forums, where I saw the same question asked but not answered. 4) Read up on Excel at cfcomet, but most things there are a little overkill for what I am trying to do. TIA, Nate = Nathan Shaw Senior Web Applications Developer iaffect, Inc. http://www.iaffectonline.com ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cf to excel formatting problem
If you open the file directly into excel, this happens. (I deal with a lot of UPC's with leading zeros). However, if you open excel, then import text file, you have the opportunity to tell it how to treat each column (selecting text for your zip column) and everything is then cool. All else fails, I put a single quote in front of the number. That's Excel's internal notation that something is text and sometimes it works, sometimes it leaves the quote there. I haven't figured out why. > I am exporting some data to Excel and one of the > fields is zip code. Excel is stripping all leading 0's > (zeros) off of the zip codes. I need it to leave the > zip code alone, i.e. treat it as text instead of a > number. Any ideas anyone? > > So far, I have tried: > 1) Using an obscure ASCII char in front of the zip. > RESULT: Excel puts in a box when it encounters an > ASCII char it does not understand > > 2) Enclosing the zip in both single quotes and double > quotes. > RESULT: Excel leaves the quotes in instead of treating > them as a text qualifier > > 3) Looked at the Allaire forums, where I saw the same > question asked but not answered. > > 4) Read up on Excel at cfcomet, but most things there > are a little overkill for what I am trying to do. > > TIA, > > Nate > > = > > Nathan Shaw > Senior Web Applications Developer > iaffect, Inc. > http://www.iaffectonline.com > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf to excel formatting problem
I am exporting some data to Excel and one of the fields is zip code. Excel is stripping all leading 0's (zeros) off of the zip codes. I need it to leave the zip code alone, i.e. treat it as text instead of a number. Any ideas anyone? So far, I have tried: 1) Using an obscure ASCII char in front of the zip. RESULT: Excel puts in a box when it encounters an ASCII char it does not understand 2) Enclosing the zip in both single quotes and double quotes. RESULT: Excel leaves the quotes in instead of treating them as a text qualifier 3) Looked at the Allaire forums, where I saw the same question asked but not answered. 4) Read up on Excel at cfcomet, but most things there are a little overkill for what I am trying to do. TIA, Nate = Nathan Shaw Senior Web Applications Developer iaffect, Inc. http://www.iaffectonline.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cf to excel display issue
Hi Janine, If you're using oracle, there's a great way around this (and I'd assume sql server has something similar). Use the nvl function in your query like so: SELECTnvl(columnname, 0) FROM yourtable. nvl basically replaces nulls with something else. The only caveat is that the replacement must be of the same datatype as the original column. So, if you don't want zeros to show up for a number column, you'd have to do a replace in your cfoutput to replace the zeros with "null" or something similar. Hope that helps. -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf to excel display issue
I have set up an excel sheet to show results of a search. I also want to add another search- when the field is null or X. The query works, however, it does not show up correctly on the excel sheet. 1. The excel sheet does not line the nulls under the correct headings. No matter where on the sheet the nulls are, the excel sheet fills in the nulls as if they were at the begining and then leaves half drawn spreadsheat at the end. For example: If I wanted the following to show Heading1Heading2Heading3Heading4Heading5 Heading6 A B C (Null) (Null) D it shows up like: Heading1Heading2Heading3Heading4Heading5 Heading6 (Null) (Null) So I think it's like a list- filling in/not having any blanks. So I'm not quite sure how to get it to display correctly. I hope I've made this clear- I'm finding it difficult to explain. Is there a good way to do what I want to do? ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF to excel
Believe it or not -- Windows 98 and higher has an Import to Excel function. Just right mouse click on the coldfusion table you want to turn into Excel, and a menu comes up saying Import to Excel. It is NOT in Windows 95 though. Julia Computer Consulting Web Design @ Reasonable Prices PO Box 279 Watertown MA 02471-0279 Email: [EMAIL PROTECTED] http://www.juliagreen.com Phone: 617-926-3413 Fax: 617-812-5935 - Original Message - From: "Janine Jakim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 17, 2001 3:39 PM Subject: CF to excel > How flexible is the process of generating excel files? > I need to have an output that is dynamic for the columns and rows. > For example: > > #student# #student# #student# #student# > #Skill# #grade# #grade# #grade# #grade# > #Skill# #grade# #grade# #grade# #grade# > #Skill# #grade# #grade# #grade# #grade# > > Translating into: > JohnSmith JanSmith SamJones sandyJones > Reading CAAB > Math BABA > English BBAC > > My tables are normalized. There are many tables that make this info. > 1. One reference table that lists all the skills. > 2. One table that shows student information. > 3. One table that lists the studentID/skillID/Grade (hooks the student info > with the skills reference table). > 4. One reference table that lists the quarter and dates of the quarter so > only the current quarter prints out. > Is this possible? > What are the steps to making it so? Do I need to make the information into > an array(s) first? > I've read the how to from Ben's CF5 book and the tutorial from cfcomet.com- > but of course I want to make things more difficult. > Thanks in advance. > ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Format Tables (Was RE: CF to excel)
Janine, There seems to be an error in your posted code, as you have 3 s to 2 . I'm surprised CF didn't give you an error message. It looks to me like you need to take the #Skill# outside so it isn't nested inside I'd do something like #Skill# ... Also, there's a place where it reads where the should go inside of --- Janine Jakim <[EMAIL PROTECTED]> wrote: > Ok I answered question 2. I found that using > #Skill# will go > through all the skills so that > I don't need to do Skill1, Skill2, Skill3 > Now I still have the issue of my headers showing up > before each student. > This is my code: > > > > > #Skill# > > > > #LASTNAME#, #FIRSTNAME# > > >#Grade# > > > > > > -Original Message- > From: cf refactoring > [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 18, 2001 10:38 AM > To: CF-Talk > Subject: Re: Format Tables (Was RE: CF to excel) > > > Can you show us the looping code? It's probably an > error in reusing too much of the sample code > > --- Janine Jakim <[EMAIL PROTECTED]> wrote: > > Thanks for all the input. Now for the next > question. > > I am having a hard > > time formatting my html table correctly. I am > using > > #Skill[1]# > > #Skill[2]# in the heading (I have also > > tried making it just a > > regular . But unfortunately it > is > > giving each student a > > heading. > > ie: Reading MathSpelling > > JSmith A A A > > Reading MathSpelling > > SJones B B B > > > > So I have 2 questions: > > 1. Is there a way to get the heading to be for the > > whole page when I am > > using a variable? > > 2. Is there a way to make the #skill[1]# > > #Skill[2]#, etc. expand/constrict > > accordingly. > > (ie: 5th grade Math has 3 skills/ reading has 16 > > skills whereas 1st grade > > math has 21 skills and 19 reading skills) I > > don't want to have to make a > > different page for each subject/grade. If I just > > put #Skill# in the header > > it only gives me the 1st skill... Any ideas??? > > > > -Original Message- > > From: John Anderson [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 17, 2001 4:00 PM > > To: CF-Talk > > Subject: RE: CF to excel > > > > > > You can create an html table and output that is an > > excel file as follows: > > > > > > > > > > > > > > First Name"> > > Last > > Name"> > > Office > > Phone"> > > Mobile > > Phone"> > > > &"Pager"> > > > > > > &"#empfirstname##emplastname##officep##ce > > ll##pager#"> > > > > "> > > > > > > > > VALUE="inline; > > filename=download.xls"> > > > > #excelstring# > > > > > > > > This output string that you have built will come > > across as an excel file. > > > > The key is in the cfcontent tag and cfheader tag. > > > > John Anderson > > aloha-webdesign.com > > > > -Original Message- > > From: Janine Jakim [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 17, 2001 12:40 PM > > To: CF-Talk > > Subject: CF to excel > > > > > > How flexible is the process of generating excel > > files? > > I need to have an output that is dynamic for the > > columns and rows. > > For example: > > > > #student# #student# #student# #student# > > #Skill# #grade# #grade# #grade# #grade# > > #Skill# #grade# #grade# #grade# #grade# > > #Skill# #grade# #grade# #grade# #grade# > > > > Translating into: > > JohnSmith JanSmithSamJonessandyJones > > Reading C A A B > > MathB A
RE: Format Tables (Was RE: CF to excel)
Ok I answered question 2. I found that using #Skill# will go through all the skills so that I don't need to do Skill1, Skill2, Skill3 Now I still have the issue of my headers showing up before each student. This is my code: #Skill# #LASTNAME#, #FIRSTNAME# #Grade# -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 10:38 AM To: CF-Talk Subject: Re: Format Tables (Was RE: CF to excel) Can you show us the looping code? It's probably an error in reusing too much of the sample code --- Janine Jakim <[EMAIL PROTECTED]> wrote: > Thanks for all the input. Now for the next question. > I am having a hard > time formatting my html table correctly. I am using > #Skill[1]# > #Skill[2]# in the heading (I have also > tried making it just a > regular . But unfortunately it is > giving each student a > heading. > ie: Reading MathSpelling > JSmithA A A > Reading MathSpelling > SJonesB B B > > So I have 2 questions: > 1. Is there a way to get the heading to be for the > whole page when I am > using a variable? > 2. Is there a way to make the #skill[1]# > #Skill[2]#, etc. expand/constrict > accordingly. > (ie: 5th grade Math has 3 skills/ reading has 16 > skills whereas 1st grade > math has 21 skills and 19 reading skills) I > don't want to have to make a > different page for each subject/grade. If I just > put #Skill# in the header > it only gives me the 1st skill... Any ideas??? > > -Original Message- > From: John Anderson [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 17, 2001 4:00 PM > To: CF-Talk > Subject: RE: CF to excel > > > You can create an html table and output that is an > excel file as follows: > > > > > > > First Name"> > Last > Name"> > Office > Phone"> > Mobile > Phone"> >&"Pager"> > > &"#empfirstname##emplastname##officep##ce > ll##pager#"> > > "> > > > > > > #excelstring# > > > > This output string that you have built will come > across as an excel file. > > The key is in the cfcontent tag and cfheader tag. > > John Anderson > aloha-webdesign.com > > -Original Message- > From: Janine Jakim [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 17, 2001 12:40 PM > To: CF-Talk > Subject: CF to excel > > > How flexible is the process of generating excel > files? > I need to have an output that is dynamic for the > columns and rows. > For example: > > #student# #student# #student# #student# > #Skill# #grade# #grade# #grade# #grade# > #Skill# #grade# #grade# #grade# #grade# > #Skill# #grade# #grade# #grade# #grade# > > Translating into: > JohnSmith JanSmithSamJonessandyJones > Reading C A A B > Math B A B A > English B B A C > > My tables are normalized. There are many tables that > make this info. > 1. One reference table that lists all the skills. > 2. One table that shows student information. > 3. One table that lists the studentID/skillID/Grade > (hooks the student info > with the skills reference table). > 4. One reference table that lists the quarter and > dates of the quarter so > only the current quarter prints out. > Is this possible? > What are the steps to making it so? Do I need to > make the information into > an array(s) first? > I've read the how to from Ben's CF5 book and the > tutorial from cfcomet.com- > but of course I want to make things more difficult. > Thanks in advance. > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Format Tables (Was RE: CF to excel)
Can you show us the looping code? It's probably an error in reusing too much of the sample code --- Janine Jakim <[EMAIL PROTECTED]> wrote: > Thanks for all the input. Now for the next question. > I am having a hard > time formatting my html table correctly. I am using > #Skill[1]# > #Skill[2]# in the heading (I have also > tried making it just a > regular . But unfortunately it is > giving each student a > heading. > ie: Reading MathSpelling > JSmithA A A > Reading MathSpelling > SJonesB B B > > So I have 2 questions: > 1. Is there a way to get the heading to be for the > whole page when I am > using a variable? > 2. Is there a way to make the #skill[1]# > #Skill[2]#, etc. expand/constrict > accordingly. > (ie: 5th grade Math has 3 skills/ reading has 16 > skills whereas 1st grade > math has 21 skills and 19 reading skills) I > don't want to have to make a > different page for each subject/grade. If I just > put #Skill# in the header > it only gives me the 1st skill... Any ideas??? > > -Original Message- > From: John Anderson [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 17, 2001 4:00 PM > To: CF-Talk > Subject: RE: CF to excel > > > You can create an html table and output that is an > excel file as follows: > > > > > > > First Name"> > Last > Name"> > Office > Phone"> > Mobile > Phone"> >&"Pager"> > > &"#empfirstname##emplastname##officep##ce > ll##pager#"> > > "> > > > > > > #excelstring# > > > > This output string that you have built will come > across as an excel file. > > The key is in the cfcontent tag and cfheader tag. > > John Anderson > aloha-webdesign.com > > -Original Message- > From: Janine Jakim [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 17, 2001 12:40 PM > To: CF-Talk > Subject: CF to excel > > > How flexible is the process of generating excel > files? > I need to have an output that is dynamic for the > columns and rows. > For example: > > #student# #student# #student# #student# > #Skill# #grade# #grade# #grade# #grade# > #Skill# #grade# #grade# #grade# #grade# > #Skill# #grade# #grade# #grade# #grade# > > Translating into: > JohnSmith JanSmithSamJonessandyJones > Reading C A A B > Math B A B A > English B B A C > > My tables are normalized. There are many tables that > make this info. > 1. One reference table that lists all the skills. > 2. One table that shows student information. > 3. One table that lists the studentID/skillID/Grade > (hooks the student info > with the skills reference table). > 4. One reference table that lists the quarter and > dates of the quarter so > only the current quarter prints out. > Is this possible? > What are the steps to making it so? Do I need to > make the information into > an array(s) first? > I've read the how to from Ben's CF5 book and the > tutorial from cfcomet.com- > but of course I want to make things more difficult. > Thanks in advance. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Format Tables (Was RE: CF to excel)
Try this: Skill1Skill2Skill3 #StudentName##ReadingScore##MathScore#Spellin gScore# This should get you started toward what you want. I don;t have time to right the whole page layout right now, but I hope that this will help you in the right direction. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 9:01 AM To: CF-Talk Subject: Format Tables (Was RE: CF to excel) Thanks for all the input. Now for the next question. I am having a hard time formatting my html table correctly. I am using #Skill[1]# #Skill[2]# in the heading (I have also tried making it just a regular . But unfortunately it is giving each student a heading. ie: Reading MathSpelling JSmith A A A Reading MathSpelling SJones B B B So I have 2 questions: 1. Is there a way to get the heading to be for the whole page when I am using a variable? 2. Is there a way to make the #skill[1]# #Skill[2]#, etc. expand/constrict accordingly. (ie: 5th grade Math has 3 skills/ reading has 16 skills whereas 1st grade math has 21 skills and 19 reading skills) I don't want to have to make a different page for each subject/grade. If I just put #Skill# in the header it only gives me the 1st skill... Any ideas??? -Original Message- From: John Anderson [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 4:00 PM To: CF-Talk Subject: RE: CF to excel You can create an html table and output that is an excel file as follows: First Name"> Last Name"> Office Phone"> Mobile Phone"> Pager"> #empfirstname##emplastname##officep##ce ll##pager#"> "> #excelstring# This output string that you have built will come across as an excel file. The key is in the cfcontent tag and cfheader tag. John Anderson aloha-webdesign.com -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 12:40 PM To: CF-Talk Subject: CF to excel How flexible is the process of generating excel files? I need to have an output that is dynamic for the columns and rows. For example: #student# #student# #student# #student# #Skill# #grade# #grade# #grade# #grade# #Skill# #grade# #grade# #grade# #grade# #Skill# #grade# #grade# #grade# #grade# Translating into: JohnSmith JanSmithSamJonessandyJones Reading C A A B MathB A B A English B B A C My tables are normalized. There are many tables that make this info. 1. One reference table that lists all the skills. 2. One table that shows student information. 3. One table that lists the studentID/skillID/Grade (hooks the student info with the skills reference table). 4. One reference table that lists the quarter and dates of the quarter so only the current quarter prints out. Is this possible? What are the steps to making it so? Do I need to make the information into an array(s) first? I've read the how to from Ben's CF5 book and the tutorial from cfcomet.com- but of course I want to make things more difficult. Thanks in advance. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Format Tables (Was RE: CF to excel)
Thanks for all the input. Now for the next question. I am having a hard time formatting my html table correctly. I am using #Skill[1]# #Skill[2]# in the heading (I have also tried making it just a regular . But unfortunately it is giving each student a heading. ie: Reading MathSpelling JSmith A A A Reading MathSpelling SJones B B B So I have 2 questions: 1. Is there a way to get the heading to be for the whole page when I am using a variable? 2. Is there a way to make the #skill[1]# #Skill[2]#, etc. expand/constrict accordingly. (ie: 5th grade Math has 3 skills/ reading has 16 skills whereas 1st grade math has 21 skills and 19 reading skills) I don't want to have to make a different page for each subject/grade. If I just put #Skill# in the header it only gives me the 1st skill... Any ideas??? -Original Message- From: John Anderson [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 4:00 PM To: CF-Talk Subject: RE: CF to excel You can create an html table and output that is an excel file as follows: First Name"> Last Name"> Office Phone"> Mobile Phone"> Pager"> #empfirstname##emplastname##officep##ce ll##pager#"> "> #excelstring# This output string that you have built will come across as an excel file. The key is in the cfcontent tag and cfheader tag. John Anderson aloha-webdesign.com -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 12:40 PM To: CF-Talk Subject: CF to excel How flexible is the process of generating excel files? I need to have an output that is dynamic for the columns and rows. For example: #student# #student# #student# #student# #Skill# #grade# #grade# #grade# #grade# #Skill# #grade# #grade# #grade# #grade# #Skill# #grade# #grade# #grade# #grade# Translating into: JohnSmith JanSmithSamJonessandyJones Reading C A A B MathB A B A English B B A C My tables are normalized. There are many tables that make this info. 1. One reference table that lists all the skills. 2. One table that shows student information. 3. One table that lists the studentID/skillID/Grade (hooks the student info with the skills reference table). 4. One reference table that lists the quarter and dates of the quarter so only the current quarter prints out. Is this possible? What are the steps to making it so? Do I need to make the information into an array(s) first? I've read the how to from Ben's CF5 book and the tutorial from cfcomet.com- but of course I want to make things more difficult. Thanks in advance. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF to excel
It is just like from a database. Only difference is how you call the table. SELECT DISTINCT [YOURFIELD] FROM `YOURTABLE$` Make sure that you have the spreadsheet set up as a system DSN and then make certain you place the ` in front of your tablename and the $` after your table name. Then output your query just like you do from a database query Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 2:40 PM To: CF-Talk Subject: CF to excel How flexible is the process of generating excel files? I need to have an output that is dynamic for the columns and rows. For example: #student# #student# #student# #student# #Skill# #grade# #grade# #grade# #grade# #Skill# #grade# #grade# #grade# #grade# #Skill# #grade# #grade# #grade# #grade# Translating into: JohnSmith JanSmithSamJonessandyJones Reading C A A B MathB A B A English B B A C My tables are normalized. There are many tables that make this info. 1. One reference table that lists all the skills. 2. One table that shows student information. 3. One table that lists the studentID/skillID/Grade (hooks the student info with the skills reference table). 4. One reference table that lists the quarter and dates of the quarter so only the current quarter prints out. Is this possible? What are the steps to making it so? Do I need to make the information into an array(s) first? I've read the how to from Ben's CF5 book and the tutorial from cfcomet.com- but of course I want to make things more difficult. Thanks in advance. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF to excel
You can create an html table and output that is an excel file as follows: First Name"> Last Name"> Office Phone"> Mobile Phone"> Pager"> #empfirstname##emplastname##officep##ce ll##pager#"> "> #excelstring# This output string that you have built will come across as an excel file. The key is in the cfcontent tag and cfheader tag. John Anderson aloha-webdesign.com -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 12:40 PM To: CF-Talk Subject: CF to excel How flexible is the process of generating excel files? I need to have an output that is dynamic for the columns and rows. For example: #student# #student# #student# #student# #Skill# #grade# #grade# #grade# #grade# #Skill# #grade# #grade# #grade# #grade# #Skill# #grade# #grade# #grade# #grade# Translating into: JohnSmith JanSmithSamJonessandyJones Reading C A A B MathB A B A English B B A C My tables are normalized. There are many tables that make this info. 1. One reference table that lists all the skills. 2. One table that shows student information. 3. One table that lists the studentID/skillID/Grade (hooks the student info with the skills reference table). 4. One reference table that lists the quarter and dates of the quarter so only the current quarter prints out. Is this possible? What are the steps to making it so? Do I need to make the information into an array(s) first? I've read the how to from Ben's CF5 book and the tutorial from cfcomet.com- but of course I want to make things more difficult. Thanks in advance. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF to excel
Excel can read the following kinds of files: comma delimited files tab delimited files HTML tables I prefer HTML tables as you get to keep all the formatting information. For example, if you cut and paste the following table code into a file heading italic colored data one two You can open it with excel and see the result. This doesn't exactly answer your question as I'm not sure exactly how dynamic you need your data to be. --- Janine Jakim <[EMAIL PROTECTED]> wrote: > How flexible is the process of generating excel > files? = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF to excel
How flexible is the process of generating excel files? I need to have an output that is dynamic for the columns and rows. For example: #student# #student# #student# #student# #Skill# #grade# #grade# #grade# #grade# #Skill# #grade# #grade# #grade# #grade# #Skill# #grade# #grade# #grade# #grade# Translating into: JohnSmith JanSmithSamJonessandyJones Reading C A A B MathB A B A English B B A C My tables are normalized. There are many tables that make this info. 1. One reference table that lists all the skills. 2. One table that shows student information. 3. One table that lists the studentID/skillID/Grade (hooks the student info with the skills reference table). 4. One reference table that lists the quarter and dates of the quarter so only the current quarter prints out. Is this possible? What are the steps to making it so? Do I need to make the information into an array(s) first? I've read the how to from Ben's CF5 book and the tutorial from cfcomet.com- but of course I want to make things more difficult. Thanks in advance. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF to Excel
I dont know if the last email I sent will reach you so here you go... SELECT AdviserName, AdviserAspect, CoachName FROM UserInfo Click Here to open your report in Excel! -Original Message- From: Cary Gordon [mailto:[EMAIL PROTECTED]] Sent: Monday, June 05, 2000 7:22 AM To: [EMAIL PROTECTED] Subject: Re: CF to Excel The easiest way is to output an Excel readable text file, like a csv or tab delimited file. Cary At 02:01 PM 6/2/2000 -0700, you wrote: >How can I take the results of a Query and save it as an Excel file? > >This is what I though would work. > >Thanks all! > > > SELECT END_ITEM_ROOT_PN, END_ITEM_SN > FROM DSTS.B_V_DSTS_ASSEMBLY > ORDER BY END_ITEM_ROOT_PN, END_ITEM_SN > > > >#END_ITEM_ROOT_PN# #END_ITEM_SN# > >Jim Ray >Delta Program NT Administrator >The Boeing Company >(714) 896-2038 >Email: [EMAIL PROTECTED] >Website: http://deltaweb.lgb.cal.boeing.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF to Excel
I just ran into this myself and heres what I came up with. The problem was with CFCOntent and NT SP6 and 6a. I hope can help someone... SELECT AdviserName, AdviserAspect, CoachName FROM UserInfo Click Here to open your report in Excel! -Original Message- From: Cary Gordon [mailto:[EMAIL PROTECTED]] Sent: Monday, June 05, 2000 7:22 AM To: [EMAIL PROTECTED] Subject: Re: CF to Excel The easiest way is to output an Excel readable text file, like a csv or tab delimited file. Cary At 02:01 PM 6/2/2000 -0700, you wrote: >How can I take the results of a Query and save it as an Excel file? > >This is what I though would work. > >Thanks all! > > > SELECT END_ITEM_ROOT_PN, END_ITEM_SN > FROM DSTS.B_V_DSTS_ASSEMBLY > ORDER BY END_ITEM_ROOT_PN, END_ITEM_SN > > > >#END_ITEM_ROOT_PN# #END_ITEM_SN# > >Jim Ray >Delta Program NT Administrator >The Boeing Company >(714) 896-2038 >Email: [EMAIL PROTECTED] >Website: http://deltaweb.lgb.cal.boeing.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF to Excel
Try writing your output with CFFile First, create a new file with your first line being a tab delimited column head names: Next, append your query results, again, delimit with tabs -- you'll want to surround your CFFile-append with a CFLoop query loop: H. = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = > -Original Message- > From: Ray, James A [SMTP:[EMAIL PROTECTED]] > Sent: Friday, June 02, 2000 2:01 PM > To: [EMAIL PROTECTED] > Subject: CF to Excel > > How can I take the results of a Query and save it as an Excel file? > > This is what I though would work. > > Thanks all! > > > SELECT END_ITEM_ROOT_PN, END_ITEM_SN > FROM DSTS.B_V_DSTS_ASSEMBLY > ORDER BY END_ITEM_ROOT_PN, END_ITEM_SN > > > > #END_ITEM_ROOT_PN# #END_ITEM_SN# > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF to Excel
There are several Custom tags availabe on the Allaire tag gallery that will allow you to do this if you want to do it that way. Try this: http://devex.allaire.com/Developer/Gallery/SearchResults.cfm?keywords=excel Hope that helps, Sam Dutkin Programmer Internet Development IBS Interactive (NASDAQ: IBSX) Phone: (856) 985-5200, x 101 Fax: (856) 985-3363 [EMAIL PROTECTED] -Original Message- From: Ray, James A [mailto:[EMAIL PROTECTED]] Sent: Friday, June 02, 2000 5:01 PM To: [EMAIL PROTECTED] Subject: CF to Excel How can I take the results of a Query and save it as an Excel file? This is what I though would work. Thanks all! SELECT END_ITEM_ROOT_PN, END_ITEM_SN FROM DSTS.B_V_DSTS_ASSEMBLY ORDER BY END_ITEM_ROOT_PN, END_ITEM_SN #END_ITEM_ROOT_PN# #END_ITEM_SN# Jim Ray Delta Program NT Administrator The Boeing Company (714) 896-2038 Email: [EMAIL PROTECTED] Website: http://deltaweb.lgb.cal.boeing.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF to Excel
The easiest way is to output an Excel readable text file, like a csv or tab delimited file. Cary At 02:01 PM 6/2/2000 -0700, you wrote: >How can I take the results of a Query and save it as an Excel file? > >This is what I though would work. > >Thanks all! > > > SELECT END_ITEM_ROOT_PN, END_ITEM_SN > FROM DSTS.B_V_DSTS_ASSEMBLY > ORDER BY END_ITEM_ROOT_PN, END_ITEM_SN > > > >#END_ITEM_ROOT_PN# #END_ITEM_SN# > >Jim Ray >Delta Program NT Administrator >The Boeing Company >(714) 896-2038 >Email: [EMAIL PROTECTED] >Website: http://deltaweb.lgb.cal.boeing.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF to Excel
How can I take the results of a Query and save it as an Excel file? This is what I though would work. Thanks all! SELECT END_ITEM_ROOT_PN, END_ITEM_SN FROM DSTS.B_V_DSTS_ASSEMBLY ORDER BY END_ITEM_ROOT_PN, END_ITEM_SN #END_ITEM_ROOT_PN# #END_ITEM_SN# Jim Ray Delta Program NT Administrator The Boeing Company (714) 896-2038 Email: [EMAIL PROTECTED] Website: http://deltaweb.lgb.cal.boeing.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.