Use toArray() method to create a copy of your first row
Then use fromArray 1,999 times to populate the additional 1,999 rows.... at least you don't have to do it cell by cell
Thank you a lot for replying!
Actually,what i am doing is to load an Excel.xls and read some strings from Mysql ,and set these strings to the DropDown value of some cells using method 'setFormula1'.
If i set the DropDown value of some cells of the first row of a sheet,then i use the toArray() method to make an array,then i make a new 2D array with 2000 rows copying the former array with just one row.
I then use the method FromArray() method to set the sheet 'sheet1'.
If i do these above,will the cells of the 2000 rows of sheet 'sheet1' all have the DropDown value ?
I am waiting for ur help,thanks again !