Skip to main content
May 30, 2024
Solved

Error on Export Data Store Entity to Excel - "The custom cell positions and custom cell values arrays must have the same length."

  • May 30, 2024
  • 1 reply
  • 0 views

I have a relatively simple Excel document that I want to generate using the Export Data Store Entity to Excel process node. I want a Title cell at the top left, then column headers in the second row, and then the rows of data below.

I have my custom cell positions set as: {"A1, A2", "B2", "C2", "D2", "E2", "F2", "G2"},

And my custom cell values set as:

{
concat("Person Information for Transfer #", pv!transferId),
"First Name",
"Middle Name",
"Last Name",
"ID Number",
"Date of Birth",
"# of High Value Bags",
"# of Personal Bags"
}

Both arrays have a length of 8, but I'm receiving the error, "The custom cell positions and custom cell values arrays must have the same length." What's causing this error?

    Best answer by stefanhelzle0001

    1 reply

    stefanhelzle0001
    May 30, 2024