Paradox Community

Items in pnews.paradox-programming

Subject:Re: Cut and Paste - Table into Excel -
Date:Sun, 29 Jul 2018 08:43:38 -0400
From:"Steven Green" <greens@diamondsg.com>
Newsgroups:pnews.paradox-programming
copytoclipboard will get it out of the table.. will copyfromclipboard paste 
it, too?


--

Steven Green
Myrtle Beach, South Carolina, USA

http://www.OasisTradingPost.com

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Robert MacMillan"  wrote in message 
news:5b5d7510$1@pnews.thedbcommunity.com...

The reason for asking this question is that I am moving data from a
Paradox Table into a very complicated Excel Spreadsheet. And Vladimirs
Excel Library with some extensions does it well but with some
performance issues.

I need to improve the performance and the Excel Sheet has a couple of
problems.

1. It recalculates every time something is added. So recalc is now off
and I have added to Vladimirs Library with a recalulate function and
then trigger that at the end of the load. So that works really well.

2. There is also a huge amount of formatting in this sheet as in colours
in cells and so on. And every time I transfer an item the spreadsheet
redoes all the formatting which is a PITA.

Interactively I can open the underlying table. Select the first field,
then the number of fields I want, not the total table,
<ctrl><Shift><Down arrow> which gets the data I want, <ctrl c> for copy,
move to the spreadsheet, <ctrl v> and all the information gets pasted in
one go.

How can I do that in code?

Thanks

Robert 


Copyright © 2004 thedbcommunity.com