Using excelwriter sso

DEVELOPER

Trail: PROIV Documentation > Developer > Introduction to PROIV Developer > SSO Overview > Using ExcelWriter SSO

Using the ExcelWriter SSO, you can create an Excel workbook with PROIV. The SSO supports XLS and XLSX and file formats. From PROIV logic you call the SSO to create or open the Excel file at a location on the file system. Using the methods exposed by the SSO you can set the content and format of cells within the workbook.

To add the ExcelWriter SSO into your function:

1. Open the relevant function and double-click the function name.

2. Click SSOs tab.

3. Under SSO Nickname, select ExcelWriter and click OK.
   
   

4. You are now able to use the SSO within the function logic event points. The example below shows the minimum SSO method calls to create an Excel file and set some text into a cell. For further information visit the ExcelWriter online documentation found in your PROIV installation (typically http://MachineName:10801/webhelp/PROIV_Documentation.htm#t=developer%2Fsso_overview.htm) or access
   InstallationFolder\PROIV Version 10\VirtualMachine\javadocs\index.html.
   
   
   

5. Build and run the function.
   The Microsoft Excel workbook is created at the specified location.

Comment on this topic

Topic ID: 500712