This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



Sep 15, 2015, 5:24 AM
12 Posts
topic has been resolvedResolved

MS Excel CHIINV function implementation in XPages

  • Category: APIs
  • Platform: Windows
  • Release: 9.0.1
  • Role: Developer
  • Tags: Excel CHIINV function Implementation,Excel Scientific functions in XPages
  • Replies: 4

Hi,

I am an XPages developer, and currently working on the report section in an XPages application. On the report form, I have to calculate CHIINV (probability function available in MS excel).

Currently, users are using MS excel sheet (having one formula cell to display result) to generate this report. In the excel file, there is a cell to display the result, and in this cell, CHIINV function is being used.

In the excel, all the data, required for CHIINV function is available, and report is being generated properly there (because of the availability of CHIINV function).

Now, I need to implement the same thing in my report XPage. In my report page, I calculated all the data required for CHIINV function accurately. Now, I just need a way to implement CHIINV functionality here in my XPage.

Now, the challenge is, there is nothing like CHIINV function in SSJS, Java or lotus script (as per my research). So I am unable to generate the final result. Note that this XPage will be accessed via web browser.

On the server machine, MS office is not installed there, so I don't have the option to keep excel file having computed cell on server machine, and access it using OLE object through lotus script.

If any option is available there, please let me know.

Thanks...

Sep 15, 2015, 11:54 AM
586 Posts
hmm

You can make REAL Excel files from XPages using Apache POI Java.  I would think there's some method to preprogram an Excel formula via that API.

Apache POI would NOT require you to have Excel on the server.  It makes native files by itself.

 

 

 


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal