Search This Blog

Friday, June 5, 2015

Component Interface SDK for Excel

The power of CI is on two areas. Exposing the business rules + integration options. 

You can integrate CI using Java/C++/COM/Web Services. But there is a simple integration which will allow the admin staffs to easily access and review the data in an excel sheet.

That's the CI SDK for Excel. 

You can find the sample Excel SDK file under:                                                     \sdk\pscompintfc\src\com\samples\vba\sdk_bus_exp\sdk_bus_exp.xlsm

Compile the project first, enable the macros, provide the connection details and the excel can work like a from to pull and update data easily for the excel fans.

That's handy.

No comments:

Post a Comment