Fillo is an Excel API for Java and you can query xls & xlsx files
It supports DDL,DML AND DCL COMMANDS
public class Filo_Update
{
public static void main(String[] args) throws InterruptedException
{
Fillo fillo=new Fillo();
Connection connection=fillo.getConnection("C:\\Ramesh\\TestData.xlsx");
String strQuery="Update Sheet1 Set Course='selenium' where name='Ramesh'";
connection.executeUpdate(strQuery);
connection.close();
}
}
It supports DDL,DML AND DCL COMMANDS
public class Filo_Update
{
public static void main(String[] args) throws InterruptedException
{
Fillo fillo=new Fillo();
Connection connection=fillo.getConnection("C:\\Ramesh\\TestData.xlsx");
String strQuery="Update Sheet1 Set Course='selenium' where name='Ramesh'";
connection.executeUpdate(strQuery);
connection.close();
}
}
No comments:
Post a Comment