表格类似Excel

只是很简单的实现表格，使用GridView控件——>可以上下左右滚动，但是不能合并


直接上代码：
1、主要布局
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
  3.     android:layout_width="match_parent"
  4.     android:layout_height="match_parent"
  5.     android:orientation="vertical">
  6.     
  7.     <TextView 
  8.         android:id="@+id/textview"
  9.         android:layout_width="match_parent"
  10.         android:layout_height="wrap_content"
  11.         android:text="测试表格"/>
  12.     
  13.     <HorizontalScrollView 
  14.         android:layout_width="match_parent" 
  15.         android:layout_height="wrap_content"> 
  16.         <LinearLayout 
  17.             android:layout_width="match_parent" 
  18.             android:layout_height="wrap_content" 
  19.             android:orientation="vertical" > 
  20.             <GridView 
  21.                 android:id="@+id/table_grid"
  22.                 android:layout_width="match_parent"
  23.                 android:layout_height="match_parent"
  24.                 android:horizontalSpacing="1dp"
  25.                 android:verticalSpacing="1dp"
  26.                 android:numColumns="12">
  27.             </GridView> 
  28.         </LinearLayout> 
  29.     </HorizontalScrollView>
  31. </LinearLayout>
2、表格中一个item的布局
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
  3.     android:layout_width="80dp"
  4.     android:layout_height="match_parent"
  5.     android:orientation="vertical">
  6.     
  7.     <TextView 
  8.         android:id="@+id/text_item"
  9.         android:layout_width="wrap_content"
  10.         android:layout_height="wrap_content"
  11.         android:gravity="center"
  12.         android:layout_gravity="center"
  13.         android:textSize="15dp"
  14.         android:textColor="#000000"></TextView>
  15.     
  17. </LinearLayout>

3、Adapter代码
  1. package com.example.achartenginetest.adapter;
  3. import java.util.ArrayList;
  4. import java.util.List;
  6. import android.content.Context;
  7. import android.graphics.Color;
  8. import android.view.LayoutInflater;
  9. import android.view.View;
  10. import android.view.ViewGroup;
  11. import android.widget.BaseAdapter;
  12. import android.widget.TextView;
  14. import com.example.achartenginetest.R;
  16. public class TableAdapter extends BaseAdapter {
  17.     private final static int NUM_COLUMN = 12;
  18.     
  19.     private LayoutInflater mInflater;
  20.     private List<double[]> mOriginalData;
  21.     private List<String> mData;
  22.     private Context mContext;
  23.     
  24.     public TableAdapter(Context context,List<double[]> mData){
  25.         this.mInflater = LayoutInflater.from(context);
  26.         this.mOriginalData = mData;
  27.         this.mContext = context;
  28.         
  29.                 
  30.         
  31.         toAllData();
  32.         
  33.     }
  34.     
  35.     private void toAllData(){
  36.         mData = new ArrayList<String>();
  37.         String[] tableTitle= new String[]{"日期","早餐前","早餐后1小时","早餐后2小时",
  38.                 "午餐前","午餐后1小时","午餐后2小时",
  39.                 "晚餐前","晚餐后1小时","晚餐后2小时",
  40.                 "睡前","凌晨2点"};
  41.         
  42.         for(int i = 0; i<tableTitle.length;++i){
  43.             mData.add(tableTitle[i]);
  44.         }
  45.         
  46.         
  47.         for(int i = 0; i<mOriginalData.size();++i){
  48.             double[] fixedData = fixData(mOriginalData.get(i));
  49.             mData.add(""+i);
  50.             
  51.             for(int j = 0; j<fixedData.length; ++j){
  52.                 mData.add(""+fixedData[j]);
  53.             }
  54.         }
  55.     }
  56.     
  57.     
  58.     /**
  59.      * 检查数据长度是否为11个取值点
  60.      * @param data
  61.      * @return 0：11个取值点，1：大于11个取值点，-1：小于11个取值点
  62.      */
  63.     private int checkData(double[] data){        
  64.         return data.length == NUM_COLUMN-1?0:(data.length<NUM_COLUMN-1?-1:1);
  65.     }
  66.     
  67.     
  68.     /**
  69.      * 对数据进行修正，保证数据长度的正确性
  70.      * @param data
  71.      * @return
  72.      */
  73.     private double[] fixData(double[] data){
  74.         int checkResult = checkData(data);
  75.         if(checkResult == 0){
  76.             return data;
  77.         }else{
  78.             double[] result = new double[NUM_COLUMN-1];
  79.             
  80.             if(checkResult == -1){                
  81.                 for(int i =0; i<data.length;++i){
  82.                     result[i]=data[i];
  83.                 }
  84.                 
  85.                 for(int i = data.length; i<NUM_COLUMN-1; ++i){
  86.                     result[i] = 0;
  87.                 }
  88.                 
  89.             }else{                
  90.                 for(int i =0; i<NUM_COLUMN-1;++i){
  91.                     result[i]=data[i];
  92.                 }
  93.             }
  94.             
  95.             return result;
  96.         }        
  97.     }
  98.     
  99.     public int getDataCount() {
  100.         return mOriginalData.size();
  101.     }
  103.     @Override
  104.     public int getCount() {
  105.         return mData.size();
  106.     }
  108.     @Override
  109.     public Object getItem(int position) {
  110.         return mData.get(position);
  111.     }
  113.     @Override
  114.     public long getItemId(int position) {
  115.         return position;
  116.     }
  118.     @Override
  119.     public View getView(int position, View convertView, ViewGroup parent) {
  120.         ViewHolder holder = null;
  121.         if (convertView == null) {           
  122.             holder = new ViewHolder(); 
  123.  
  124.             convertView = mInflater.inflate(R.layout.table_item, null);
  125.             holder.vText = (TextView)convertView.findViewById(R.id.text_item);
  126.             
  127.             convertView.setTag(holder);
  128.         }else {
  129.             holder = (ViewHolder)convertView.getTag();
  130.  
  131.         }
  132.  
  133.         holder.vText.setText(mData.get(position));
  134.         
  135.         if(position % NUM_COLUMN == 0){
  136.             convertView.setBackgroundColor(Color.WHITE);
  137.         }else if(position % NUM_COLUMN == 1 || position % NUM_COLUMN == 2 || position % NUM_COLUMN == 3){
  138.             convertView.setBackgroundColor(Color.YELLOW);
  139.         }else if(position % NUM_COLUMN == 4 || position % NUM_COLUMN == 5 || position % NUM_COLUMN == 6){
  140.             convertView.setBackgroundColor(Color.GREEN);
  141.         }else if(position % NUM_COLUMN == 7 || position % NUM_COLUMN == 8 || position % NUM_COLUMN == 9){
  142.             convertView.setBackgroundColor(Color.BLUE);
  143.         }else if(position % NUM_COLUMN == 10){
  144.             convertView.setBackgroundColor(Color.rgb(97,76,32));
  145.         }else if(position % NUM_COLUMN == 11){
  146.             convertView.setBackgroundColor(Color.GRAY);
  147.         }
  148.  
  149.  
  150.         return convertView;
  151.     }
  152.     
  153.     
  154.     private class ViewHolder{
  155.         public TextView vText = null;
  156.     }
  158. }
4、Activity代码
  1. package com.example.achartenginetest.charts;
  3. import java.util.ArrayList;
  4. import java.util.List;
  6. import android.app.Activity;
  7. import android.os.Bundle;
  8. import android.util.DisplayMetrics;
  9. import android.widget.GridView;
  10. import android.widget.LinearLayout;
  12. import com.example.achartenginetest.R;
  13. import com.example.achartenginetest.adapter.TableAdapter;
  15. public class TableChart extends Activity{
  16.     private GridView mGridTable;
  17.     private TableAdapter mAdapter;
  18.     
  19.     @Override
  20.     protected void onCreate(Bundle savedInstanceState) {
  21.         super.onCreate(savedInstanceState);        
  22.         this.setContentView(R.layout.activity_table);
  23.         
  24.         
  25.         mGridTable = (GridView)this.findViewById(R.id.table_grid);
  26.         
  27.         List<double[]> vlist = initList();        
  28.         mAdapter = new TableAdapter(this,vlist);
  29.         mGridTable.setAdapter(mAdapter);
  30.         
  31.         DisplayMetrics dm = new DisplayMetrics();   
  32.         getWindowManager().getDefaultDisplay().getMetrics(dm);   
  33.         float density = dm.density;   
  34.         int gridviewWidth = (int) (90 * 12* density);   
  35.         int itemWidth = (int) (80 * density); 
  36.         
  37.         LinearLayout.LayoutParams params = new LinearLayout.LayoutParams(gridviewWidth , LinearLayout.LayoutParams.MATCH_PARENT);   
  38.         mGridTable.setLayoutParams(params); 
  39.         mGridTable.setColumnWidth(itemWidth);  
  40.         mGridTable.setStretchMode(GridView.NO_STRETCH);   
  41.         mGridTable.setNumColumns(12); 
  42.         
  43.     }
  44.     
  45.     
  46.     private  List<double[]> initList(){
  47.         List<double[]> vList =  new  ArrayList<double[]>();
  48.         vList.add(new double[]{8.5,11.2,10.3,8.2,15,10.2,8.1,12,9.8,8.6,8.5});
  49.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  50.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  51.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  52.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  53.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  54.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  55.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  56.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  57.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  58.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});        
  59.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  60.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  61.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  62.         vList.add(new double[]{8.5,11.2,10.3,8.2,15,10.2,8.1,12,9.8,8.6,8.5});
  63.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  64.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  65.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  66.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  67.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  68.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  69.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  70.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  71.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  72.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});        
  73.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  74.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  75.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  76.         vList.add(new double[]{8.5,11.2,10.3,8.2,15,10.2,8.1,12,9.8,8.6,8.5});
  77.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  78.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  79.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  80.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  81.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  82.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  83.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  84.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  85.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  86.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});        
  87.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  88.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  89.         vList.add(new double[]{8.4,10,9.3,8.3,14.1,13,8.0,13,9.6,9.1,8.9});
  90.         return  vList;
  91.     }
  92. }








posted @ 2016-01-04 12:58  风倾清凌  阅读(520)  评论(0)  编辑  收藏  举报