Android操作excel功能实例代码

<?xml version="1.0" encoding="utf-8"?>

  
    
    
    
      
      
    
      
      
        
        
      
    
    
  

<?xml version="1.0" encoding="utf-8"?>

  
    
      
      
      
      
      
    
  

package com.npmaster.myexcel;
import android.os.Environment;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.TextView;
import android.support.v7.widget.DefaultItemAnimator;
import android.support.v7.widget.LinearLayoutManager;
import android.support.v7.widget.OrientationHelper;
import android.support.v7.widget.RecyclerView;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import android.util.Log;
import android.widget.Toast;
import jxl.*;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import static android.support.v7.recyclerview.R.styleable.RecyclerView;
public class MainActivity extends AppCompatActivity {
  public static final int IMPORT_FILE_SUCCESS = 0;
  public static final int IMPORT_FILE_NOT_EXISTS= 1;
  public static final int IMPORT_FILE_FAIL = 2;
  private static final String LOG_TAG = "NPLOG";
  private String npmasterDir = "/npmaster/";
  private String filepName = "my.xls";
  private String absFullPath = "";
  private static final int DEFAULT_SHEET = 0;
  public List cfgCelllist = null;
  public EngineerCellInfo defaultItem;
  private EngineerRecycleViewAdapter myRecycleViewAdapter;
  private RecyclerView recyclerView;
  Toast toast;
  Button btClear,btImport;
  @Override
  protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    /* 生成默认的title */
    initData();
    absFullPath =Environment.getExternalStorageDirectory().toString()+npmasterDir;
    createFolder(absFullPath);
    createEngineerFile(absFullPath+filepName);
    generateTestData();
    TextView tv = (TextView) findViewById(R.id.tvpath);
    tv.setText(absFullPath+filepName);
    recyclerView = (RecyclerView)findViewById(R.id.rcvEngineerParameters);
    //线式布局类似 listview
    LinearLayoutManager layoutManager = new LinearLayoutManager(this);
    layoutManager.setOrientation(OrientationHelper.VERTICAL);
    recyclerView.setLayoutManager(layoutManager);
    myRecycleViewAdapter = new EngineerRecycleViewAdapter(MainActivity.this,cfgCelllist);
    recyclerView.setAdapter(myRecycleViewAdapter);
    recyclerView.setItemAnimator(new DefaultItemAnimator());
    btClear = (Button)findViewById(R.id.btClear);
    btImport = (Button)findViewById(R.id.btImport);
    btClear.setOnClickListener(new MyClickListener());
    btImport.setOnClickListener(new MyClickListener());
  }
  class MyClickListener implements View.OnClickListener
  {
    @Override
    public void onClick(View v)
    {
      switch(v.getId())
      {
        case R.id.btImport:
          int result =readExcel(absFullPath+filepName);
          toast = Toast.makeText(MainActivity.this,String.valueOf(result),Toast.LENGTH_SHORT);
          toast.show();
          myRecycleViewAdapter.notifyDataSetChanged();
          break;
        case R.id.btClear:
          toast = Toast.makeText(MainActivity.this,"clear",Toast.LENGTH_SHORT);
          toast.show();
          break;
        default:
          break;
      }
    }
  }
  public void initData()
  {
    cfgCelllist = new ArrayList();
    defaultItem = new EngineerCellInfo();
    defaultItem.item[0] = "Ci";
    defaultItem.item[1] = "Cellname";
    defaultItem.item[2] = "Longtitude";
    defaultItem.item[3] = "Attitude";
    defaultItem.item[4] = "Azimuth";
    cfgCelllist.add(defaultItem);
  }
  public void generateTestData()
  {
    EngineerCellInfo engineerCellInfo = new EngineerCellInfo();
    engineerCellInfo.item[0] = "134633";
    engineerCellInfo.item[1] = "xx小区";
    engineerCellInfo.item[2] = "103.89866";
    engineerCellInfo.item[3] = "30";
    engineerCellInfo.item[4] = "60";
    cfgCelllist.add(engineerCellInfo);
    writeToFile(absFullPath+filepName);
  }
  /* create folder if not exists*/
  public void createFolder(String strFolder)
  {
    File file = new File(strFolder);
    if (!file.exists())
    {
      if (file.mkdir())
      {
        return;
      }
    }
  }
  public void writeToFile(String cfgFileName)
  {
    File file = null;
    if (cfgCelllist.size()<=1)
    {
      return;
    }
    try {
      file = new File(cfgFileName);
      if(file.exists())
      {
        WritableWorkbook book = Workbook.createWorkbook(file);
        WritableSheet sheet = book.getSheet(DEFAULT_SHEET);
        for (int i = 1; i 

package com.npmaster.myexcel;
import android.content.Context;
import android.support.v7.widget.RecyclerView;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.TextView;
import com.npmaster.myexcel.MainActivity.EngineerCellInfo;
import java.util.List;
public class EngineerRecycleViewAdapter extends RecyclerView.Adapter
{
  private List itemsData;
  private Context mContext;
  private LayoutInflater inflater;
  public EngineerRecycleViewAdapter(Context context, List itemsData)
  {
    this.itemsData = itemsData;
    this.mContext=context;
    inflater=LayoutInflater.from(mContext);
  }
  public MyViewHolder onCreateViewHolder(ViewGroup parent, int viewType)
  {
    View view = inflater.inflate(R.layout.listitem, parent, false);
    MyViewHolder holder = new MyViewHolder(view);
    return holder;
  }
  @Override
  public void onBindViewHolder(final MyViewHolder holder, final int position)
  {
    holder.tvCId.setText(String.valueOf(itemsData.get(position).item[0]));
    holder.tvCellName.setText(String.valueOf(itemsData.get(position).item[1]));
    holder.tvlongtitude.setText(String.valueOf(itemsData.get(position).item[2]));
    holder.tvAttitude.setText(String.valueOf(itemsData.get(position).item[3]));
    holder.tvAzimuth.setText(String.valueOf(itemsData.get(position).item[4]));
  }
  @Override
  public int getItemCount()
  {
    return itemsData.size();
  }
  public static class MyViewHolder extends RecyclerView.ViewHolder
  {
    public TextView tvCId;
    public TextView tvCellName;
    public TextView tvlongtitude;
    public TextView tvAttitude;
    public TextView tvAzimuth;
    public MyViewHolder(View view)
    {
      super(view);
      tvCId = (TextView)view.findViewById(R.id.tvCid);
      tvCellName = (TextView)view.findViewById(R.id.tvCellName);
      tvlongtitude = (TextView)view.findViewById(R.id.tvLongtitude);
      tvAttitude = (TextView) view.findViewById(R.id.tvAttitude);
      tvAzimuth = (TextView) view.findViewById(R.id.tvAzimuth);
    }
  }
}

compile 'com.android.support:appcompat-v7:25.0.1'
compile 'com.android.support:recyclerview-v7:25.0.1'
testCompile 'junit:junit:4.12'
compile files('libs/jxl-2.6.jar')