好用漂亮的Android 表格框架2(1)

最新推荐文章于 2024-10-13 11:39:37 发布

2401_84132370

最新推荐文章于 2024-10-13 11:39:37 发布

阅读量597

点赞数 23

分类专栏：程序员文章标签： android

本文链接：https://blog.csdn.net/2401_84132370/article/details/137981628

版权

程序员专栏收录该内容

169 篇文章 0 订阅

订阅专栏

//造假数据仿github贡献图
String[] week = {“日”,“一”,“二”,“三”,“四”,“五”,“六”};
Integer[][] infos = {{0,1,2,1,1,0,1,1,0,1,1,2,3}, {4,2,1,1,0,1,1,0,1,1,2,2,3},
{2,2,0,1,2,4,1,0,1,3,0,1,1},{2,1,1,0,1,4,0,1,1,2,2,0,3},
{0,1,2,4,1,0,1,4,0,1,1,2,2}, {1,0,1,3,2,2,0,1,2,1,1,0,4},
{3,1,2,4,0,1,2,1,1,0,1,1,0}};
ArrayTableData tableData = ArrayTableData.create(“日程表”,week,infos,new IDrawFormat(){
@Override
public int measureWidth(Column column, TableConfig config) {
//设置宽50dp
return DensityUtils.dp2px(ArrayModeActivity.this,50);
}

@Override
public int measureHeight(Column column, int position, TableConfig config) {
//设置高50dp
return DensityUtils.dp2px(ArrayModeActivity.this,50);
}
@Override
public void draw(Canvas c, Column column, Integer integer, String value, Rect rect, int position, TableConfig config) {
Paint paint = config.getPaint();
int color;
switch (integer){
case 1:
color =R.color.github_con_1;
break;
case 2:
color =R.color.github_con_2;
break;
…
break;
}
//绘制正方形
c.drawRect(rect.left+5,rect.top+5,rect.right-5,rect.bottom-5,paint);
}
});
//点击事件
tableData.setOnItemClickListener(new ArrayTableData.OnItemClickListener() {
@Override
public void onClick(Column column, String value, Integer o, int col, int row) {
Toast.makeText(ArrayModeActivity.this,“列:”+col+ " 行："+row + “数据：”+value,Toast.LENGTH_SHORT).show();
}
});
//设置表格数据
table.setTableData(tableData);

就是这么简单。IDrawFormat是格式化样式的接口。其中我几种提供图片和文字多行格式化等。这里直接实现接口，measureWidth，measureHeight方法用于指定Cell格子大小。二维数组里面数据为null也是可以的。

你可能会说，我不想要列标题显示出来，OK，你也可以不用列标题。下面是选座的示例。

final ArrayTableData tableData = ArrayTableData.create(table, “选座表”, data, new ImageResDrawFormat(size,size) {
@Override
protected Context getContext() {
return SeatModeActivity.this;
}

@Override
protected int getResourceID(Integer status, String value, int position) {
if(status == null){return 0;}
switch (status){
case 0:
return R.mipmap.seat;
case 1:
return R.mipmap.seat_selected;
}
return 0;
}

外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传

展示Excel

展示Excel也是使用ArrayTableData就可以。导入数据现在可以通过POI,jxl。我这里使用的jxl.下面是个示例：

外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传

public class ExcelAsyncTask extends AsyncTask<Integer,Void,String[][]>{

@Override
protected String[][] doInBackground(Integer… position) {

try {
int maxRow, maxColumn;
cellRanges = null;
InputStream is = getAssets().open(fileName);
Workbook workbook = Workbook.getWorkbook(is);
Sheet sheet = workbook.getSheet(position[0]);
maxRow = sheet.getRows();
maxColumn = sheet.getColumns();
String[][] data = new String[maxRow][];
for (int i = 0; i < maxRow; i++) {
String[] rows = new String[maxColumn];
for(int j = 0;j < maxColumn;j++){
Cell cell = sheet.getCell(j, i);
if(cell !=null){
rows[j] = cell.getContents();
}else{
rows[j] = null;
}
}
data[i] = rows;
}
workbook.close();
String[][] newData = new String[maxColumn][maxRow];
for (int i = 0; i < data.length; i++) { //转换一下
for (int j = 0; j < data[i].length; j++) {
newData[j][i] = data[i][j]; // 转置核心
}
}
return newData;

} catch (Exception e) {

}

return null;
}

@Override
protected void onPostExecute(String[][] data) {
if(data null || data.length0) {
data = new String[26][50]; //空白表格美观
}
ArrayTableData tableData = ArrayTableData.create(table, “Excel表”, data, new TextDrawFormat());
tableData.setCellRangeAddresses(cellRanges);
table.setTableData(tableData);

}
}