I am trying to to export a task report to an Excel Sheet using the smart servic

sankethv over 10 years ago

I am trying to to export a task report to an Excel Sheet using the smart service "Export To Excel". I am getting this error :

There is a problem with task “Export to Excel” in the process “Test_Task_Report_Excel”. The following error was raised by the Export to Excel function: 0
Data is being generated from the report but it is throwing error at the Sheet Number field (value given is 0). If we provide any value >0, then it is out of range error
Could you please help ?...

Discussion posts and replies are publicly visible

0 Sathya Srinivasan
Appian Employee
over 10 years ago

Does the base template have multiple sheets or just 1 ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sankethv over 10 years ago

Just 1 sheet and the excel is yet to be created in the folder
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sathya Srinivasan
Appian Employee
over 10 years ago

I'm assuming you are using Export to Excel V2 plug-in. Is that correct? If so,
are you following the instructions in the plug-in documentation? If you excel has just 1 sheet, specifying the plug-in to write to any other sheet wont work.
Please read the documentation attached with the plug-in to help you configure the plug-in better.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel