OpenOffice ships with HSQLDB. Is it possible to easily import the contents of an OO spreadsheet into the built in database? An added nice to have would be to include the formatting of the cell contents. ie. colors, line feeds, etc.
This question has gone unanswered so I'm offering a bounty. Please provide the code to the solution.
The provided link does work, and no coding is required. To summarize:
- Create and register an Open Office DB.
1.1 Looks like you can register any DB for which you have a JDBC driver. (ie. MySql,Postgres) - Create column headings in row 1.
- Select data and copy it to the clipboard.
3.1 Limited selection to only the desired rows because OO crashed when I selected all rows. - Go to the Table (Tables pane) view of the database.
- Right-click and paste your data.
- Follow the instructions provided my the wizard that opens.