出口SQLite数据库文件转换成XML，然后到Excel US preadsheet [英] Export sqlite database file into XML and then into Excel spreadsheet

问题描述

我试图从过去12小时做这个任务，但仍然不是能够做到这一点。现在我有一个名为testDatabase.db到SD卡作为备份文件的SQLite数据库文件..现在我想打开数据库成S preadsheet格式，使最终用户可以访问数据库和该S preadsheet数据库还保存到自己的系统中，然后打印输出和其他用途。

I am trying to do this task from the past 12 hour, but still am not able to do this...Now I have an sqlite database file named "testDatabase.db" into the sd card as a backup file..Now I want to open the database into the spreadsheet format so that the end user can access the database and store this spreadsheet database into his system and then further for printout and for other purpose..

我研究了一些在上面写u可以先转换乌尔数据库文件转换成XML，然后导出该文​​件为Excel格式的教程。

I studied some of the tutorials in which It was written that u can firstly convert ur database file into XML and then export this file to excel format..

但我不能做我的导出文件DATABSE成XML格式...至于根据我的要求，我想按钮单击我的数据库文件应该被转换成XML格式，使最终用户可以使用它。

But am not able to do export my databse file into XML format...As according to my requirement I want on button click my database file should be converted into xml format so that the end user can use it.

谢谢..

推荐答案

据我所知，目前还没有点击的方式这样做的。您可以创建的.bat脚本的每个表导出为CSV或HTML表格（命令可以在这里），然后将它们导入到Excel中。
或者你可以下载喜欢SQLite数据库浏览器软件中打开你的.db文件，然后每个表导出为CSV文件。

As far as I know, there is no "one click way" of doing that. You can either create .bat script to export each table into a CSV or html table (commands can be found here), and then import them into excel.
Or you can download a software like sqlite database browser open your .db file and then export each table into a csv file.

这篇关于出口SQLite数据库文件转换成XML，然后到Excel US preadsheet的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！