Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #3642

Re: Reading a spreadsheet

From Martin <spam@spam.spam>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Reading a spreadsheet
References <twfEr.165677$B64.54831@fx26.am4> <4fe1a29e$0$14713$5fc3050@news.tiscali.nl>
Message-ID <EClEr.181069$2H1.27217@fx15.am4> (permalink)
Date 2012-06-20 16:03 +0100

Show all headers | View raw


Thanks - I'll try this

Currently copy & paste works as does CSV import

I'll try this later

On 20/06/2012 11:15, John Martens wrote:
> plain VO can read from regular XLS
>
> it look something like this:
>
> Get the connection
> SELF:oHost := SQLConnection{}
> SELF:oHost:AccessMode := SQL_MODE_READ_ONLY
> cConnect := "Driver=Microsoft Excel Driver (*.xls);Dbq="+SELF:cFileNm
> lResult := SELF:oHost:DriverConnect(, SQL_DRIVER_COMPLETE_REQUIRED,
> cConnect)
>
> Read the data
> SELF:oSqlSelect := SQLSelect{"SELECT * FROM [CALLS$]",SELF:oHost}
>
> Get the data
> SELF:oSqlSelect:FIELDGET(4)
>
> Skip to next line
> SELF:oSqlSelect:Skip(1)
>
>
> Cheers,
> John
>
>
>
> Op 20-6-2012 10:06, Martin schreef:
>> Hello
>>
>> How easy is it to read the data out of a spreadsheet using VO?
>>
>> I can handle CSV trivially but want to see if I can avoid them having to
>> save as CSV in the spread sheet programme.
>>
>> Thanks
>>
>> Martin
>

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Reading a spreadsheet Martin <spam@spam.spam> - 2012-06-20 09:06 +0100
  Re: Reading a spreadsheet John Martens <adsl672100@tiscali.nl> - 2012-06-20 12:15 +0200
    Re: Reading a spreadsheet Martin <spam@spam.spam> - 2012-06-20 16:03 +0100
  Re: Reading a spreadsheet "Francesco F." <francescangeli.f.remove@remove.gmail.com> - 2012-06-21 07:49 +0200

csiph-web