Is There a Bug in the "add_a_worksheet_tablerow" Function with Excel?

Bugs
1

This topic was automatically generated from Slack. You can find the original thread here.

I have read the documentation and even tried the PI bot, and I might have found a bug when using the function “add_a_worksheet_tablerow” with Excel.

2

Hi Ivan, I think you’re very very close.

But you may notice on the Excel action, that the Value prop’s description notes:

A 2 dimensional array of unformatted values for the table row…

The steps.node.$return_value appears to be a 1 dimensional array.

I would try following the format linked from that description.

3

I tried looking at TableRowCollection: add - Microsoft Graph v1.0 | Microsoft Learn but still can’t crack it :slightly_smiling_face:

4

It’s buried a bit, but I think this example bit clear things up:

5 
const workbookTableRow = {
  index: 5,
  values: [
    [1, 2, 3],
    [4, 5, 6]
  ]
};

The values parameter needs to be a multi-dimensional array, where each array within the main array represents an entire row.

6

image.png
image.png808×780 25.3 KB

7

image.png
image.png814×557 20.8 KB

8

Can you show the Inputs tab please?

9

sure

image.png
image.png813×515 18.8 KB

10

Thank you. The Values field needs to be a multi-dimensional array, not an object.

I shared the entire payload from the Microsoft docs as an example. The values property in that example lines up with the Values field in the Pipedream action.

11

So for example, you could try in your node step:

return [
    [1, 2, 3],
    [4, 5, 6]
  ];
12

image.png
image.png817×517 19.1 KB

13

tried it with just one

14

image.png
image.png819×502 18.3 KB

15

so it’s not the comma between the arrays

16

image.png
image.png800×498 17.5 KB

17

image.png
image.png803×500 17.5 KB

18

bug? :slightly_smiling_face:

19

Hmm perhaps maybe! :slightly_smiling_face:

You can report bug reports on actions and triggers here in our public Pipedream Github Repository:

A Pipedream team developer or community member will investigate and make a new version to attempt to fix it if they can reproduce the bug.

All Pipedream triggers and actions are open source, so you can also contribute your own fix if you’d like.

Learn about how to develop new and modify existing components here: Overview

20

thanks for your help