Thx For your reply Sylvain :-).
Yes it's a version problem, now it works well after using jopendocument 1.2.
Regards!
On Friday, May 4, 2012 12:40:31 PM UTC+1, gammoudi neji wrote:
>
> Hello,
> I have a method which read all records from an input .ods file, It works
> well especially for multi-line cell.
> For multi-line cell i get only the first line and not all the content.
> This is my code:
> sheet = SpreadSheet.createFromFile(file).getSheet(2);
>
> //Iterating through each row of the selected sheet
> MutableCell cell = null;
>
> for(int nRowIndex = 5; nRowIndex < 20; nRowIndex++)
> {
> //Iterating through each column
>
> for( int nColIndex = 0;nColIndex < 11; nColIndex++)
> {
> cell = sheet.getCellAt(nColIndex, nRowIndex);
>
> // cell.setValue(obj)
>
> excelData[nRowIndex][nColIndex]=cell.getValue().toString();
>
> excelData[5][10]=component;
>
> System.out.println("aaaaaaaaa"+cell.getValue().toString());
>
> }
>
> }
>
>
> How can do with multiples line? someone has an idea please?
>
>
