how to put a table in the clipboard

Moderator: Rathinagiri

User avatar
mol
Posts: 3409
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 268 times
Been thanked: 173 times
Contact:

Re: how to put a table in the clipboard

Post by mol »

esgici wrote:
mol wrote:You can separate cells by chr(9) and end rows with chr(13)+chr(10)
Such a prepared string you should paste to clipboard:
System.Clipboard := cClipboard
Hi Mol

As far as I know you are an expert on working with Excel files :arrow:

My question is : which method is the best for import / export Excel files ?

Better : would you give a SSW sample ?

Thanks in advance :)
I don't feel like an Excel expert :lol: I'm only blind man walking through M$ bush :roll:
I'll try to prepare such a sample with Excel and LibreOffice Calc.

User avatar
esgici
Posts: 4538
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 410 times
Been thanked: 118 times
Contact:

Post by esgici »

mol wrote: I don't feel like an Excel expert :lol: I'm only blind man walking through M$ bush :roll:
As previously mentioned, you know better than me, then you are my teacher :arrow:
mol wrote:I'll try to prepare such a sample with Excel and LibreOffice Calc.
Thanks :)

I'll wait eagerly.

Please English; identifiers ( variable, field, func/proc ) names and comments.

Regards
Viva INTERNATIONAL HMG :D

User avatar
esgici
Posts: 4538
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 410 times
Been thanked: 118 times
Contact:

Post by esgici »

mol wrote:...
I'll try to prepare such a sample with Excel and LibreOffice Calc.
esgici wrote:I'll wait eagerly.
Still waiting ... :)

TIA
Viva INTERNATIONAL HMG :D

User avatar
mol
Posts: 3409
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 268 times
Been thanked: 173 times
Contact:

Post by mol »

Sorry for delay, but I have very small time to use computer at the weekend .
I'm watching new posts via tablet only.
I was fightint with excel at friday, too, so, I'm fresh in this matter :-)

User avatar
esgici
Posts: 4538
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 410 times
Been thanked: 118 times
Contact:

Post by esgici »

mol wrote:Sorry for delay, but I have very small time to use computer at the weekend .
I'm watching new posts via tablet only.
I was fightint with excel at friday, too, so, I'm fresh in this matter :-)
OK friend, no problem :arrow:

TIA
Viva INTERNATIONAL HMG :D

User avatar
Pablo César
Posts: 4059
Joined: Wed Sep 08, 2010 1:18 pm
Location: Curitiba - Brasil
Has thanked: 100 times
Been thanked: 182 times

Post by Pablo César »

dragancesu wrote:I saw a program ok but I need something different
..
HMG in the windows world, and as I understand Clipboard is a powerful system, other programs to use so I thought I take this opportunity

Often faced with the problem of data transmission
Hi Dragan,

I've just remember about you asking something for data transfer. And I found recently these internal HMG functions:
GetData() and SendData( cDest , Data )

These are located at C:\hmg.3.4.0\SOURCE\h_controlmisc.prg

One example you can find in this topic: viewtopic.php?p=40056#p40056 (already adapted to HMG).

I hope to be helpful for you.
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein

Post Reply