[{"id":"2457f0e0-9e71-4860-a87d-065e0fb84f84","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"4706db46-0811-4652-8f59-1e0a1da84758","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"2426c71d-8332-4cbd-a436-1ec4f8666464","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"ae60ae59-34f5-4f32-a8eb-243ed1457543","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"677e13a7-6f3e-449f-986c-2c3a26f8d54f","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"133f4ca6-d951-4d65-a618-3dc6301266f7","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"3d4848c3-910f-4ffa-9153-60bb507334a9","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"d5c67fd0-1145-482c-9113-97b492c44c18","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"bcb0874d-299b-448e-9552-9e9b25ef80dd","tags":[{"name":"更新","color":"orange","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"ba7e818e-4f6b-4211-b1ac-58e3bafcf439"}]},{"id":"b4a9eb15-94e5-48df-b218-a24138f0cf9c","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"5e40f6dc-caec-49d7-a1d0-be65f06815ba","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"8f1271bb-2cd9-4f39-9897-c15b239ee7ab","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"a609a8fa-ab91-4c1d-a1c3-d209d0463303","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]},{"id":"2ce7b6b0-78aa-4e4b-bf8a-e4ba2f988298","tags":[{"name":"新增","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63","links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80"}]}]
        
(Showing Draft Content)

手动追加 Excel 数据

功能概述

与覆盖和重新上传不同,追加数据时不改变原来的数据,仅追加新的数据。

注意

系统对用于追加的 Excel 文件有一定的限制和要求,具体为:

  1. 新的数据表结构必须与原数据表(即创建数据源过程中勾选使用的表)完全一致,包括数据表的列名、列的数量,列的顺序,数据格式等。

  2. 新 Excel 中数据表的数量必须大于或等于原数据表(即创建数据源过程中勾选使用的表)的数量,且多出的数据表不进行追加。

  3. 新 Excel 中数据表的名称必须与原数据表(即创建数据源过程中勾选使用的表)保持一致。

追加数据

比如我们先创建了一个数据源,将1月份的销售数据上传,效果如下图。

image2020-3-31_15-15-57.png

然后,想将2月份的数据追加到1月份的数据源中,形成一个完整的销售数据表。

鼠标悬浮至数据源上,单击右侧的image2020-3-31_14-24-52.png,选择追加数据进入追加数据窗口。

image

选择需要追加的数据表,然后单击追加即可。

image2021-4-30_12-19-20.png

刷新数据源即可看到追加后的效果。

image2020-3-31_15-21-27.png