Home > Forum > Actions > Create Excel File

Create Excel File

0

Mario

17.07.2023

08:43

Mario

Hello,

I have a short question. I want to generate an Excel file with my data from the BPS datasource.
I created an Excel template with a worksheet(test) and a table(myTable) and a action create excel.
I write the assignment like this: test!myTable and my data to the right cell.
But I always get an error. (Invalid cell name)
If I just want one data set and just write the cell names for each like test!A2, it works perfectly.

What am I doing wrong?

Thanks for some hints,

Mario

Wojciech Włodarczyk

17.07.2023

10:55

Wojciech Włodarczyk

Hi,
The column names in Excel and in the source table should be the same. Additionally, verify that if you have numeric fields that they are formatted properly in excel e.g. numbers in excel should be formatted as "numeric" etc.

Solution (0)

Helpful (0)

Wrong answer (0)

17.07.2023

22:52

Hi Mario,

it seems as it doesn't work.

When defining a mapping, you can't select a data table but you can select a data row. This will return the first row, and as you noticed it doesn't work with a range formatted as a table.

My best /stupid idea to circumvent this problem would be to populate a technical item list with the data from the data source, create the excel file and delete the data again. As long as the item list columns have the same names as the header cells in Excel, everything would be fine.

Best regards,
Daniel

Solution (1)

Helpful (0)

Wrong answer (0)