Question
Tech Mahindra
IN
Last activity: 23 Jun 2016 8:00 EDT
pega 6.3 - excel file upload
What version of excel is supported to file upload with pega 6.3 .
Message was edited by: Lochan to add Category
Accepted Solution
Mphasis
IN
Use Filepath control to upload a file.
The excel file path will be in pxRequestor.pyFileUpload
Save as the Binary file PA_UseCases_AA with someother name, download the excel template and modify according to your application pages and properties.
Use MSOParseExcelFile OOTB activity to parse the uploaded excelfile.
Pass the following parameters to the above activity
FSFileName = pxRequestor.pyFileUpload
TemplateRFB = "excel!SomeTemplate!xlsx" (This is the Binary file created above)
bDeleteFile = leave blank if you don't want to delete
strType = provide the sheet name which is provided in the excelsheet
Below is the sample template
| Trigger |
Complexity |
On Behalf Of |
Actors |
Business Objective |
Description |
| {.pyExcelUseCases().pyTrigger input} |
{.pyExcelUseCases().pyComplexity input} |
{.pyExcelUseCases().pySecondaryActor input} |
Use Filepath control to upload a file.
The excel file path will be in pxRequestor.pyFileUpload
Save as the Binary file PA_UseCases_AA with someother name, download the excel template and modify according to your application pages and properties.
Use MSOParseExcelFile OOTB activity to parse the uploaded excelfile.
Pass the following parameters to the above activity
FSFileName = pxRequestor.pyFileUpload
TemplateRFB = "excel!SomeTemplate!xlsx" (This is the Binary file created above)
bDeleteFile = leave blank if you don't want to delete
strType = provide the sheet name which is provided in the excelsheet
Below is the sample template
| Trigger |
Complexity |
On Behalf Of |
Actors |
Business Objective |
Description |
| {.pyExcelUseCases().pyTrigger input} |
{.pyExcelUseCases().pyComplexity input} |
{.pyExcelUseCases().pySecondaryActor input} |
{.pyExcelUseCases().pyActor input} |
{.pyExcelUseCases().pyBusinessObjectiveForExcel input} |
{.pyExcelUseCases().pyDescription input} |
Pegasystems Inc.
IN
Microsoft Office 2003, 2007 and 2010 are supported for PRPC 6.3.
Kindly refer page -11 of below platform support guide:
https://docs-previous.pega.com/platform-support-guide-prpc-5x-and-6x
Tech Mahindra
IN
Thanks Aravind.
Could you please provide reference document to implement in pega 6.3.
I need to upload excel and store it in a grid on pyworkpage.
Accepted Solution
Mphasis
IN
Use Filepath control to upload a file.
The excel file path will be in pxRequestor.pyFileUpload
Save as the Binary file PA_UseCases_AA with someother name, download the excel template and modify according to your application pages and properties.
Use MSOParseExcelFile OOTB activity to parse the uploaded excelfile.
Pass the following parameters to the above activity
FSFileName = pxRequestor.pyFileUpload
TemplateRFB = "excel!SomeTemplate!xlsx" (This is the Binary file created above)
bDeleteFile = leave blank if you don't want to delete
strType = provide the sheet name which is provided in the excelsheet
Below is the sample template
| Trigger |
Complexity |
On Behalf Of |
Actors |
Business Objective |
Description |
| {.pyExcelUseCases().pyTrigger input} |
{.pyExcelUseCases().pyComplexity input} |
{.pyExcelUseCases().pySecondaryActor input} |
Use Filepath control to upload a file.
The excel file path will be in pxRequestor.pyFileUpload
Save as the Binary file PA_UseCases_AA with someother name, download the excel template and modify according to your application pages and properties.
Use MSOParseExcelFile OOTB activity to parse the uploaded excelfile.
Pass the following parameters to the above activity
FSFileName = pxRequestor.pyFileUpload
TemplateRFB = "excel!SomeTemplate!xlsx" (This is the Binary file created above)
bDeleteFile = leave blank if you don't want to delete
strType = provide the sheet name which is provided in the excelsheet
Below is the sample template
| Trigger |
Complexity |
On Behalf Of |
Actors |
Business Objective |
Description |
| {.pyExcelUseCases().pyTrigger input} |
{.pyExcelUseCases().pyComplexity input} |
{.pyExcelUseCases().pySecondaryActor input} |
{.pyExcelUseCases().pyActor input} |
{.pyExcelUseCases().pyBusinessObjectiveForExcel input} |
{.pyExcelUseCases().pyDescription input} |