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

问题描述

我有excel表，我需要打几个查询。我已经在我的项目中成功访问了excel表，但是现在我遇到麻烦，因为我需要编写代码，甚至是一个小列。有什么办法，我可以转换我的excel表在sqlite数据库。因为这将简化我的工作。
Excel表格太大，其中有29页。不可能手动输入这些值。

解决方案

SQLite是一种关系数据库格式，excel是一个电子表格。两者之间没有直接关系，因为有一个通用的转换工具。

如果你需要公式或格式化，你不提。但是你可以使用这里提到的代码，如何阅读Android程序中的excel表。

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

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 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.

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.

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

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