during opening an excel file with java i have this error: Warning: Usage of a local non-builtin name

java excel jxl
user618111 picture user618111 · Feb 26, 2011 · Viewed 7.2k times · Source

when i try to open an excel file i have this error message. Warning: Usage of a local non-builtin name

My excel file file contains more than 1600 rows if i try the same code and open a small excel file, it's working.

Why please?

I use JXL thank you

Answer

Karthick picture Karthick · Dec 26, 2013

WorkbookSettings wbSettings = new WorkbookSettings(); wbSettings.setSuppressWarnings(true);

Related questions

What is the better API to Reading Excel sheets in java - JXL or Apache POI

Which of the 2 APIs is simpler to read/write/edit excel sheets ? Do these APIs not support CSV extensions ? Using JXL for file.xls and file.xlsx, I get an exception like: jxl.read.biff.BiffException: Unable to recognize OLE …

Read More
Microsoft Excel Macro to run Java program

I have learnt to read and write an Excel file using a Java program with the help of Jxl and POI API. Is it possible to run a Java program with the help of macros?

Read More
JXL Number Format and Cell Type

I am using JXL to write an Excel file. The customer wants a certain column to display numbers with one decimal place. They also want the cell types to be "Number". When I use the following (test) code, the numbers …

Read More