Android读取poi的execl显示为表格

要在Android中读取Excel文件并将其显示为表格，可以使用以下步骤：

1. 导入Apache POI库：在项目的build.gradle文件中添加以下依赖项：

implementation 'org.apache.poi:poi:4.1.2'
implementation 'org.apache.poi:poi-ooxml:4.1.2'

2. 在布局文件中添加RecyclerView视图：

<androidx.recyclerview.widget.RecyclerView
    android:id="@+id/recyclerView"
    android:layout_width="match_parent"
    android:layout_height="match_parent" />

3. 创建一个ExcelUtils类来读取Excel文件并将其转换为列表：

public class ExcelUtils {

    public static List<List<String>> readExcel(Context context, Uri uri) throws IOException, InvalidFormatException {
        InputStream inputStream = context.getContentResolver().openInputStream(uri);
        Workbook workbook = WorkbookFactory.create(inputStream);
        Sheet sheet = workbook.getSheetAt(0);
        List<List<String>> data = new ArrayList<>();
        for (Row row : sheet) {
            List<String> rowData = new ArrayList<>();
            for (Cell cell : row) {
                rowData.add(cell.getStringCellValue());
            }
            data.add(rowData);
        }
        return data;
    }
}

4. 创建一个RecyclerView适配器来显示Excel数据：

public class ExcelAdapter extends RecyclerView.Adapter<ExcelAdapter.ViewHolder> {

    private List<List<String>> mData;

    public ExcelAdapter(List<List<String>> data) {
        mData = data;
    }

    @Override
    public ViewHolder onCreateViewHolder(ViewGroup parent, int viewType) {
        View view = LayoutInflater.from(parent.getContext()).inflate(R.layout.item_excel, parent, false);
        return new ViewHolder(view);
    }

    @Override
    public void onBindViewHolder(ViewHolder holder, int position) {
        List<String> rowData = mData.get(position);
        holder.mTextView1.setText(rowData.get(0));
        holder.mTextView2.setText(rowData.get(1));
        holder.mTextView3.setText(rowData.get(2));
    }

    @Override
    public int getItemCount() {
        return mData.size();
    }

    public static class ViewHolder extends RecyclerView.ViewHolder {
        public TextView mTextView1, mTextView2, mTextView3;

        public ViewHolder(View itemView) {
            super(itemView);
            mTextView1 = itemView.findViewById(R.id.textView1);
            mTextView2 = itemView.findViewById(R.id.textView2);
            mTextView3 = itemView.findViewById(R.id.textView3);
        }
    }
}

5. 在Activity中使用ExcelUtils类来读取Excel文件并将数据传递给RecyclerView适配器：

public class MainActivity extends AppCompatActivity {

    private RecyclerView mRecyclerView;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        mRecyclerView = findViewById(R.id.recyclerView);
        mRecyclerView.setLayoutManager(new LinearLayoutManager(this));

        try {
            List<List<String>> data = ExcelUtils.readExcel(this, uri);
            ExcelAdapter adapter = new ExcelAdapter(data);
            mRecyclerView.setAdapter(adapter);
        } catch (IOException e) {
            e.printStackTrace();
        } catch (InvalidFormatException e) {
            e.printStackTrace();
        }
    }
}

这样就可以在Android应用程序中读取Excel文件并将其显示为表格了。