langgenius/dify
1
0
Fork 0
mirror of https://github.com/langgenius/dify.git synced 2026-07-21 20:15:31 -04:00
Code Issues 775 Packages Projects Releases 10 Wiki Activity

Excel import and splite is unexpected. #1312

New Issue
Closed
opened 2026-02-21 17:32:11 -05:00 by yindo · 0 comments
yindo commented 2026-02-21 17:32:11 -05:00
Owner
Copy Link
Copy Source

Originally created by @Weaxs on GitHub (Mar 12, 2024).

Originally assigned to: @JohnJyong on GitHub.

Self Checks

  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report (我已阅读并同意 Language Policy).
  • Pleas do not modify this template :) and fill in all the required fields.

1. Is this request related to a challenge you're experiencing?

My excel has three sheets, and every sheet has different first line, such like
image
image
image

2. Describe the feature you'd like to see

When I import the excel file into knowledge, I choose auto-segement as default, I got chunks like following. But I think it is not expected.

# sheet1
date:2020-01-01;m2(亿元):2023066.49;m2同比(%):8.40000;m2环比(%):1.84000;m1(亿元):545531.79;m1同比(%):0.00000;m1环比(%):-5.29000;m0(亿元):93249.16000;m0同比(%):6.60000;m0环比(%):20.81000;
...
# sheet2
date:日期;m2(亿元):制造业;m2同比(%):制造业同比;m2环比(%):非制造业;m1(亿元):非制造业同比;
date:2022-12-01;m2(亿元):47.00000;m2同比(%):-6.56000;m2环比(%):41.60000;m1(亿元):-21.06000;
...
# sheet3
date:日期;m2(亿元):全国;m2同比(%):全国同比（%）;m2环比(%):全国环比（%）;m1(亿元):城市;m1同比(%):城市同比（%）;m1环比(%):城市环比（%）;m0(亿元):农村;m0同比(%):农村同比（%）;m0环比(%):农村环比（%）;
date:2022-11-01;m2(亿元):101.60000;m2同比(%):1.60000;m2环比(%):-0.20000;m1(亿元):101.50000;m1同比(%):1.50000;m1环比(%):-0.20000;m0(亿元):101.70000;m0同比(%):1.70000;m0环比(%):-0.20000;
...

Actually, it is default to use line 1 in sheet 1 as key for total sheets data.

3. How will this feature improve your workflow or experience?

I expect use line 1 in every sheet as key for current sheet data. such like these:

# sheet1
date:2020-01-01;m2(亿元):2023066.49;m2同比(%):8.40000;m2环比(%):1.84000;m1(亿元):545531.79;m1同比(%):0.00000;m1环比(%):-5.29000;m0(亿元):93249.16000;m0同比(%):6.60000;m0环比(%):20.81000;
...
# sheet2
日期:2022-12-01;制造业:47.00000;制造业同比:-6.56000;非制造业:41.60000;非制造业同比:-21.06000;
...
# sheet3
日期:2022-11-01;全国:101.60000;全国同比（%）:1.60000;全国环比（%）:-0.20000;城市:101.50000;城市同比（%）:1.50000;m1环比(%):-0.20000;农村:101.70000;农村同比（%）:1.70000;农村环比（%）:-0.20000;
...

4. Additional context or comments

No response

5. Can you help us with this feature?

  • I am interested in contributing to this feature.
Originally created by @Weaxs on GitHub (Mar 12, 2024). Originally assigned to: @JohnJyong on GitHub. ### Self Checks - [X] I have searched for existing issues [search for existing issues](https://github.com/langgenius/dify/issues), including closed ones. - [X] I confirm that I am using English to submit this report (我已阅读并同意 [Language Policy](https://github.com/langgenius/dify/issues/1542)). - [X] Pleas do not modify this template :) and fill in all the required fields. ### 1. Is this request related to a challenge you're experiencing? My excel has three sheets, and every sheet has different first line, such like ![image](https://github.com/langgenius/dify/assets/20680212/fbfac64a-ad5d-4da4-8f99-547196dfee99) ![image](https://github.com/langgenius/dify/assets/20680212/7333c71e-f8c0-4762-89e1-e9768347cb5b) ![image](https://github.com/langgenius/dify/assets/20680212/c86630a2-e5a5-4c51-ae14-374e759e0ecb) ### 2. Describe the feature you'd like to see When I import the excel file into knowledge, I choose auto-segement as default, I got chunks like following. But I think it is not expected. ``` # sheet1 date:2020-01-01;m2(亿元):2023066.49;m2同比(%):8.40000;m2环比(%):1.84000;m1(亿元):545531.79;m1同比(%):0.00000;m1环比(%):-5.29000;m0(亿元):93249.16000;m0同比(%):6.60000;m0环比(%):20.81000; ... # sheet2 date:日期;m2(亿元):制造业;m2同比(%):制造业同比;m2环比(%):非制造业;m1(亿元):非制造业同比; date:2022-12-01;m2(亿元):47.00000;m2同比(%):-6.56000;m2环比(%):41.60000;m1(亿元):-21.06000; ... # sheet3 date:日期;m2(亿元):全国;m2同比(%):全国同比（%）;m2环比(%):全国环比（%）;m1(亿元):城市;m1同比(%):城市同比（%）;m1环比(%):城市环比（%）;m0(亿元):农村;m0同比(%):农村同比（%）;m0环比(%):农村环比（%）; date:2022-11-01;m2(亿元):101.60000;m2同比(%):1.60000;m2环比(%):-0.20000;m1(亿元):101.50000;m1同比(%):1.50000;m1环比(%):-0.20000;m0(亿元):101.70000;m0同比(%):1.70000;m0环比(%):-0.20000; ... ``` Actually, it is default to use line 1 in sheet 1 as key for total sheets data. ### 3. How will this feature improve your workflow or experience? I expect use line 1 in every sheet as key for current sheet data. such like these: ``` # sheet1 date:2020-01-01;m2(亿元):2023066.49;m2同比(%):8.40000;m2环比(%):1.84000;m1(亿元):545531.79;m1同比(%):0.00000;m1环比(%):-5.29000;m0(亿元):93249.16000;m0同比(%):6.60000;m0环比(%):20.81000; ... # sheet2 日期:2022-12-01;制造业:47.00000;制造业同比:-6.56000;非制造业:41.60000;非制造业同比:-21.06000; ... # sheet3 日期:2022-11-01;全国:101.60000;全国同比（%）:1.60000;全国环比（%）:-0.20000;城市:101.50000;城市同比（%）:1.50000;m1环比(%):-0.20000;农村:101.70000;农村同比（%）:1.70000;农村环比（%）:-0.20000; ... ``` ### 4. Additional context or comments _No response_ ### 5. Can you help us with this feature? - [X] I am interested in contributing to this feature.
yindo added the 💪 enhancement label 2026-02-21 17:32:11 -05:00
yindo closed this issue 2026-02-21 17:32:11 -05:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Knowledge Pipeline
Proposal
WIP
cloud
dependencies
feat:webapp
good first issue
outdated
performance
pull-request
Mirrored from GitHub Pull Request
 python:uv
refactor
size:L
stale
status: accepting prs
status: blocked
status: in discussion
stt & tts
vulnerablity
web
wont-fix
🌊 feat:workflow
🌚 invalid
🐞 bug
👻 feat:rag
💪 enhancement
📚 documentation
🔨 feat:tools
🙋‍♂️ question
🙏 help wanted
🤔 cant-reproduce
🤖 feat:agent
No Label 💪 enhancement
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
yindo
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify#1312
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?