Smartsheet C# API add row array below first row -


i'm writing c# code import data smartsheet. i'd leave dummy row first row, , add subsequent rows below that. cannot find syntax in documentation this. addrows method doesn't seem have way determine this. here code:

cell[] cellsa = new cell[]  {  new cell.addcellbuilder(sheet.columns[1].id, taskdata[i][1]).build()                        //summary ,new cell.addcellbuilder(sheet.columns[2].id, taskdata[i][2]).setstrict(false).build()         //startdate ,new cell.addcellbuilder(sheet.columns[3].id, taskdata[i][3]).setstrict(false).build()           //duedate ,new cell.addcellbuilder(sheet.columns[5].id, taskdata[i][4]).build()                        //estimated hrs. ,new cell.addcellbuilder(sheet.columns[6].id, taskdata[i][5]).build()                        //completion ,new cell.addcellbuilder(sheet.columns[7].id, taskdata[i][6]).build()                        //owner ,new cell.addcellbuilder(sheet.columns[8].id, taskdata[i][7]).build()                        //priority ,new cell.addcellbuilder(sheet.columns[9].id, taskdata[i][8]).build()                        //status ,new cell.addcellbuilder(sheet.columns[10].id, taskdata[i][9]).build()                        //category ,new cell.addcellbuilder(sheet.columns[11].id, screenurl + taskdata[i][0]).build()            };  // specify contents of first row. row rowa = new row.addrowbuilder(true, null, null, null, null).setcells(cellsa).build();  // add rows sheet. smartsheet.sheetresources.rowresources.addrows(sheetid, new row[] { rowa }); 

the key adding row below first row lies in line of code create new row - specifically, second parameter determining ?bool 'tobottom' property. example:

 // specify contents of first row.  row rowa = new row.addrowbuilder(null, true, null, null, null).setcells(cellsa).build(); 

Comments