You are not logged in.

Search results

Search results 1-2 of 2.

Dear visitor, welcome to Jabaco - Community. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Wednesday, February 4th 2009, 6:11am

Author: upgundecha

Accessing Excel Files

Thanks Guys for your help. Last night I tried using Database control to read the contents of an Excel file into JBGrid control and it worked. Jabaco Source 1 2 3 4 5 6 7 8 9 Dim myRes As ResultSet Dim myResMetaData As java#sql#ResultSetMetaData DataBase1.Connect("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=C:\WebDemo.xls;READONLY=true}") myRes = DataBase1.ExecuteStatement("SELECT * FROM [Login$]") myResMetaData = myRes.getMetaData JBGrid1.Cols = myResMetaData.getColumnCount For intCnt ...

Tuesday, February 3rd 2009, 1:34pm

Author: upgundecha

Accessing Excel Files

Hi, I want to access Excel files using Jabaco. One way is using COM object in following way (VB6): Set objExcel = CreateObject("Excel.Application") or adding reference and using Excel objects. Can this be done in Jabaco? Thanks in Advance, Unmesh

WoltLab Burning Board