PROGRAM-13

PROGRAM TO ADD ONE EXCEL SHEET TO DATA TABLE AND EXPORT IT
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
wait(2)
Next
datatable.ExportSheet "E:\satya\amul.xls","cities"