# excelPanel

**Repository Path**: hihopeorg/excelPanel

## Basic Information

- **Project Name**: excelPanel
- **Description**: 使用ListContainer实现Excel表格功能
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-09-23
- **Last Updated**: 2021-11-03

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# excelPanel

**本项目是基于开源项目excelPanel进行ohos化的移植和开发的，可以通过项目标签以及github地址（https://github.com/zhouchaoyuan/excelPanel）追踪到原项目版本**

## 项目介绍

- 项目名称：excelPanel
- 所属系列：ohos的第三方组件适配移植
- 功能：使用ListContainer实现Excel表格功能
- 项目移植状态：完成
- 调用差异：无
- 项目作者和维护人：hihope
- 联系方式：hihope@hoperun.com
- 原项目Doc地址：https://github.com/zhouchaoyuan/excelPanel
- 原项目基线版本：v1.0.5 , sha1:023c17e4d10eb72bd03e5cd89bef428bd3e73b51
- 编程语言：Java 
- 外部库依赖：无

## 效果展示

<img src="preview/preview.gif"/>

## 安装教程

方法1.

1. 编译har包excelPanel.har。
2. 启动 DevEco Studio，将编译的har包，导入工程目录“entry->libs”下。
3. 在moudle级别下的build.gradle文件中添加依赖，在dependences标签中增加对libs目录下har包的引用。

```
dependencies {
    implementation fileTree(dir: 'libs', include: ['*.jar', '*.har'])
	……
}
```

4. 在导入的har包上点击右键，选择“Add as Library”对包进行引用，选择需要引用的模块，并点击“OK”即引用成功。

方法2.

1. 在工程的build.gradle的allprojects中，添加HAR所在的Maven仓地址

```
repositories {
    maven {
        url 'http://106.15.92.248:8081/repository/Releases/' 
    }
}
```

2. 在应用模块的build.gradle的dependencies闭包中，添加如下代码:

```
dependencies {
    implementation 'cn.zhouchaoyuan.ohos:excelpanel:1.0.0'
}
```

## 使用说明

### 1、在xml中写入

```
<cn.zhouchaoyuan.excelpanel.ExcelPanel
        ohos:id="$+id:content_container"
        ohos:width="match_parent"
        ohos:height="match_content"
        app:left_cell_width="$float:room_status_cell_length"
        app:normal_cell_width="$float:room_status_cell_length"
        app:top_cell_height="$float:room_status_cell_length" />
```

使用xml属性配置

```
app:left_cell_width     //left header cell's width, not support wrap_content
app:normal_cell_width   //container cell's width, not support wrap_content
app:top_cell_height     //top header cell's height, not support wrap_content
```


### 2、定义自定义适配器
适配器必须继承BaseExcelPanelAdapter，并覆盖如下所示的方法：

```
public class CustomAdapter extends BaseExcelPanelAdapter<RowTitle, ColTitle, Cell> {

    public CustomAdapter(Context context, Component.ClickedListener blockListener) {
        super(context);
     
    }

    //=========================================content's cell===========================================
    @Override
    public Component onCreateCellView(ComponentContainer parent, int viewType) {
        return null;
    }

    @Override
    public ViewHolder onCreateCellViewHolder(ComponentContainer parent, int viewType) {
        return null;
    }

    @Override
    public void onBindCellViewHolder(ViewHolder holder, int verticalPosition, int horizontalPosition) {
        
    }

    @Override
    public Component onCreateTopView(ComponentContainer parent, int viewType) {
        return null;
    }

    //=========================================top cell===========================================
    @Override
    public ViewHolder onCreateTopViewHolder(ComponentContainer parent, int viewType) {
        return null;
    }

    @Override
    public void onBindTopViewHolder(ViewHolder holder, int position) {
      
    }

    @Override
    public Component onCreateLeftView(ComponentContainer parent, int viewType) {
        return null;
    }

    //=========================================left cell===========================================
    @Override
    public ViewHolder onCreateLeftViewHolder(ComponentContainer parent, int viewType) {
        return null;
    }

    @Override
    public void onBindLeftViewHolder(ViewHolder holder, int position) {
       
    }

    //=========================================left-top cell===========================================
    @Override
    public Component onCreateTopLeftView() {
        return null;
    }
}
```

### 3、使用适配器

```
private List<RowTitle> rowTitles;
private List<ColTitle> colTitles;
private List<List<Cell>> cells;
private ExcelPanel excelPanel;
private CustomAdapter adapter;
private Component.ClickedListener blockListener

excelPanel = (ExcelPanel) findViewById(R.id.content_container);
adapter = new CustomAdapter(this, blockListener);
excelPanel.setAdapter(adapter);
excelPanel.setOnLoadMoreListener(this);
adapter.setAllData(colTitles, rowTitles, cells);
adapter.enableFooter();
adapter.enableHeader();
```

## 版本迭代
- v1.0.0
- 已实现功能
    1. ListContainer实现Excel表格功能
- 未实现功能
    1. 滑动excel表格列表无法关联顶部日期列表跟随滑动

- 未实现功能
  1. 当前不支持滑动切换item

## 版权和许可信息

```
Copyright 2017 zhouchaoyuan

   Licensed under the Apache License, Version 2.0 (the "License");
   you may not use this file except in compliance with the License.
   You may obtain a copy of the License at

     http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
```