Go Back   Rhinocerus > Newsgroup > Newsgroup comp.lang.* 2 > Newsgroup comp.lang.clarion

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 03-20-2012, 06:25 PM
EMoreno
Guest
 
Posts: n/a
Default Clarion To Exel

Hi there.

Im trying to send some data to EXCEL.
I dont want to send the data column by column, I'm trying to send the
full row.
I build a string variable with all the data fields separated by a TAB

but when I put it in excel puts in a single column

Clear(LOC:Copy)
LOC:Copy = Clip(QRataA) & '<9>' & Clip(QRataB) & '<9>' &
Clip(QRataC)

?obj_ole_exc{'Cells(' & LOC:Renglon & ', 1).Value'} = Clip(LOC:Copy)


does anybody has something like this ?
Or wich the best way to send a LOT of data to excel.

thanks in advance
Reply With Quote
Alt Today
Advertising
 
and become member of Rhinocerus
Standard Sponsored Links

  #2 (permalink)  
Old 03-21-2012, 08:05 AM
Shandin
Guest
 
Posts: n/a
Default Re: Clarion To Exel

On 20 , 20:25, EMoreno <emoren...@yahoo.com> wrote:
> Hi there.
>
> Im trying to send some data to EXCEL.
>

Hi.
Find on Internet free SoftMasters Office templates (for word, Excel
and Outlook).
Reply With Quote
  #3 (permalink)  
Old 03-21-2012, 04:15 PM
EMoreno
Guest
 
Posts: n/a
Default Re: Clarion To Exel

On 21 mar, 03:05, Shandin <sandi...@yahoo.com> wrote:
> On 20 , 20:25, EMoreno <emoren...@yahoo.com> wrote:> Hi there.
>
> > Im trying to send some data to EXCEL.

>
> Hi.
> Find on Internet free SoftMasters Office templates (for word, Excel
> and Outlook).


Hi.
I already have those templates, and what it does not like me is that
sends data column by column.
I want to send the whole line.

Thanks
Reply With Quote
  #4 (permalink)  
Old 03-21-2012, 07:54 PM
Jim
Guest
 
Posts: n/a
Default Re: Clarion To Exel

Try easyExcel form ingasoftplus

On 3/21/2012 11:15 AM, EMoreno wrote:
> On 21 mar, 03:05, Shandin<sandi...@yahoo.com> wrote:
>> On 20 , 20:25, EMoreno<emoren...@yahoo.com> wrote:> Hi there.
>>
>>> Im trying to send some data to EXCEL.

>> Hi.
>> Find on Internet free SoftMasters Office templates (for word, Excel
>> and Outlook).

> Hi.
> I already have those templates, and what it does not like me is that
> sends data column by column.
> I want to send the whole line.
>
> Thanks

Reply With Quote
  #5 (permalink)  
Old 03-23-2012, 06:59 AM
Shandin
Guest
 
Posts: n/a
Default Re: Clarion To Exel

On 21 мар, 21:54, Jim <j...@mindspring.com> wrote:
> Try easyExcel form ingasoftplus
>
> On 3/21/2012 11:15 AM, EMoreno wrote:
>
>
>
> > On 21 mar, 03:05, Shandin<sandi...@yahoo.com> *wrote:
> >> On 20 ÜÐ*, 20:25, EMoreno<emoren...@yahoo.com> *wrote:> *Hi there.

>
> >>> Im trying to send some data to EXCEL.
> >> Hi.
> >> Find on Internet free SoftMasters Office templates (for word, Excel
> >> and Outlook).

> > Hi.
> > I already have those templates, and what it does not like me is that
> > sends data column by column.
> > I want to send the whole line.

>
> > Thanks- Сакриј наведени текст -


Try to send data to BASIC (or maybe DOS) file and try to open it with
excel, with TAB as a delimiter.
Reply With Quote
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




All times are GMT. The time now is 11:09 AM.


Copyright ©2009

LinkBacks Enabled by vBSEO 3.3.0 RC2 © 2009, Crawlability, Inc.