All geek questions in one place

How to import excel file into h2 database?

I have an excel sheet with data stored in ten columns and lots of rows. I would like to import the contents of the file into the H2 database. What is the procedure for doing this? can i import the excel file as a whole or do i need to write some specific code to process the content line by line?

+4
source share
2 answers

Export the file to a CSV, and then use the H2 function to read the CSV file.

This is described in the H2 documentation.

+6
source

Most recently, I have released a library that does this for you. It checks the XLS and for each sheet will create a table as an H2 database.

it pushes the download to your browser, which is the Z. zip database.

You can find the tool here http://ete.straight.io

Hope this helps. Greetings

-one
source

Source: https://habr.com/ru/post/1393918/

More articles:


All Articles