PROGRAM-14

PROGRAM TO ADD COLUMN TO NEW SHEET ADDED
Set cds=datatable.AddSheet("cities")
Set cnp=cds.addparameter("cityname","blr")
For i=2 to 4
x=inputbox("enter city name")
cnp.valuebyrow(i)=x
Next
Set cnp2=cds.addparameter("state","kna")
For j=2 to 4
y=inputbox("enter state name")
cnp2.valuebyrow(j)=y
next
datatable.ExportSheet "E:\satya\amul.xls","cities"