Execl Border

[sunil]

Pls help me to drown the borders for merge cell in excel sheet using progress command.

 

[YOSANTO]

merge cell in excel sheet using progress command.???? I don't think so ..

i've ever dowload records from database to excell file ...
u can control all format of your result that u want by "generate html script by progress".

the way is :
def var cString as character.

assign cString = "c:\yourfilename.xls" no-error. /* if u're using windows */

output to value(cString).
put "<table border="1">".
put "<tr>".
put "<td>".
put "field A".
put "</td>".

put "<td>".
put "field B".
put "</td>".
put "</tr>.

for each tablename no-lock :
put "<tr>".
put "<td>".
put tablename.fieldname
put "</td>".

put "<td>".
put tablename.fieldname
put "</td>".
put "</tr>.
end.
put "<table>".
end.

ok ...


thx

 

[YOSANTO]

merge cell in excel sheet using progress command.???? I don't think so ..

i've ever dowload records from database to excell file ...
u can control all format of your result that u want by "generate html script by progress".

the way is :
def var cString as character.

assign cString = "c:\yourfilename.xls" no-error. /* if u're using windows */

output to value(cString).
put "<table border="1">".
put "<tr>".
put "<td>".
put "field A".
put "</td>".

put "<td>".
put "field B".
put "</td>".
put "</tr>.

for each tablename no-lock :
put "<tr>".
put "<td>".
put tablename.fieldname
put "</td>".

put "<td>".
put tablename.fieldname
put "</td>".
put "</tr>.
end.

put "<table>".
output close.
end.

ok ...


thx

 

[lord_icon]

Macro

Can you not create a macro in Excel, then simply execute that from within Progress?
Use the template method, for creating a macro in excel directly. Save that file as your template, then input your data from Progress in to that controlled file. Forwhich you can then call the macro that you have defined and created previousley (which is why you are using a template) .