Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #3642
| 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 |
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
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