首页spreadjs获取单行数据

spreadjs获取单行数据

时间: 2023-04-08 11:05:13 浏览: 139

使用大小写转换函数-处理单行的函数

使用大小写转换函数查出员工Blake的号码、名字、部门号 SQL> SELECT empno, ename, deptno 2 FROM emp 3 WHERE ename = 'blake'; no rows selected EMPNO ENAME DEPTNO --------- ---------- --------- 7698 BLAKE 30 SQL> SELECT empno, ename, deptno 2 FROM emp 3 WHERE ename = UPPER('blake'); Case Conversion Functions (continued) The slide example displays the employee number, name, and department number of employee BLAKE. The WHERE clause of the first SQL statement specifies the employee name as 'blake.' Since all the data in the EMP table is stored in uppercase, the name 'blake' does not find a match in the EMP table and as a result no rows are selected. The WHERE clause of the second SQL statement specifies that the employee name in the EMP table is compared to 'blake',converted to upper case. Since both the names are in uppercase now, a match is found and one row is selected. The WHERE clause can be rewritten in the following manner to produce the same result: The name in the output appears as it was stored in the database. To display the name with the first letter capitalized, use the INITCAP function in the SELECT statement. … WHERE ename = 'BLAKE' SQL> SELECT empno, INITCAP(ename), deptno 2 FROM emp 3 WHERE ename = UPPER('blake');

可以使用以下代码获取 SpreadJS 表格中的单行数据： var sheet = spread.getActiveSheet(); var row = sheet.getActiveRowIndex(); var rowData = sheet.getDataSource().getRow(row); 注意：以上代码仅适用于 SpreadJS 10 及以上版本。如果您使用的是早期版本，请查阅官方文档获取相应的代码。

阅读全文