如何转换的Excel工作表到源码的机器人数据库 [英] How to convert excel sheet into database of sqlite in android

问题描述

我有excel表格，我需要打几个疑问上。我已经成功地访问Excel工作表在我的项目，但现在我在打的查询就可以了麻烦BCZ我需要写code取即使是小列。这有什么办法用，我可以把我的Excel工作表中的SQLite数据库。因为它会simplyfy我的工作。 Excel工作表太大，有29张在里面。这是不可能的手动输入这些值。

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

推荐答案

SQLite是一个关系型数据库格式，Excel是为preadsheet。还有就是两者之间没有直接的关系，为那里是一个通用的转换工具。

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.

你不提，如果你需要的公式或格式。但是，你可以使用这里提到的code，<一个href="http://stackoverflow.com/questions/7357355/how-to-read-excel-sheets-in-android-program/7357391#7357391">How阅读Excel表中的Andr​​oid程序。

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工作表到源码的机器人数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！