Re: Specifying Excel Data Types in CFCONTENT?
Thanks for the info, now that the project is not hold anymore, I will do this. I've used the POIUtility long ago, I'll check it out again. so I can't develop for 9 strictly yet. As an alternative, try the POIUtility.cfc. Like cfspreadsheet it generates a true Excel file. IIRC it should work on MX7 too. If you prefer to stick with pseudo-excel files (ie html) there are a lot of old css tricks floating around. Do a search on mso-number-format or just play around with a local Excel file. Format the cells as desired and save the workbook as html to view the generated css. http://stackoverflow. com/question s/354476/html-to-excel-how-can-tell-excel-to-treat-columns-as-numbers ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346479 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Specifying Excel Data Types in CFCONTENT?
Thanks Azadi, I know there are some additional features for the recent versions. I am using CF9 on my Dev by still CF7 on Production, so I can't develop for 9 strictly yet. Thanks for your help no, there isn't. cfcontent basically just tells the browser which mime type the content being delivered is to help the browser figure out how to display it. if you are on a recent cf version, check out cfspreadsheet group of tags and related functions. Azadi On 28/06/2011 23:26 , Feras Nabulsi wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Specifying Excel Data Types in CFCONTENT?
so I can't develop for 9 strictly yet. As an alternative, try the POIUtility.cfc. Like cfspreadsheet it generates a true Excel file. IIRC it should work on MX7 too. If you prefer to stick with pseudo-excel files (ie html) there are a lot of old css tricks floating around. Do a search on mso-number-format or just play around with a local Excel file. Format the cells as desired and save the workbook as html to view the generated css. http://stackoverflow.com/questions/354476/html-to-excel-how-can-tell-excel-to-treat-columns-as-numbers ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Specifying Excel Data Types in CFCONTENT?
no, there isn't. cfcontent basically just tells the browser which mime type the content being delivered is to help the browser figure out how to display it. if you are on a recent cf version, check out cfspreadsheet group of tags and related functions. Azadi On 28/06/2011 23:26 , Feras Nabulsi wrote: Hello, I am using CFContent to create an excel spreadsheet. The type of data is different, some are currency and some are integers, ...etc. Each of these fields once put into Excel should be specified in order to properly format the spreadsheet. Is there a way to specify a data type for each column in Excel when created using CFContent? Thank you ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm