In reply to: Wojtek
Hi,
I came across issue with generating xlsx file from item list. I created xlsx template having a table named Tabela1 consisting of 5 columns and item list with exacly same column names. I actualy exported the item list to xlsx and converted it to a template. After setting up a mapping on the 'Generate excel file' action and running it I keep getting 'Invlid cell name' error. Full error log below. When I use cell adress in mapping (A2) there is no error but only last row of item list is exported which is not what I'm trying to achieve. Am I missing something?
Log
Error code: 100
Invalid cell name
at Aspose.Cells.CellsHelper.CellNameToIndex(String cellName, Int32& row, Int32& column)
at WebCon.WorkFlow.Base.Actions.GenerateExcelWorksheet.InsertValueFromTag(ITagParser tagParser, String tag, TupleEx`2 address, Workbook workbook, ExcelDataTimeHelper excelDataTimeHelper)
at WebCon.WorkFlow.Base.Actions.GenerateExcelWorksheet.FillExcelFileOrReturnError(XmlActionsConfig config, WorkFlowObject wfObject, ITagParser tagParser, Workbook workbook, ExcelDataTimeHelper excelDataTimeHelper)
at WebCon.WorkFlow.Base.Actions.GenerateExcelWorksheet.FireAction(WorkFlowObject wfObject, IWFAction wfAction, ITagParser tagParser, IAutomationDataHelper automationDataHelper, String& message, String& logMessage)
at WebCon.WorkFlow.Base.Automations.Engine.Evaluators.ActionEvaluator.FireAction(ActionBase actionObject, String& userLogMessage, String& adminLogMessage)
at WebCon.WorkFlow.Base.Automations.Engine.Evaluators.ActionEvaluator.Evaluate()
Hi, try this:
add the table in Excel and name the table. Then configure it correctly in WEBCON BPS. A screenshot is attached. The name of the attribute must be the same as in Excel.