Generate an Excel from an Itemlist

0

Hi,

It seems to me that the standard action to generate excel from a list of items does not have the option to select the 'Name Only' option for an attribute type choose.
What you can do for this scenario is to add to the list technical columns ex. sql row, to the list where the name will fall and map these columns to the excel table.
You can also create a technical list and update it on record with the data from the head list, Properly formatted , that is, only the names and the list has only a text field.

Regards.

Hi,

If you use the "generate file and excel" action, you can map the corresponding field for each column in the template.
You can choose from the chocefield what to display.
Another option is you can set "allow export excel" at the item list level.
You can try to create column type "data row" in itemlist, or you create sdk for generate excel with data sources sql.

Thanks,
Raluca

Hi,
you can also prepare a sqlgrid with rows from the item list and enable the export to excel option.

If you need to generate more than 998 rows, the best way is as Recula wrote, but specify the data table attribute when generating the Excel file.

Hi,

thanks for all your answers and iteas. The"allow export excel" will not work, because i have to generate the excel automatically and then send it to our customer, depending on a path in the Workflow. Also it seems that i can not map the corresponding excel field for each column in the template because i do not know how much rows i have in the itemlist - or is there a way to use e.g. asterix to use a dynamic way for the targetfields in excel. i'll try that.

The "best" way seems to be, that i use some technical fields or a technical list which i then can map to the excel.