how fix row spacing on excel activexobject spreadsheet. rows small of information display in worksheet. other references activexobject excel spreadsheets appreciated too.
$scope.exportstudents = function () { excel = new activexobject('excel.application'); excel.workbooks.add(); excel.application.visible = true; excel.activesheet.cells(1, 1).value = "user id"; excel.activesheet.cells(1, 2).value = "name"; excel.activesheet.cells(1, 3).value = "emergency phone"; excel.activesheet.cells(1, 4).value = "cell phone"; excel.activesheet.cells(1, 5).value = "provider"; excel.activesheet.cells(1, 6).value = "emergency phone"; excel.activesheet.cells(1, 7).value = "e-mail"; excel.activesheet.cells(1, 8).value = "hire date"; excel.activesheet.cells(1, 9).value = "grad date"; excel.activesheet.cells(1, 10).value = "major 1"; excel.activesheet.cells(1, 11).value = "major 2"; excel.activesheet.cells(1, 12).value = "school"; excel.activesheet.cells(1, 13).value = "active"; excel.activesheet.cells(1, 14).value = "admin status"; };
add:
excel.activesheet.cells.entirecolumn.autofit(); docs: object model reference (excel 2013 developer reference)
its simple translate recorded macros vba jscript.
Comments
Post a Comment