Export Data Store Entity to Excel multiple times to a single file

Hi all,

I have a process model in which I use Export DSE to Excel smart shape 2 times in a row. In 1st shape I want to export a set of data to sheet 1, starting cell A4. In 2nd shape I want to export a set of data to sheet 1, starting cell AA4. After 1st shape, the exported file looks good. After 2nd shape all data exported by 1st are removed and only data from 2nd shape are present. 

Can you help me understand why is this so? Not sure if this is a problem with my solution, platform defect, or an intention to complete remove the rows before exporting to them. 

Thank you

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    Can you share screenshots of your configurations for both EDSEtE nodes?

  • Hopefully a description will be fine.

    1st shape:

    • DSE: a constant to DSE
    • Selection: list of fields 1..50
    • Document to Update: pv!localTemplate_doc
    • Include Header: true
    • Sheet Number: 1
    • Starting Cell: "A4"

    2nd shape:

    • DSE: a constant to DSE
    • Selection: list of fields 51..80
    • Document to Update: pv!localTemplate_doc
    • Include Header: true
    • Sheet Number:1
    • Starting Cell: "AY4"

    Both smart shapes run successfully. When I check the document after 1st shape, columns A4..AX4 have values. When I check the document after 2nd shape, columns AY4..CB4 have values, but values from A4..AX4 are removed. Any static values entered in rows 1..3 are kept and not removed. It almost looks like whenever the smart shape is called, it get the starting cell and completely wipes whole row before writing the data. 

    To somehow proof that I don't have a logical error I tried a scenario where 2nd smart shape export to 2nd sheet. In such case all the data were successfully there. 

Reply
  • Hopefully a description will be fine.

    1st shape:

    • DSE: a constant to DSE
    • Selection: list of fields 1..50
    • Document to Update: pv!localTemplate_doc
    • Include Header: true
    • Sheet Number: 1
    • Starting Cell: "A4"

    2nd shape:

    • DSE: a constant to DSE
    • Selection: list of fields 51..80
    • Document to Update: pv!localTemplate_doc
    • Include Header: true
    • Sheet Number:1
    • Starting Cell: "AY4"

    Both smart shapes run successfully. When I check the document after 1st shape, columns A4..AX4 have values. When I check the document after 2nd shape, columns AY4..CB4 have values, but values from A4..AX4 are removed. Any static values entered in rows 1..3 are kept and not removed. It almost looks like whenever the smart shape is called, it get the starting cell and completely wipes whole row before writing the data. 

    To somehow proof that I don't have a logical error I tried a scenario where 2nd smart shape export to 2nd sheet. In such case all the data were successfully there. 

Children