This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

Inserting data in to Excel

Posted by Hemang on April 27, 2001 at 7:06 AM

Without doing create table if i try to insert data into pre-
existing Excel file with column names, it treats all records
as text/character type.

Is there any option or way out of this situation such that
data should be inserted in their respective data-types and
not as Text/character.