/**
* Copyright 2015 Nabarun Mondal
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
*/
package com.noga.njexl.testing.dataprovider.excel;
import jxl.Workbook;
import java.io.File;
/**
* Implementation of {ExcelReader} for .xls files
*/
public class XlsReader implements ExcelReader {
private Workbook workBook;
/**
* Creates an instance of the ExcelReaderXLS - sheet is pointing to sheetNum
*
* @param fileName the excel xsl file to read from
*
*/
public XlsReader(String fileName){
try {
workBook = Workbook.getWorkbook(new File(fileName));
} catch (Exception e) {
throw new Error(e);
}
}
@Override
public String[] sheets() {
return workBook.getSheetNames();
}
@Override
public String value(String sheet, int row, int column) {
return workBook.getSheet(sheet).getCell(column, row).getContents();
}
@Override
public int rowCount(String sheet) {
return workBook.getSheet(sheet).getRows();
}
@Override
public int columnCount(String sheet) {
return workBook.getSheet(sheet).getColumns();
}
}