Android 操作excel功能实例代码

学习app对excel的读写控制
1.界面设计

<?xml version="1.0" encoding="utf-8"?><RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"xmlns:tools="http://schemas.android.com/tools"android:id="@+id/activity_main"android:layout_width="match_parent"android:layout_height="match_parent"android:paddingBottom="@dimen/activity_vertical_margin"android:paddingLeft="@dimen/activity_horizontal_margin"android:paddingRight="@dimen/activity_horizontal_margin"android:paddingTop="@dimen/activity_vertical_margin"tools:context="com.npmaster.myexcel.MainActivity"><LinearLayoutandroid:orientation="vertical"android:layout_width="match_parent"android:layout_height="match_parent"android:id="@+id/childlayout"android:layout_alignParentTop="true"android:layout_alignParentLeft="true"android:layout_alignParentStart="true"><TableLayoutandroid:layout_width="match_parent"android:layout_height="wrap_content"android:background="#ffcccccc"android:layout_margin="1dp"><！-- line1 --><TableRowandroid:layout_width="match_parent"android:layout_height="20dp"android:background="#ffcccccc"android:layout_margin="0.5dp"><TextViewandroid:layout_width="0.0dp"android:layout_height="wrap_content"android:layout_weight="1"android:text="工参数据导入"android:id="@+id/tvtip" /><TextViewandroid:text="默认路径"android:layout_width="0.0dp"android:layout_height="wrap_content"android:layout_weight="2"android:id="@+id/tvpath" /></TableRow><！----><TableRowandroid:layout_width="fill_parent"android:layout_height="wrap_content"android:background="#ffffcc99"android:layout_margin="0.5dp"><Buttonandroid:text="导入数据"android:layout_width="0.0dp"android:layout_height="match_parent"android:id="@+id/btImport"android:textSize="12dp"android:layout_weight="1"/><Buttonandroid:text="清理数据"android:layout_width="0.0dp"android:layout_height="match_parent"android:id="@+id/btClear"android:textSize="12dp"android:layout_weight="1"/></TableRow></TableLayout><android.support.v7.widget.RecyclerViewandroid:scrollbars="vertical"android:layout_width="match_parent"android:layout_height="wrap_content"android:divider="#ffff0000"android:dividerHeight="10dp"android:id="@+id/rcvEngineerParameters"/></LinearLayout></RelativeLayout>

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"xmlns:app="http://schemas.android.com/apk/res-auto"android:orientation="vertical"android:layout_width="match_parent"android:layout_height="wrap_content"><TableLayoutandroid:layout_width="match_parent"android:layout_height="wrap_content"android:background="#ffcccccc"android:layout_margin="0dp"><TableRowandroid:layout_width="fill_parent"android:layout_height="wrap_content"android:background="#ffffcc99"android:layout_margin="0.5dp"><TextViewandroid:text="Ci"android:layout_width="0.0dp"android:layout_height="match_parent"android:layout_weight="1"android:textSize="12dp"android:id="@+id/tvCid" /><TextViewandroid:text="CellName:"android:layout_width="0.0dp"android:layout_height="match_parent"android:layout_weight="1"android:textSize="12dp"android:id="@+id/tvCellName" /><TextViewandroid:text="Longtitude"android:layout_width="0.0dp"android:layout_height="match_parent"android:layout_weight="1"android:textSize="12dp"android:id="@+id/tvLongtitude" /><TextViewandroid:text="Attitude:"android:layout_width="0.0dp"android:layout_height="match_parent"android:layout_weight="1"android:textSize="12dp"android:id="@+id/tvAttitude" /><TextViewandroid:text="Azimuth:"android:layout_width="0.0dp"android:layout_height="match_parent"android:layout_weight="1"android:textSize="12dp"android:id="@+id/tvAzimuth" /></TableRow></TableLayout></LinearLayout>

2. 代码设计

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<EngineerCellInfo> cfgCelllist = null;public EngineerCellInfo defaultItem;private EngineerRecycleViewAdapter myRecycleViewAdapter;private RecyclerView recyclerView;Toast toast;Button btClear,btImport;@Overrideprotected 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）;//线式布局类似 listviewLinearLayoutManager 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{@Overridepublic 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<EngineerCellInfo>（）;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 <cfgCelllist.size（）;i++）{for （int j=0;j<5;j++）{Label labelCi= new Label（ j, i, cfgCelllist.get（i）.item[j]）;sheet.addCell（labelCi）;}}book.write（）;book.close（）;}}catch（Exception e）{e.printStackTrace（）;}}/* 创建工参默认文件，如果文件不存在则创建*/public void createEngineerFile（String cfgFileName）{File file = null;try {file = new File（cfgFileName）;if（file.exists（）） {WritableWorkbook book = Workbook.createWorkbook（file）;WritableSheet sheet = book.createSheet（"task", DEFAULT_SHEET）;for （int i = 0; i <cfgCelllist.size（）;i++）{for （int j=0;j<5;j++）{Label labelCi= new Label（ j, i, cfgCelllist.get（i）.item[j]）;sheet.addCell（labelCi）;}}book.write（）;book.close（）;}}catch（Exception e）{e.printStackTrace（）;}}/* read the cell file from engineer file */public int readExcel（String cfgFileName）{TextView tv = （TextView） findViewById（R.id.tvpath）;try{File file = new File（cfgFileName）;if （！file.exists（））{return IMPORT_FILE_NOT_EXISTS;}InputStream inputStream = new FileInputStream（file）;Workbook workbook = Workbook.getWorkbook（inputStream）;Sheet sheet = workbook.getSheet（0）;/* ignore the first row*/for （int i = 1; i < sheet.getRows（）;i++）{EngineerCellInfo engineerCellInfo = new EngineerCellInfo（）;for （int j = 0; j < 5;j++）{Cell cell = sheet.getCell（j,i）;engineerCellInfo.item[j] = cell.getContents（）;}cfgCelllist.add（engineerCellInfo）;//tv.setText（engineerCellInfo.toString（））;}workbook.close（）;}catch（Exception e）{Log.i（LOG_TAG,"file to find the file"）;return IMPORT_FILE_FAIL;}return IMPORT_FILE_SUCCESS;}public class EngineerCellInfo{public String item[]; //use array to storepublic EngineerCellInfo（）{item = new String[5];}public String toString（）{return item[0]+"-"+item[1]+"-"+item[2]+"-"+item[3]+"-"+item[4];}}}

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<EngineerRecycleViewAdapter.MyViewHolder>{private List<MainActivity.EngineerCellInfo> itemsData;private Context mContext;private LayoutInflater inflater;public EngineerRecycleViewAdapter（Context context, List<EngineerCellInfo> 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;}@Overridepublic 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]））;}@Overridepublic 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）;}}}

3. 使用的jxl 开发包和recyclerview

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"）

以上所示是小编给大家介绍的Android 操作excel功能实例代码，希望对大家有所帮助，如果大家有任何疑问欢迎给我留言，小编会及时回复大家的！