Hi Dave I am going to create a single XLS file from set of (Series of ) excel data files. But for the the file which i wanted generate , must be having a column with different CELL formating which must be Number and 2 decimal places.Other data fileds always default (General). But I could not understand what I can extract from your reply . Can you please help me?
Thanks Luke ________________________________ From: David Fisher <[email protected]> To: POI Users List <[email protected]> Sent: Tuesday, June 15, 2010 21:45:42 Subject: Re: Cell Formatting > Hi > > I wanted to assign Cell formatting for a particular field which is supposed > to handle numeric values. > > For example : > > In the column D , I have a filed called Total. This entire column i wanted > format as "Number" with 2 decimal places. > > Can some body help me on this with an example? Try looking here: http://poi.apache.org/spreadsheet/quick-guide.html#DataFormats Regards, Dave > > Thanks in advance. > Luke > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
