Subject: | Cut and Paste - Table into Excel -
| Date: | Sun, 29 Jul 2018 18:04:30 +1000
| From: | Robert MacMillan <macfam@bigpond.net.au>
| Newsgroups: | pnews.paradox-programming
|
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
|