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
Post a Comment