Angular 电子表格组件 | ng-hub-ui-spreadsheet
可编辑的 Angular 电子表格,支持 Excel 键盘操作、矩形选区、可与 Excel 双向往返的剪贴板、冻结窗格和合并单元格。MIT 许可,无障碍,没有付费版。
交互式示例
探索实时示例,了解该库在常见 Angular 用例中的表现。
编辑与剪贴板
可编辑的表格
Click a cell and type, or press F2 to edit keeping the value. Enter commits and drops a row, Tab commits and moves right. Drag to select a block, and hold Ctrl (Cmd) while clicking to pick a second one somewhere else.
与 Excel 复制粘贴
Select a range, copy it, and paste it into Excel. Or the other way round.
列类型,以及使用自定义编辑器
A click picks a cell; a double click, F2 or simply typing opens it. Open Status for a list, Due for a date and Assignee for a searchable hub-select supplied by this page; Billable takes one click on its box. Start is a time field supplied by this page too: Enter, Tab or clicking away keeps what you typed, Escape gives it up. Hover an empty Due or Assignee cell to see its hint — and the Patch panel row's Due carries one of its own, because that cell is waiting on the cabling rather than on a date format.
用别名写,也用坐标写的公式
Change a quantity and the totals follow. Open a Total cell to see the formula, and the last row to see a column added up.
自己画某一列的单元格:徽章与操作
Pick a row and use the actions at the end. Copy the State column into a spreadsheet: what travels is paid, not the badge. The box in the Sent header ticks every order, or clears them all. Rest on the late total, or reach it with the keyboard, to read its note.
自己画某一列的表头:编辑按钮
Press Edit in the Price header: the column does not start moving.
把控件库接一次,而不是每列写一个模板
Queue and Severity have no editor of their own. Open one and it is the house select, with its search box.
表格形态
冻结的行与列
Scroll sideways and down. The region column and the first row stay put, and the seam is drawn on the last frozen track.
合并的区块
The Monday workshop spans two hours, and Wednesday's review spans three. Arrow into one, then try selecting only part of it. Select a rectangle and right-click to put it together, or right-click a block to take it apart.
一万行乘五十列,文档里只放着一屏
10,000 rows and 52 columns. Scroll either way: the document holds a screenful at a time, and the first column stays put.
填充手柄,以及一步撤销整次拖拽
Select the two codes, then drag the corner square down. Or select a cell and the ones below it and press Ctrl+D (Cmd+D on a Mac) to copy it down. Undo with Ctrl+Z.
调整列宽与重新排序,以及行重新排序
Drag the right edge of a header to widen it. Hover a row or a column and drag the grip that appears to move it; a header can be dragged by itself too. From the keyboard, Alt+Shift with the up or down arrow moves the row the cursor is on.
状态与结构
每个单元格的保存状态
Edit a price. Anything ending in 9 fails on purpose, so you can see the error state.
单元格无法保存的文本会保留在屏幕上
Type 7x into a Qty or a Price, then click Save or anywhere outside the sheet. The text stays, ringed, and Save waits. Open the cell to correct it, press Escape there to give it up, or right-click its row and delete it.
增删行与列
Add a column, remove it, add another: the alias never comes back.
Add a line and the cursor is already on it: start typing. Add a note and its field is already open. Copy a few lines from anywhere and paste them on the last one, and the sheet asks for the rows it runs past before it fills them.
Aliases handed out so far
description · col-1使用信号表单进行逐单元格校验
导出到 Excel 或 CSV,再导回来
Export it, open it in Excel, change a quantity, save it and bring it back.
单元格显示和打开的内容
可折叠的列组
Cost and Margin are one group. Press the small − just above the Cost header to fold them away, and the + that takes its place to bring them back. Right now they are in view.
在标题下折叠的行组
Each heading has its lines under it. Press the − at the leading edge of a heading to fold its lines away, and the + that takes its place to bring them back. Everything is in view.
说明自己空在哪里的单元格
Every discount is empty. Hover one: most say no discount — the column's own hint — but the line under agreement says what it is really empty of, because that cell carries a hint of its own.
带单位的数量,单位从列表中选择
Press a unit or a % to choose another, or open the list from the cell with Alt+↓. A copied quantity goes out as 2 d; pasting 15 € into a discount changes both parts.
可打开的单元格
Aim at a name with prices behind it and press Enter, or at a price with an arrow and press Alt+Enter (Option+Enter on a Mac).
就地展开的行