Platform independent Connection String for EXCEL in java

Question

Is there a PLATFORM INDEPENDENT connection string for EXCEL file in java. jdbc:odbc is platform dependent. Is there anything else ??

I sang aware that odbc was available on other platforms...could be wrong though.... — MadProgrammer
– MadProgrammer, Commented Dec 26, 2013 at 8:08

Pantelis Natsiavas · Accepted Answer · 2013-12-27 06:47:54Z

1

In this post you could see an example of using a connection string without the ODBC. I suppose this is what you are looking for...

Class.forName("com.hxtt.sql.excel.ExcelDriver").newInstance();  

String url = "jdbc:Excel:///E:/JavaWithExcel/Feedback.xlsx";  
String sql = "select * from [Sheet1]";  

Connection con = DriverManager.getConnection(url, "", "");  

Statement stmt = con.createStatement();  
System.out.println(con);  
System.out.println(stmt);  

stmt.close();  
con.close();

Anyway, you have to understand that the connection string is always specific to the underlying environment. It could depend on the operating system, on the file system or something else... I would just use different configuration files for each environment.

Hope I helped!

edited Dec 27, 2013 at 6:47

answered Dec 26, 2013 at 8:34

Pantelis Natsiavas

5,3875 gold badges24 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kevin Panko Over a year ago

Please include a brief description in your answer of what the link is telling us. Suppose the link were offline or changed, then we would have no idea what you are telling us.

Collectives™ on Stack Overflow

Platform independent Connection String for EXCEL in java

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related