common.AssertionFailed Exception

560 views
Skip to first unread message

Unknown

unread,
Oct 11, 2010, 5:37:14 AM10/11/10
to jexcel...@teamdev.com
Hello i get the following problem in my code:
{code}
public SheetManager(String filename) {
try {
String[] sheetList;
String sheetName;
workbook=Workbook.getWorkbook(new File(filename));
sheetList=workbook.getSheetNames();
for(int i=0;i sheetName=sheetList+;
System.out.println(sheetName);
}
sheet=workbook.getSheet("SeguimientoMinor");///////***At this point throws the exception
} catch (BiffException ex) {
ex.printStackTrace();
} catch (IOException ex) {
ex.printStackTrace();
}

}
{code}
Output:

{code}
common.AssertionFailed
at common.Assert.verify(Assert.java:37)
at jxl.read.biff.WorkbookParser.getName(WorkbookParser.java:1118)
at jxl.biff.formula.NameRange.read(NameRange.java:88)
at jxl.biff.formula.TokenFormulaParser.parseSubExpression(TokenFormulaParser.java:214)
at jxl.biff.formula.TokenFormulaParser.parse(TokenFormulaParser.java:111)
at jxl.biff.formula.FormulaParser.parse(FormulaParser.java:110)
at jxl.biff.DVParser.(DVParser.java:431)
at jxl.biff.DataValiditySettingsRecord.initialize(DataValiditySettingsRecord.java:140)
at jxl.biff.DataValiditySettingsRecord.getFirstColumn(DataValiditySettingsRecord.java:234)
at jxl.read.biff.SheetReader.read(SheetReader.java:1010)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:686)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:252)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:285)
at jexcelexample.SheetManager.(SheetManager.java:42)
at jexcelexample.Main.main(Main.java:40){code}
{code}

{code}

Te code which calls this class is:

{code}
public static void main(String[] args) {

SheetManager manager=new SheetManager("Minor.xls");
{code}

My compiler is JVM 1.5
Excel version 2003.

Thanks in advance.


Unknown

unread,
Oct 11, 2010, 5:37:21 AM10/11/10
to jexcel...@teamdev.com

I get in the console the previous message

Warning: Cannot read name


Unknown

unread,
Oct 11, 2010, 5:37:23 AM10/11/10
to jexcel...@teamdev.com

Hi,

As shown in stacktrace, you try using opensource JExcelApi product but not our JExcel. To resolve the issue you need subscribing to the JExcelApi Mailing Group and contacting with JExcelApi community. Subscribe form you can find at the bottom of following page:

http://jexcelapi.sourceforge.net/

Sincerely,

Igor Novikov


Unknown

unread,
Oct 11, 2010, 5:37:19 AM10/11/10
to jexcel...@teamdev.com
X-MIME-Autoconverted: from quoted-printable to 8bit by htk.kharkov.ua id o97Dc4eG024260

Hello again,I noticed that this Exception is thrown just when i try to get a specific sheet(workbook.getSheet(0)),so I suppose that JExcel has some trouble opening some specific sheets with defined names,list,macros.... I don´t know.

If somebody knows about problems opening sheets I thank his/her opinion.....


Reply all
Reply to author
Forward
0 new messages