Hi Aspose Team,

I am trying to access each for a worksheet but found that refernce to some column cells is not accessible( eg Column 7). I have attached the xls sheet used to test 7 below is the code snipppet.

Workbook workbook = new Workbook();

workbook.open("C:\\temp\\MOORE\\TEST_TEMPLATE.xls",FileFormatType.DEFAULT);

int endRow = 5;//templateSheet.getCells().getMaxDataRow();

System.out.println("Max Rows "+endRow);

for(Iterator it = cells.getRowIterator(); it.hasNext(); )

if(sourceRow.getRowIndex() > endRow){

break;

for(Iterator cellIt = sourceRow.getCellIterator(); cellIt.hasNext();)

System.out.println("Column Index "+sourceCell.getColumnIndex());

Thanks,

rohitob

Hi rohitob,

RowIterator  is used to visit all rows (which are inited).

CellIterator is used to visit all cells (which are inited) in the row.

If the row or cell is not inited , the iterator will not visit it.So  I think that the cell in the column 7 is inited.

If the cell in the column 7 is inited and CellIterator do not return the cell, you can zip your template file ,then attach the zip.We will try to fix it.

Hi Warren,

Please find attached the template file having access issue while iterating over rows/cells.

Apart from the issues I have reported so far ( thxs to Aspose Team were resolved as well) , I have a couple of xls files which are currently not parsed by Aspose cell as received from clients directly. But when I try to open the xls file in Excel client, save & then try to parse with Aspose cell it works fine.Due to sensitivity of client data I cannot publish the file on these forums.

Is there any debug/log option availble when I run the Aspose cells which I can genereate & send you to investigate instead of sending these sensitive files?

Thanks,

rohitob

Hi rohitob,

In your template file , I can get the cell in column 7.Something notes again, CellIterator only returns the cell which is defined.

I add Cells.checkRow() to check the row is defined. If the method returns null, you can not access this row in the RowIterator.

I add Cells.checkCell() to check the cell is defined.If the method returns null, you can not access this cell in the CellIterator.

Please try this fix.

Thxs will try..

Any response to my query on debug/log option mentioned above?

Hi,

The attached file is only visible for Aspose Member. And you can create private post which is only visible for you and Aspose Member.

Now we do not support the debug/log option. If you find any error, we will fix it quickly with your info.