Skip to Main Content

Java SE (Java Platform, Standard Edition)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

'Sheet1$' is not a valid name. Don't have sheet in excel workbook

843810Mar 20 2010
I am developing application for the taxation purpose . I have an excel workbook which is macro enabled , but there is not any worksheet . This is provided by Government of India for vat return etc . How can i write data in excel workbook without containing sheet name . I need urgent. Please help as soon as possible.

Download excel book to check : [excel workbook|http://www.eultimateinc.com/xls/PVAT-24.xls]

but it containing cells, workbook contains macro. Without macro unable to open workbook
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
 
public class NewClass {
 
    public static Connection getConnection() throws Exception {
        String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
        String url = "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=PVAT-24.xls;"
                + "DriverID=22;READONLY=false";
        String username = "";
        String password = "";
        Class.forName(driver); // load JDBC-ODBC driver
        return DriverManager.getConnection(url, username, password);
    }
 
    public static void main(String args[]) throws Exception {
        Connection conn = null;
        Statement stmt = null;
 
        conn = getConnection();
        stmt = conn.createStatement();
        String excelQuery = "insert into [Sheet1$] values('Abc inc.') ";
        stmt.executeUpdate(excelQuery);
        
        stmt.close();
        conn.close();
    }
}
i got an error_ .
Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Excel Driver] 'Sheet1$' is not a valid name.  Make sure that it does not include invalid characters or punctuation and that it is not too long.
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
        at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
        at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
        at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
        at NewClass.main(NewClass.java:35)
Java Result: 1
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2010
Added on Mar 20 2010
0 comments
2,501 views