android excel 筛选功能,Android 操作excel功能实例代码

学习app对excel的读写控制

1.界面设计

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

android: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">

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:background="#ffcccccc"

android:layout_margin="1dp">

android:layout_width="match_parent"

android:layout_height="20dp"

android:background="#ffcccccc"

android:layout_margin="0.5dp">

android:layout_width="0.0dp"

android:layout_height="wrap_content"

android:layout_weight="1"

android:text="工参数据导入"

android:id="@+id/tvtip" />

android:text="默认路径"

android:layout_width="0.0dp"

android:layout_height="wrap_content"

android:layout_weight="2"

android:id="@+id/tvpath" />

android:layout_width="fill_parent"

android:layout_height="wrap_content"

android:background="#ffffcc99"

android:layout_margin="0.5dp">

android:text="导入数据"

android:layout_width="0.0dp"

android:layout_height="match_parent"

android:id="@+id/btImport"

android:textSize="12dp"

android:layout_weight="1"/>

android:text="清理数据"

android:layout_width="0.0dp"

android:layout_height="match_parent"

android:id="@+id/btClear"

android:textSize="12dp"

android:layout_weight="1"/>

android:scrollbars="vertical"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:divider="#ffff0000"

android:dividerHeight="10dp"

android:id="@+id/rcvEngineerParameters"/>

xmlns:app="http://schemas.android.com/apk/res-auto"

android:orientation="vertical"

android:layout_width="match_parent"

android:layout_height="wrap_content">

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:background="#ffcccccc"

android:layout_margin="0dp">

android:layout_width="fill_parent"

android:layout_height="wrap_content"

android:background="#ffffcc99"

android:layout_margin="0.5dp">

android:text="Ci"

android:layout_width="0.0dp"

android:layout_height="match_parent"

android:layout_weight="1"

android:textSize="12dp"

android:id="@+id/tvCid" />

android:text="CellName:"

android:layout_width="0.0dp"

android:layout_height="match_parent"

android:layout_weight="1"

android:textSize="12dp"

android:id="@+id/tvCellName" />

android:text="Longtitude"

android:layout_width="0.0dp"

android:layout_height="match_parent"

android:layout_weight="1"

android:textSize="12dp"

android:id="@+id/tvLongtitude" />

android:text="Attitude:"

android:layout_width="0.0dp"

android:layout_height="match_parent"

android:layout_weight="1"

android:textSize="12dp"

android:id="@+id/tvAttitude" />

android:text="Azimuth:"

android:layout_width="0.0dp"

android:layout_height="match_parent"

android:layout_weight="1"

android:textSize="12dp"

android:id="@+id/tvAzimuth" />

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

{

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

{

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 store

public 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

{

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);

}

}

}

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功能实例代码，希望对大家有所帮助，如果大家有任何疑问欢迎给我留言，小编会及时回复大家的！