Read an excel file using JSP in MII 12.1

[Former Member]

Hi,

I want to read an excel file using jsp page. I dont want to use the UDS or ODBC for connecting to excel.

I am trying to use org.apache.poi to read the excel file in jsp page.

While running, its showing a compilation error "package org.apache.poi.hssf.usermodel does not exist"

I have the jar files for it, where do we need to upload it so that jsp page works.

Thanks a lot

Regards,

Neha Maheshwari

[Former Member]

Neha,

It seems like many people ask about connecting to Excel spreadsheets when they have some significant drawbacks. There is a thread that discusses how to connect to Excel, which it seems you found. What is your reason for using org.apache.poi for connecting to it? Just curious...

Regards,

Kevin

[Former Member]

I would recommend connecting Excel to MII via macros using http to hit the Runner.

[Former Member]

The user doesn't want to save the excel file in server.

I want to upload file and save its contents in database.

I have the code to read and save excel data in database but not able to get the location to deploy the jar file.

In general, if we are creating a jsp page in MII workbench which is using some jar file.

Whats the location to upload this jar file so that the jsp page works correctly?

[Former Member]

Neha, you can install the OLEDB UDS directly on the system where the Excel worksheet is located. There is no need to copy it to the MII server.

Rick

[Former Member]

Its not just one user. There will be many users uploading the excel.

[Former Member]

Put a button on the spreadsheet. write some code so when the users press the button you bundle up whatever data needs to be submitted and use an http post to send it to MII.