Saving Excel Format when Copying Data from a Datawindow...
I am tasked with adding functionality to automate the maintenance of a
formatted Excel Spreadsheet. Data will be updated in a PowerBuilder window,
and the user wants a formatted Excel Spreadsheet to reflect the changes
without losing or screwing up the formatting of the spreadsheet. The
formatting consists of variable column headers (data dependent) and
variations in the color of rows and columns. Anyone have a clue as to how
this can be done? I'm stumped!!! It seems like there should be a way to do
this. I REALLY appreciate any help!!!
...How to copy data from one excel file to other excel file
I have two excel file (Ex1 and Ex2), both have same template (headers) and data will be populated from the dataset. Upto this step its works fine.
My question : How to copy the data form 6th row to last row of "Ex2" and paste it into the "Ex1" after the last row in Ex1.
Have a look here:
For VB - http://support.microsoft.com/kb/306022
For C# - http://support.microsoft.com/kb/306023/
Visoft, Inc - Home | Blogs Latest Blog Post: ASP.NET 4.0 AJAX Preview 4 - Client Templates...data from datawindow to excel
I need to get data from a datawindow to pre-formated excel spreadsheets.
Does anyone have a great solution to this problem?
Should I use ole or dde or some other kind of coding solution?
Sample code is much appreciated
You must use ole.
Look online books for sample - it's easy and work!
Chris Edwards wrote:
> Please help!
> I need to get data from a datawindow to pre-formated excel spreadsheets.
> Does anyone have a great solution to this problem?
> Should I use ole or dde or some other kind of coding solution?
...Excel data into Datawindow
Is there a PB function to import an excel file into a datawindow or any OLE
to do that?
You could either save the Excel file as a CSV file and use the ImportFile
( ) method to bring the data in, or you could create an ODBC connection to
the Excel file and use SQL to get the data. OLE methods area also available,
but ends up being just a bit more code to maintain.
"A Chan" <AChan> wrote in message news:40e8a15b@forums-2-dub...
> Is there a PB function to import an excel file into a datawindow or any
> to do that?
&...Datawindow objects data copying
How can we copy data from one datawindow object of free form
presentation style to another datawindow object that has more number of
fields than latter ?
To be more clear
1. "dwo_one" has 10 fields.
2. "dwo_two" has 20 fields.
I need to copy data from datawindow object "dwo_one" to "dwo_two".
Does presentation style of the datawindow objects has any impact on the
data copying ?
On Tue, 14 Mar 2000 22:11:25 +0530, Veena Madhavi
>How can we copy data from one datawi...to copy datawindow into excel as it is in the same layout
Please anybody can advice me to export the tree view
datawindow as with same layout into excel.I tried with
DW2Excel but it is not work with treeview datawindow. Any
suggestion would be appreciate.
You can use OLE to create a real excel sheet, and add data, formatting the
cells how you like. It's a lot of work, but you can puppet Excel to send it
the commands. Use macros to discover the commands, then translate to PB.
"Polachan" wrote in message news:firstname.lastname@example.org...
> Please anybody can advice me to export the tree view
...Retrieve Data from Excel into a Datawindow
I have created an OLE object that opens an Excel worksheet,
the user then adds data to the worksheet. I'm trying to
pull data from a cell on the Excel worksheet, into a local
variable in Powebuilder. It isn't pulling the information
from Excel. Any suggestions?
I've put an example on CodeXchange under PowerBuilder, ActiveX/OLE that
demonstrates how to get data from Excel into PB.
Terry Dykstra (TeamSybase)
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit...Copy Datawindow Data to a Structure
I have seen an example of copying data of a datawindow to a Structure, but I
don't remember the syntax. CAn you help me?
I have tried:
dw_1.object.data = istr_x
The above works but dw_1 contains more than 1 row, so I tried
structrue_x istr_x[ ]
dw_1.object.data = istr_x
Then I got a systemerro.
PB 5 16Bit
Your subject gives the impression that you want to copy the data FROM the
datawindow TO a structure. But your sample script does the other way round.
Otherwise you are on the right track. That...Copy blobcolumn data between datawindows
I need to copy the data in a blobcolumn to another blobcolumn in another
datawindow (which contains another table with different columns - but it
does have a blobcolumn).
I do not find anything in the documentation about it. And the
Sybase.DataWindow.GraphicObjectBlobColumn class unfortunately does NOT have
an "ObjectData" property...
Does anyone have an idea on how to do it (without having to first save the
target row in the target datawindow to the database) ?
Well, GraphicObjectBlobColumn probably wouldn't...Accessing Excel data from PowerBuilder
I am trying to access data in an Excel spreadsheet from
PowerBuilder. After reviewing the PB documentation and a
number of posts from these newsgroups, I figured that I can
do it in one of three ways:
1. Save As text from the Excel file, then use a method like
ImportFile to bring the data into PB;
2. Use OLE to access the Excel file;
3. Use ODBC to access the Excel file.
(1) doesn't meet my requirements (I need to be able to bring
in the data directly from Excel, without any intermediate
steps), so that left me with options (2) and (3) (OLE or
I should say a bi...Import Data From Excel to Datawindow
I'm using Powerbuilder Ver. 9
I want to import data from excel sheet to datawindow at run
time by creating the datawindow depending on excel cells for
the column name and data type
Could any one help me how can i do it
With my best regards
You can create an ODBC profile that uses your Excel spreadsheet as the
"database". Once that is created, PowerBuilder sees it as just another
database connection, and you can create datawindows using that datasource.
<Ahmad Alhowaimel> wrote in message
...importing excel data into a datawindow
I'm trying to import data from an excel file that contains 20 columns and
about 25 rows. However, some of the columns contain alphabetic data that
contains several lines of text. Therefore, when I save the file as a tab
delimited text file it causes problems when importing to the datawindow.
The datawindow thinks that the column data, which gets word-wrapped, is
several different records when in fact it is only one. By the way I am
using PB 5.
PB looks for tabs and CRs. It shouldn't care about wrapping, which is just a
visual feature of an editor anyway. On wr...Copying Data between DW and CrosstabDW
i face this problem:
I have a DW1 with external DataSource.
This DW1 gets his Data from another DW2
based on some selections that the User can do.
DW2 is based on a select. This works fine.
So the Structure of DW1 and DW2 are equal.
Now i want to copy (sharing is impossible) the Data of DW1 - the local DW -
with a crosstab DW based on the same select than DW2.
Is this possible ?
How can i do this ?
DB: Oracle 8.1.7.
please help a newbie
dw_1.Object.DataWindow.Data = dw_2.Object.DataWindow.Data
...Copy data from Dynamic datawindow
I have a datawindow displaying data based on dynamic SQL's entered by users
based on this code:
new_syntax = sqlca0.SyntaxFromSQL(new_sql, &
However, when the data displayed in the datawindow, I can not copy and paste
the data into, say notepad, etc...
How can I change that to be able to highlight bunch of rows and columns and
then copy them?
Thanks for any help.
if you want to copy a selection of data, you'll need to compose it into
a string (eg. tab-...