EDB Lib | Excel File Management as Database

<dependency>
     <groupId>EDB_LIB</groupId>
     <artifactId>EDB_LIB</artifactId>
     <version>1.2.1</version>
     <scope>provided</scope>
</dependency>

Table table = EDB.getClassTable(FileName,Directory);

table.createTable();

• String getTableName() get Name of table
  
• String getDir() get Directory
  
• void createTable() CreateFile if not exist
  
• Boolean AddField(String Field) add field to file if not exist
• Boolean RemoveField(String Field) remove field from file if exist
• Boolean SetField(String Field, String NewField) rename field if exist
• Boolean AddRecord(String Field, String Record) add record to file if not exist
• Boolean SetRecord(int row, String Field, String Record) set in a specific row of field the record
• int getCurrentCol() get number of all columns in a file
• int getCurrentRows() get number of all rows in a file
• int getCol(String Field) get the column number of the field
• int getRow(String Record, String Field) get the row number of the record in a specific field
• String getRecord(int row, String Field) get RecordValue from specific row of field