How to Import data from Excel to VC

[Former Member]

Can anyone please give me a step by step solution as to how do i import any data from an MS Excel file to Visual Composer.

[Sathish · Accepted solution]

Marcel, Mario,

I used the below link to download the driver and there were no problems.

http://www.hxtt.com/text.html select “Download directly JDBC30 trial version”.

Quick link: http://www.hxtt.com/text.zip

I was able to display the cell values. Do confirm if you had used the same link.

[Former Member · Accepted solution]

Hi Sathish

I download Excel_JDBC30.jar from the link you gave. Than i created a JDBC driver named "Excel_JDBC30" in visual Administrator and added the jar file to it.Than i created a new connector "Excel_jdbc" and added "library:Excel_JDBC30" to it.

Than in the portal i created a BI_JDBC system with the following connection properties:

URL: jdbc:excel://punitp54700d:3099/C:/EP_Installables/test

Driver: com.hxtt.sql.excel.ExcelDriver

punitp54700d is the server name and "test" is a .xls file

In the ConnectionFactoryClass: Excel_jdbc.

after this a created a system alias and did the user mapping.

but while checking the connection tests it fails.

So can you guide me what i have done is valid or not.

Thanks in advance.

Regards

Paresh

[Former Member · Accepted solution]

Hi Sathish,

The connection problem was solved.

Please can u guide me how to bring all the data from .xls file into VC.

Presently its only bringing the header data from the .xls file.

Regards,

Paresh.

[Former Member · Accepted solution]

Hi Paresh,

can you tell us what was the solution to your access-problem?

Thank you

Mario

[Former Member · Accepted solution]

Hi Mario,

I did a modification for the URL while creating the BI_JDBC system.

URL: jdbc:excel:/C:/EP_Installables/test.xls

Driver: com.hxtt.sql.excel.ExcelDriver

where "C:/EP_Installables" was the path of the "test.xls" file.

By this way the connection problem was solved.

Regards

Paresh

[Former Member · Accepted solution]

Great, thanks. I added that setup and example to the connectivity FAQ in the WIKI: https://wiki.sdn.sap.com/wiki/display/VC/JDBCConnectionSetup

[Former Member]

hello,

i have the same problem like <b>paresh panda</b>, can you help me?

when i am trying to display a table i am getting only the table header instead of the cell value....

[Former Member]

You cannot "import" data into VC, you can "connect" against a system. In your case you need to connect against an Excel-File via a JDBC connector. See more in the Visual Composer FAQ in the WIKI:

https://wiki.sdn.sap.com/wiki/display/VC/JDBCConnectionSetup

[Former Member]

Hi Mario,

in the wiki you wrote that the relique CSV JDBC driver does not work yet. You copied the comment from a thread here in the SDN. Maybe it is possible to get the modified JDBC driver as download?

The hxtt JDBC Driver is use for reading excel data, but there is also an issue. If you display a table you get in every row the table header instead of the cell value. Only a workaround helps. Create new fields and reference with a formula on the "original" fields, then you get the correct values instead of the table header.

Best Regards,

Marcel

[Former Member]

Hi Marcel,

yes, I saw your suggestion in the other thread and would welcome to get the working driver on SDN. CSV & Excel are pretty popular formats here in the forum and I would be glad to have a solution.

Can you add your comments of the hxtt driver to the WIKI page?

Perhaps we should contact both hxtt and Relique to fix/extend their drivers?

Mario

[Former Member]

Hi Marcel,

I am facing the same issue as you have mentioned, that is when i am trying to display a table i am getting only the table header instead of the cell value.

Please can u elaborate the method that you have mentioned to solve this problem.

It would be of great help if you explain it with an example.

Regards

Paresh.