Problems with jxl api(CSharpJExcel)

[bayan]

I have a problem with this excel api. I can open the workbook fine, open access a specific sheet fine, but when it comes to accessing a certain cell in the sheet.

Spreadsheets created with excel cannot be accessed while sheets created with Microsoft Works can be accessed fine. I thought it had something to do with not having an excel license, but i got one and still i get the same undefined error.

It has nothing to do with language compatibility because i could access the sheet by name with Arabic letters. The problems kicked in when I tried to read the cell. Could anyone help me? Help is much appreciated.

API home: JExcelApi

Ill post the code perhaps it helps.

//All classes are properly imported
 public GasWaterRecordsProcessor(File file){

        // Import workbook
       try{
        workbook = Workbook.getWorkbook(file);
       }catch(Exception e){
                javax.swing.JOptionPane.showMessageDialog(null,"Unable to open file");
       }
        

        // Get desired sheet for import

        Sheet sheet = workbook.getSheet("كشف");

        //Count the number of current records which exist in the chosen spreadsheet. Here is where the exception occurs
        int cnt = 0;
        try{
        while(!sheet.getCell(1, cnt).getContents().equals(null)){

            cnt ++;
        }}

        catch(Exception e){javax.swing.JOptionPane.showMessageDialog(null, "Your Microsoft Excel license is inactive \n" +
                        "Possible solutions: \n" +
                        "1. Activate your ms excel license \n"
                       +"2. Use microsoft works spreadsheet as your default spreadsheet program or openOffice.org(for language compatibility).\n" +
                       "\n If this is not the case then please make sure the spreadsheet is the Excel 97-2003 format. A free converter is available at the microsoft website."+
                       "If it is not then please convert it to the correct format.\n"+"If you still have this broblem please contact your vendor at: 71832630");}

Left out the rest of the class.

[bayan]

Problem found, but still unresolved. This is an Arabic spreadsheet with cell A starting at the right. This api does not recognise the right to left cell orientation