如何将excel工作表转换成数据库的sqlite在android [英] How to convert excel sheet into database of sqlite in android

问题描述

我有excel表，我需要打几个查询。我已经成功地访问了excel表在我的项目，但现在我有麻烦在查询它，因为我需要编写代码抓取甚至一个小列。有什么办法，我可以转换我的excel表在sqlite数据库。因为它会简化我的工作。
Excel工作表太大，有29页。

I have excel sheet on which I need to hit few queries. I have successfully accessed excel sheet in my project but now I have trouble in hitting queries on it because I need to write code fetch even a small column. Is there any way by that I can convert my excel sheet in sqlite database. As it will simplify my work. Excel sheet is too big with 29 sheets in it. It is impossible to manually enter those values.

推荐答案

SQLite是一种关系数据库格式，excel是一个电子表格。

SQLite is a relational database format, excel is a spreadsheet. There is no direct relationship between the two for there to be a generic conversion tool.

你没有提到是否需要公式或格式化。但您可以使用此处提及的代码，如何阅读在Android程序中的excel表单。

You do not mention if you need the formulae or formatting. But you could use the code mentioned here, How to read excel sheets in android program.

然后由你决定如何构建sqlite数据库并保存你读取的值。

Then it is up to you how you structure your sqlite database and save the values you've read.

这篇关于如何将excel工作表转换成数据库的sqlite在android的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！