Import Excel sheets In a VC Devolpement and apply KPI

[Former Member]

Dear All,

I am a newbie in VC. I have a scenario where in i have some data stored in an organisation in native excel sheet and i need to read those excel sheets and apply some KPI on it and make dashboard.

I know data can be exported in excel but how about importing them in VC.Is there any standard steps for the same?

Is VC the correct platform for the same?

Please help me although the quesry can be very basic.

Regards,

Anirban.

[Former Member · Accepted solution]

Hello.

Does the following link work for anyone?

<a href="http://hxtt.com/excel.html">http://hxtt.com/excel.html</a>

We are working on pulling Excel data into VC as well.

We have the HXTT CSV driver, but the links on HXTT's website no longer work for me. Please confirm if the links are down or working. Do you know of any other places where I can download this JDBC Excel driver?

Thanks in advance,

Chuan

[Former Member · Accepted solution]

Please disregard. The link is functional and I am able to access it. Thank you.

[Former Member]

Hi Anirban,

the How to above mentiones the opensource CSV driver 'relique'. We did not manage to get this driver working. The only driver we got running correctly is a driver from HXTT. (http://www.hxtt.com)

They over an Excel driver too. That is even working.

Regards

Lars

[Former Member]

Hi Anirban,

you only need a JDBC driver for excel as Mario already written. A colleague of me has already installed it and tested it. Then you have access to workbooks and the tables via SQL Editor.

In the document, which Mario refers to, it is described for CSV files, but there is also a possibility for Excel files (*.xls) with another commercial JDBC driver. I must ask my colleague, maybe I can give you more details tomorrow.

But if you haven't more then one workbook, you can also save your excel files as CSV and use the CSV driver.

Best Regards,

Marcel

[Former Member]

To some extend you can. It's not that you can launch an Open file-dialog and access you Excel-file, but you need to put the Excel-file (as CSV) on a share and access it via a JDBC driver. That's what you would have to setup in the system connections of the Portal and the Visual Admin to install the driver.

There is even a How To paper on the SDN in the VC area (I think it was in this document: How to Resolve Visual Composer Issues - https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/92d80512-0a01-0010-32a3-cd3... )

More on https://www.sdn.sap.com/irj/sdn/visualcomposer