Hi, does anyone know why JExcel seems to be inconsistent in what data it gets out of the spreadsheet
it generally gets exactly what is displayed in the cells after excel formatting. for example if i type '1' in a cell and format it to numeric with 2 decimals places it shows as 1.00 and jExcel does get it out as 1.00 however, i have been testing various scenarios and noticed that it doesn't always get what is displayed. for example if i again place a '1' in a cell and format it to 'accounting: £ (English UK)' it displays as '£1.00' but jExcel gets it as just '1' also if I entered data into a cell as â24/10/2007â I then formatted that column as: âcustomâ and format dd/mm/yyyy hh:mm It is then displayed in excel as â24/10/2007 00:00â. Then when I run this through jxl it outputs it as â10/24/07 0:00â which of course is not how it is displayed. does anyone have any idea on how to get around this inconsistency with JExcel and actually get the data out exactly how it is displayed? thanks very much richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297917 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
