解决方案 »
- 产品简介:什么是“一键恢复 5.0
- 关于浏览器插件的开发
- 求助各位大神,蓝牙串口如何完整接收inputstream中的数据
- SurfaceView的双缓冲是什么意思?
- Android开发Socket通讯程序,Client用Java的Socket,服务器用Delphi的TServerSocket
- 安卓开发里,通知栏大小是怎么是实现的?
- 关于android fragment在手机上的使用
- 关于autoCompleteTextView显示不了
- 【转】汉语编程EZ就要在8月发布了,,你怎么看?
- android studio为什么会这样,是本身的bug吗?
- 现在北京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);
}
}
}你实例化这个类用下行么