如何将sqlite数据值插入到android sdcard模拟器中生成的csv文件中 [英] how tio insert sqlite data values into a generated csv file in android sdcard emulator
本文介绍了如何将sqlite数据值插入到android sdcard模拟器中生成的csv文件中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
有没有更好的方法在csv或excel文件中存储数据,这不会取代以前的数据。当运行模拟器时,它会在新行写入新数据
如何将数据导入csv文件。
generateCsvFile( Example1.csv跨度>);
private static void generateCsvFile( String sFileName)
{
try
{
File root = Environment.getExternalStorageDirectory();
文件gpxfile = 新文件(root,sFileName);
FileWriter writer = new FileWriter(gpxfile);
abc = Guwahati;
writer.append( Emp_Name);
writer.append(' ,');
writer.append( 地址);
writer.append(' \ n');
writer.append( hussain);
writer.append(' ,');
writer.append( Delhi);
writer.append(' \ n');
// 生成您想要的任何数据
writer.flush();
writer.close();
}
catch (IOException e)
{
e.printStackTrace();
}
}
}
sqlite连接:
db.open();
db.insertContact(纬度,纬度,航向,时间1,imemnumber,speed1,dist,vehicle,start,end);
db.close()
解决方案
Hello Baluleo,
请使用下面提到的构造函数Filewriter
。
FileWriter(文件文件, boolean 追加)
在你的情况下这将是是
FileWriter writer = new FileWriter(gpxfile,true);
问候,
Is there a better way to store data in csv or excel file which will not replace previous data.i.e when when run emulator, it will write new data at new row
how to get data into the csv file.
generateCsvFile("Example1.csv");
private static void generateCsvFile(String sFileName)
{
try
{
File root = Environment.getExternalStorageDirectory();
File gpxfile = new File(root, sFileName);
FileWriter writer = new FileWriter(gpxfile);
abc="Guwahati";
writer.append("Emp_Name");
writer.append(',');
writer.append("Adress");
writer.append('\n');
writer.append("hussain");
writer.append(',');
writer.append("Delhi");
writer.append('\n');
//generate whatever data you want
writer.flush();
writer.close();
}
catch(IOException e)
{
e.printStackTrace();
}
}
}
sqlite connection:
db.open();
db.insertContact(latitude,latitude,heading,time1,imemnumber,speed1,dist,vehicle,start,end);
db.close()
解决方案
Hello Baluleo,
Please use below mentioned constructor forFilewriter
.
FileWriter(File file, boolean append)
In your case this will be
FileWriter writer = new FileWriter(gpxfile, true);
Regards,
这篇关于如何将sqlite数据值插入到android sdcard模拟器中生成的csv文件中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文