I am currently using the code below to read in an uploaded excel file.
<cfset objWorkBook =
CreateObject("java","org.apache.poi.hssf.usermodel.HSSFWorkbook").Init(
<!--- Create the file input stream. --->
CreateObject("java","java.io.FileInputStream").Init(
<!--- Create the file object. --->
CreateObject("java","java.io.File").Init(
"#trim(SrcDirectory.SrcF_Directory)#\#UploadedFilename#"
)
)
) />
Everything works good except that it is reading date values (7/7/1996)
as a numeric values and outputting some weird long number. How can I get
it to produce 7/71996 in the output instead of a numeric value.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323570
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
