[Question]: Parsing method table failed to parse xlxs

[water-2022]

Describe your problem

The error is as follows：

Traceback (most recent call last):
  File "/ragflow/rag/svr/task_executor.py", line 146, in build
    cks = chunker.chunk(row["name"], binary=binary, from_page=row["from_page"],
  File "/ragflow/rag/app/table.py", line 141, in chunk
    dfs = excel_parser(
  File "/ragflow/rag/app/table.py", line 66, in __call__
    res.append(pd.DataFrame(np.array(data), columns=headers))
  File "/usr/local/lib/python3.10/dist-packages/pandas/core/frame.py", line 816, in __init__
    mgr = ndarray_to_mgr(
  File "/usr/local/lib/python3.10/dist-packages/pandas/core/internals/construction.py", line 336, in ndarray_to_mgr
    _check_values_indices_shape_match(values, index, columns)
  File "/usr/local/lib/python3.10/dist-packages/pandas/core/internals/construction.py", line 420, in _check_values_indices_shape_match
    raise ValueError(f"Shape of passed values is {passed}, indices imply {implied}")
ValueError: Shape of passed values is (0, 1), indices imply (0, 7)

[KevinHuSh]

Could you attach the file?

[water-2022]

Could you attach the file?

The files are company property.

The Excel file contains an excessive number of sheets, and the table has some merged cells.

[KevinHuSh]

Could you mock up a sample that will fail.

[water-2022]

Could you mock up a sample that will fail.

@KevinHuSh This is a sample file.

1.xlsx