本文实例为大家分享了Android向Excel写入数据导出并发送邮件的具体代码，供大家参考，具体内容如下
创建Execl、写入Excel格式
代码语言：javascript复制public WriteExcel(Context mContext){
this.mContext = mContext;
}
// 创建excel表
public void createExcel(File file) {
deleteExcel(file);
WritableSheet ws = null;
try {
if (!file.exists()) {
wwb = Workbook.createWorkbook(file);//创建表
ws = wwb.createSheet("sheet1", 0);//表名 页数
// 在指定单元格插入数据
Label lbl1 = new Label(0, 0, "标签1");
Label lbl2 = new Label(1, 0, "标签2");
Label lbl3 = new Label(2, 0, "标签3");
Label lbl4 = new Label(3, 0, "标签4");
ws.addCell(lbl1);
ws.addCell(lbl2);
ws.addCell(lbl3);
ws.addCell(lbl4);
// 从内存中写入文件中
wwb.write();
wwb.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**向Execl写入数据
* @Param ls List<map 数据
* @Param emeailPath
* @Param file
*/
public void writeToExcel(List<Map<String,Object ls,String emeailPath,File file) {
try {
Workbook oldWwb = Workbook.getWorkbook(file);
wwb = Workbook.createWorkbook(file, oldWwb);
WritableSheet ws = wwb.getSheet(0);
// 当前行数
for (int i = 0; i < ls.size(); i ) {
int row = ws.getRows();
Label lab1 = new Label(0, row, ls.get(i).get("数据1") "");
Label lab2 = new Label(1, row, ls.get(i).get("数据2") "");
Label lab3 = new Label(2, row, ls.get(i).get("数据3") "");
Label lab4 = new Label(3, row, ls.get(i).get("数据4") "");
ws.addCell(lab1);
ws.addCell(lab2);
ws.addCell(lab3);
ws.addCell(lab4);
}
// 从内存中写入文件中,只能刷一次
wwb.write();
wwb.close();
if (emeailPath != null) {
postEmail(emeailPath);
}else{
final ProgressDialog precentDialog=new ProgressDialog(mContext);
precentDialog.setMessage("导出U盘中...");
precentDialog.setMax(100);
precentDialog.setCanceledOnTouchOutside(false);
precentDialog.show();
new Thread(){
public void run() {
//等待进度条
for (int i = 0; i < 100; i ) {
try {
long l= (long) (Math.random()*200);
Thread.sleep(l);
} catch (InterruptedException e) {
e.printStackTrace();
}
precentDialog.setProgress(i);
}
precentDialog.dismiss();
handler.sendEmptyMessage(1);
};
}.start();
}
}catch(Exception e){
e.printStackTrace();
}
}
@SuppressLint("HandlerLeak")
private Handler handler = new android.os.Handler() {
@Override
public void handleMessage(Message msg) {
// TODO Auto-generated method stub
super.handleMessage(msg);
Toast.makeText(mContext,"导入U盘完成！",Toast.LENGTH_SHORT).show();
}
};
//删除文件夹
private void deleteExcel(File file){
if(file.exists()){
file.delete();
}
}检测U盘、制作Excel表格
代码语言：javascript复制private void postEmail(String emailPath){
SimpleDateFormat fmat=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String time=fmat.format(new Date(System.currentTimeMillis()));
String path=getExcelDir() File.separator "IdCardInfo.xls";
File file = new File(path);
if(file.exists()){
Intent email = new Intent(android.content.Intent.ACTION_SEND);
email.setType("application/octet-stream");
//邮件接收者（数组，可以是多位接收者）
String[] emailReciver = new String[]{emailPath};
String emailTitle = "信息_" time;
String emailContent = "核验信息";
//设置邮件地址
email.putExtra(android.content.Intent.EXTRA_EMAIL, emailReciver);
//设置邮件标题
email.putExtra(android.content.Intent.EXTRA_SUBJECT, emailTitle);
//设置发送的内容
email.putExtra(android.content.Intent.EXTRA_TEXT, emailContent);
//附件
email.putExtra(Intent.EXTRA_STREAM, Uri.fromFile(file));
//调用系统的邮件系统
mContext.startActivity(Intent.createChooser(email, "请选择邮件发送软件"));
}
}以上就是本文的全部内容，希望对大家的学习有所帮助。
