• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 6 replies
  • Subscribers 4 subscribers
  • Views 3975 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Exporting dataset to Excel starting on second column

hugof

Hi all,
I am exporting a dataset to Excel using a Web API and it works fine except that the first index of the array is located in columns A, B. C,... (it is a CDT) of the spreadsheet as it should, but the rest are located in columns B, C, D,...; that is, starting on the second column instead of the first.
This happens regardless of what is the 1st row od data (either headers or data from the CDT).
Anyone else suffered from this?

OriginalPostID-204856

OriginalPostID-204856

  Discussion posts and replies are publicly visible

Parents
  • 0
    Here is the code. It is just a simple example, but I am also getting the problem described before.

    with(

    local!username: loggedInUser(),

    local!Name:{"John","Hugo","Ivan"},
    local!LastName:{"Carter","Sanchez","Cuatro"},
    local!Email:{"this@one.com","that@one.com","those@ones.com"},

    a!httpResponse(

    headers: {
    a!httpHeader(
    name: "Content-Disposition",
    value: "attachment; filename=" & char(34) & local!username & ".csv" & char(34)
    ) },

    body: {
    {"First Name","Last Name","Email Address"} & char(10),
    {merge(local!Name,local!LastName,local!Email, repeat(3,char(13)))}
    }
    )

    )
Reply
  • 0
    Here is the code. It is just a simple example, but I am also getting the problem described before.

    with(

    local!username: loggedInUser(),

    local!Name:{"John","Hugo","Ivan"},
    local!LastName:{"Carter","Sanchez","Cuatro"},
    local!Email:{"this@one.com","that@one.com","those@ones.com"},

    a!httpResponse(

    headers: {
    a!httpHeader(
    name: "Content-Disposition",
    value: "attachment; filename=" & char(34) & local!username & ".csv" & char(34)
    ) },

    body: {
    {"First Name","Last Name","Email Address"} & char(10),
    {merge(local!Name,local!LastName,local!Email, repeat(3,char(13)))}
    }
    )

    )
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.