Discussion

11
Replies
6679
Views
X
GaryB457 Member since 2012 3 posts
Catamaran/Optum
Posted: 4 years ago
Last activity: 4 years 7 months ago
Closed

HTML Export to Excel and OOTB activity

Using Pega 6.2 sp 2

I have a report that's created  using an activity.  Also,  i have created the HTML (HTML Stream) in this activity.   i would like to export this HTML as an excel spreadsheet, onto the users local computer in directory, C:\PegaReport.  I don't want the user to have to Save the file manually or even know the file is being created into this directory.  They should be able to run the report,  look in the directory,  and see the Excel version of the report after they've run the report.

I've looked at ExportToExcel (OOTB activity).  However, i don't see anyway of telling ExportToExcel what directory to put the excel report into.?  I've looked at MSOGenerateExcelFile, but i'm not sure how to geneate the excel template needed for this OOTB activity.

I'd prefer to use the ExportToExcel activity, but i'm open to creating the excel file anyway i can.

 

Any help is appreciated.

below is the HTML that gets created by the activity.  This is what i'd like to use to create the excel file.

<HTML>
   <H2><B><FONT COLOR=GREEN>Quarterly Activity Report</FONT></B></H2>
   <H3><FONT COLOR=GREEN>Report Date: 15-Oct-15<br> Client Name: TEST CLIENT<br> Client ID: TESTID   AP<br> Reporting Period: 05-Oct-14 to 15-Oct-15</FONT> </H3>
   <TABLE cellspacing='0' cellpadding='1'  border='1' style='border-collapse: collapse;'>
      <TR>
         <TD colspan="2" align="center" bgColor='#dcdcdc' class='excelText'>PROFILE STATISTICS</TD>
      <TR>
         <TD bgColor= class='excelText'>Profiles Reviewed</TD>
         <TD bgColor= class='excelText'>24</TD>
      </TR>
      <TR>
         <TD bgColor= class='excelText'>Profiles Validated</TD>
         <TD bgColor= class='excelText'>8</TD>
      </TR>
      <TR>
         <TD bgColor= class='excelText'>% of Profiles Validated</TD>
         <TD bgColor= class='excelText'>33.00%</TD>
      </TR>
      <TR>
         <TD bgColor= class='excelText'>Total Prescriber with Interventions</TD>
         <TD bgColor= class='excelText'>11</TD>
      </TR>
      <TR>
         <TD bgColor= class='excelText'>Total Feedback Responses by Prescribers</TD>
         <TD bgColor= class='excelText'>9</TD>
      </TR>
      <TR>
         <TD bgColor= class='excelText'>Prescriber Response Rate</TD>
         <TD bgColor= class='excelText'>82.00%</TD>
      </TR>
      <TR>
         <TD bgColor= class='excelText'>Case Response Rate</TD>
         <TD bgColor= class='excelText'>100.00%</TD>
      </TR>
      </TR>
   </TABLE>
   <br/><br/>
   <TABLE cellspacing='0' cellpadding='1'  border='1' style='border-collapse: collapse;'>
      <TR>
         <TD colspan="1" align="left" bgColor='#dcdcdc' class='excelText'>FEEDBACK RESPONSE</TD>
         <TD colspan="1" align="left" bgColor='#dcdcdc' class='excelText'>Total Number of Prescriber Feedback Responses</TD>
         <TD colspan="1" align="left" bgColor='#dcdcdc' class='excelText'>% Prescriber Feedback Responses</TD>
         <TD colspan="1" align="left" bgColor='#dcdcdc' class='excelText'>Total Number of Case Feedback Responses (Medical Necessity Confirmed)</TD>
         <TD colspan="1" align="left" bgColor='#dcdcdc' class='excelText'>% of Cases with Medical Necessity Confirmed</TD>
      </TR>
      <TR>
         <TD colspan="1" align="left" bgColor= class='excelText'>Phone</TD>
         <TD bgColor= class='excelText'>2</TD>
         <TD bgColor= class='excelText'>22.00%</TD>
         <TD bgColor= class='excelText'>0</TD>
         <TD bgColor= class='excelText'>0%</TD>
      </TR>
      <TR>
         <TD colspan="1" align="left" bgColor= class='excelText'>Feedback Response Form</TD>
         <TD bgColor= class='excelText'>7</TD>
         <TD bgColor= class='excelText'>78.00%</TD>
         <TD bgColor= class='excelText'>0</TD>
         <TD bgColor= class='excelText'>0%</TD>
      </TR>
   </TABLE>
   <br/><br/>
   <TABLE cellspacing='0' cellpadding='1'  border='1' style='border-collapse: collapse;'>
      <TR>
         <TD colspan="2" align="left" bgColor='#dcdcdc' class='excelText'>POINT OF SERVICE EDITS</TD>
      </TR>
      <TR>
         <TD colspan="1" align="left" bgColor= class='excelText'># Implemented</TD>
         <TD bgColor= class='excelText'>0</TD>
      </TR>
      <TR>
         <TD colspan="1" align="left" bgColor= class='excelText'># Pending</TD>
         <TD bgColor= class='excelText'>6</TD>
      </TR>
   </TABLE>
   <br/><br/>
   <TABLE cellspacing='0' cellpadding='1'  border='1' style='border-collapse: collapse;'>
      <TR>
         <TD colspan="2" align="left" bgColor='#dcdcdc' class='excelText'>SPECIAL INVESTIGATION UNIT REFERRALS</TD>
      </TR>
      <TR>
         <TD colspan="1" align="left" bgColor= class='excelText'># Referred for fradulent activity</TD>
         <TD bgColor= class='excelText'>0</TD>
      </TR>
   </TABLE>
   <br/><br/>
</HTML>
 

 

Data Integration Java and Activities
Moderation Team has archived post
Share this page LinkedIn