Android 怎么将sqlite中数据 导出成excel 放在sd 卡 androidsqliteexcel导出POI 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 帮你顶一下,建议写成豆号分隔符存为CVR文件,就可以用EXCEL表格打开了。 首先把数据取出,其次自己用java生成一个excel 把数据写进去,这样比较灵活 从数据库里生成纯文本文件很简单,文本用GBK码制,这列与列之间用 0x9即TAB分隔,行与行用\n,文件类型用.XLS,就是最简单的电子表格格式了。 我用C++做导出XLS功能就是这么做的,很简单。 public void datatrans_DataOut() throws IOException {// export data String sql = " select * from " + TaskfieldEntry.TNAME; String[] selectionArgs = null; TaskfieldDAO taskfieldDAO = new TaskfieldDAO(DataTransActivity.this); List<TaskfieldBean> taskBeanlist = taskfieldDAO.queryBySQL(sql, selectionArgs); File fileNameFile = getExportFile(); if (fileNameFile != null) { FileOutputStream f = new FileOutputStream(fileNameFile); // 新建工作薄 HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet workSheet = workbook .createSheet(TaskfieldEntry.CNAME_V_MEMO); // 生成表头 HSSFRow fieldRow = workSheet.createRow(0); fieldRow.createCell(0).setCellValue( /* TaskfieldEntry.CNAME_V_FID */"任务编号"); fieldRow.createCell(1).setCellValue( /* TaskfieldEntry.CNAME_V_MEMO */"任务标题"); // 表内容 for (int i = 0; i < taskBeanlist.size(); i++) { TaskfieldBean t = taskBeanlist.get(i); HSSFRow row = workSheet.createRow(i + 1); row.createCell(0).setCellValue(t.getF_id()); row.createCell(1).setCellValue(t.getMemo()); } workbook.write(f); f.close(); Toast.makeText(this, "提示:导出成功!", Toast.LENGTH_SHORT).show(); } else { Toast.makeText(this, "export failed,create file failed in sdcard", Toast.LENGTH_SHORT).show(); } } 导出CSV,引用C#行吗?我这有一个帮助类,直接传入参数就行,我是在C#里用一个SaveFlieDialog获得路径,然后将表和路径传入,调用类中的方法如下:using System;using System.Collections.Generic;using System.IO;using System.Text;using System.Data;namespace Utility{ public class CSVHelper { //导出为svc文件,strFileName为要导出的csv格式文件的路径和文件名:比如,"d:\test\test.csv" public void ExportToSvc(System.Data.DataTable dt, string strFileName) { string strPath = strFileName; if (File.Exists(strPath)) { File.Delete(strPath); } //先打印标头 StringBuilder strColu = new StringBuilder(); StringBuilder strValue = new StringBuilder(); int i = 0; try { StreamWriter sw = new StreamWriter(new FileStream(strPath, FileMode.CreateNew), Encoding.GetEncoding("GB2312")); for (i = 0; i <= dt.Columns.Count - 1; i++) { strColu.Append(dt.Columns[i].ColumnName); strColu.Append(","); } strColu.Remove(strColu.Length - 1, 1);//移出掉最后一个,字符 sw.WriteLine(strColu); foreach (DataRow dr in dt.Rows) { strValue.Remove(0, strValue.Length);//移出 for (i = 0; i <= dt.Columns.Count - 1; i++) { strValue.Append(dr[i].ToString()); strValue.Append(","); } strValue.Remove(strValue.Length - 1, 1);//移出掉最后一个,字符 sw.WriteLine(strValue); } sw.Close(); } catch (Exception ex) { throw ex; } System.Diagnostics.Process.Start(strPath); } }}你实例化这个类用下行么 【讨论】通过bindService启动的service,在unbindService后service也结束了 玩过Android完美钢琴或其他乐曲的进来帮忙看看~~ 是因为xml文件没编译吗? 一个超简单的新手问题 动态创建的按钮怎么设置监听? 怎么更换模拟器里的rom? 请教高手一个超郁闷难题!!!!!! 如何显示大文本啊 如何可以滑动切换+点击切换页面 频域数据怎么计算频率(HZ)? 现在北京Android(应用)开发什么行情? apk中想要附带些视频资源(几十M),请问如何实现?
这列与列之间用 0x9即TAB分隔,行与行用\n,
文件类型用.XLS,就是最简单的电子表格格式了。
String sql = " select * from " + TaskfieldEntry.TNAME;
String[] selectionArgs = null;
TaskfieldDAO taskfieldDAO = new TaskfieldDAO(DataTransActivity.this);
List<TaskfieldBean> taskBeanlist = taskfieldDAO.queryBySQL(sql,
selectionArgs);
File fileNameFile = getExportFile();
if (fileNameFile != null) {
FileOutputStream f = new FileOutputStream(fileNameFile);
// 新建工作薄
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet workSheet = workbook
.createSheet(TaskfieldEntry.CNAME_V_MEMO);
// 生成表头
HSSFRow fieldRow = workSheet.createRow(0);
fieldRow.createCell(0).setCellValue(
/* TaskfieldEntry.CNAME_V_FID */"任务编号");
fieldRow.createCell(1).setCellValue(
/* TaskfieldEntry.CNAME_V_MEMO */"任务标题");
// 表内容
for (int i = 0; i < taskBeanlist.size(); i++) {
TaskfieldBean t = taskBeanlist.get(i);
HSSFRow row = workSheet.createRow(i + 1);
row.createCell(0).setCellValue(t.getF_id());
row.createCell(1).setCellValue(t.getMemo());
}
workbook.write(f);
f.close();
Toast.makeText(this, "提示:导出成功!", Toast.LENGTH_SHORT).show();
} else {
Toast.makeText(this, "export failed,create file failed in sdcard",
Toast.LENGTH_SHORT).show();
} }
using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using System.Data;namespace Utility
{
public class CSVHelper
{
//导出为svc文件,strFileName为要导出的csv格式文件的路径和文件名:比如,"d:\test\test.csv"
public void ExportToSvc(System.Data.DataTable dt, string strFileName)
{
string strPath = strFileName;
if (File.Exists(strPath))
{
File.Delete(strPath);
}
//先打印标头
StringBuilder strColu = new StringBuilder();
StringBuilder strValue = new StringBuilder();
int i = 0;
try
{
StreamWriter sw = new StreamWriter(new FileStream(strPath, FileMode.CreateNew), Encoding.GetEncoding("GB2312")); for (i = 0; i <= dt.Columns.Count - 1; i++)
{
strColu.Append(dt.Columns[i].ColumnName);
strColu.Append(",");
}
strColu.Remove(strColu.Length - 1, 1);//移出掉最后一个,字符 sw.WriteLine(strColu); foreach (DataRow dr in dt.Rows)
{
strValue.Remove(0, strValue.Length);//移出 for (i = 0; i <= dt.Columns.Count - 1; i++)
{
strValue.Append(dr[i].ToString());
strValue.Append(",");
}
strValue.Remove(strValue.Length - 1, 1);//移出掉最后一个,字符
sw.WriteLine(strValue);
} sw.Close();
}
catch (Exception ex)
{
throw ex;
}
System.Diagnostics.Process.Start(strPath);
}
}
}你实例化这个类用下行么