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