Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I created a crosstab report and it

Status
Not open for further replies.

gnamachivayam

Programmer
Oct 15, 2001
18
US
I created a crosstab report and it worked fine, but when I tried to save it as an Excel file, the headings (which is a column value), are not stored as I see in the datawindow output. In the excel file, I could see only a_1, a_2, a_3 as column headings instead of data.

Please help!

Ganesh
 
integer ret
ret=dw_stat.SaveAs ( "C:\StatCode.xls", excel!, true )

Is the code like this one?
 
The piece of code you specified is of no use. Rather I tried with

dw_1.SaveAs("c:\s.xls", HTMLTABLE! TRUE) and it works fine and I get the columns as I expected, but if any row values contain only numbers, then it is saved as trimmed numbers, like 00033 (string) is saved as 33 (number).

I am using PowerBuilder 7.0 and Oracle 8.1
Can you help.
 
U could do this by means of OLE Object.
Identify the column say E1:E1
i.e,
lole_Sheet.Range("E1:E1").Select

And then modify the format of the column i.e,

EntireColumn.Format.custom = ' Format ' ( 000)


This should work


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top