如何将Excel文件导入到H2数据库? [英] How to import a excel file to the h2 database?

问题描述

我有一个Excel工作表，数据存储在十列和大量行中. 我想在H2数据库中导入文件的内容. 这样做的程序是什么? 我可以整体导入excel文件，还是必须编写一些特定的代码来逐行处理内容?

I have an excel sheet with data stored in ten columns and a large number of rows. I would like to import the content of the file in an H2 database. what is the procedure for this? can I import the excel file as a whole or do I have to write some specific code to handle the content row by row ?

推荐答案

将文件导出为CSV，然后使用H2函数读取CSV文件.

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

H2文档对此进行了说明.

这篇关于如何将Excel文件导入到H2数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！