Angular 电子表格组件 | ng-hub-ui-spreadsheet

可编辑的 Angular 电子表格,支持 Excel 键盘操作、矩形选区、可与 Excel 双向往返的剪贴板、冻结窗格和合并单元格。MIT 许可,无障碍,没有付费版。

交互式示例

探索实时示例,了解该库在常见 Angular 用例中的表现。

编辑与剪贴板

可编辑的表格

Product Units Unit price Total
M6 zinc-plated bolt12000.12144
M6 flat washer34000.04136
Self-locking nut8000.0972
Threaded rod, 1 m453.75168.75

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 复制粘贴

Meter January (kWh) February (kWh) Change
Warehouse1240.51188-52.5
Workshop890.25935.7545.5
Offices410402.5-7.5
Cold store3120.83260.4139.6

Select a range, copy it, and paste it into Excel. Or the other way round.

列类型,以及使用自定义编辑器

Task Status Due Start Billable Assignee
Site surveyDone2026-10-0208:30Ana Ruiz
CablingIn progress2026-10-0909:00Luis Prat
Patch panelNot started
HandoverOn hold

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.

用别名写,也用坐标写的公式

Item Units Price Discount Total VAT 21%
Steel bolt M64000.1204810.08
Washer12000.040.143.29.07
Hex nut8000.0907215.12
Anchor601.40.256313.23
Order total226.247.5

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.

自己画某一列的单元格:徽章与操作

Reference Customer State Total Sent Actions
INV-0412Ferretería SurPaid1240.5
RemindArchive
INV-0413Metalls PratPending890.25
RemindArchive
INV-0414Suministros MoraLate410
RemindArchive
INV-0415Bilbo ToolsPending3120.8
RemindArchive

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.

自己画某一列的表头:编辑按钮

Product PriceEdit Stock
Screw M40.121200
Washer 8 mm0.053400
Bolt M80.34560

Press Edit in the Price header: the column does not start moving.

把控件库接一次,而不是每列写一个模板

Subject Queue Severity
Card reader offlineField serviceHigh
Duplicate invoiceBillingNormal
Password reset loopSupportCritical
Old portal exportLegacy (closing)Low

Queue and Severity have no editor of their own. Open one and it is the house select, with its search box.

表格形态

冻结的行与列

Region Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Total276082892429391285802723626595272462859129392289142759526649
North400055155637425426382274349751835781474230212200
Levante563742542638227434975183578147423021220030344756
Centre263822743497518357814742302122003034475657835171
South349751835781474230212200303447565783517134822269
Islands578147423021220030344756578351713482226926484270
Portugal302122003034475657835171348222692648427056435506
France303447565783517134822269264842705643550639842477

Scroll sideways and down. The region column and the first row stay put, and the seam is drawn on the last frozen track.

合并的区块

Time Monday Tuesday Wednesday
09:00StandupStandupQuarterly review
10:00Design workshopSupport rota
11:00
12:00RetroOpenOpen

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.

一万行乘五十列,文档里只放着一屏

Meter Taken kWh Cost 00:00 00:30 01:00 01:30 02:00 02:30 03:00 03:30 04:00 04:30 05:00 05:30 06:00 06:30 07:00 07:30 08:00 08:30 09:00 09:30 10:00 10:30 11:00 11:30 12:00 12:30 13:00 13:30 14:00 14:30 15:00 15:30 16:00 16:30 17:00 17:30 18:00 18:30 19:00 19:30 20:00 20:30 21:00 21:30 22:00 22:30 23:00 23:30
Warehouse2026-01-011202044.65.25.76.26.56.8776.96.76.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.1
Workshop2026-01-01132.519.984.65.25.76.26.56.8776.96.76.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.13.5
Offices2026-01-01144.919.95.25.76.26.56.8776.96.76.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.13.52.9
Cold store2026-01-01156.919.785.76.26.56.8776.96.76.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.13.52.92.4
Yard2026-01-01168.519.616.26.56.8776.96.76.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.13.52.92.41.9
Warehouse2026-01-02179.319.396.56.8776.96.76.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.13.52.92.41.91.5
Workshop2026-01-02189.419.136.8776.96.76.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.13.52.92.41.91.51.2
Offices2026-01-02198.518.83776.96.76.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.13.52.92.41.91.51.21.1
Cold store2026-01-02206.618.4876.96.76.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.13.52.92.41.91.51.21.11
Yard2026-01-02213.618.16.96.76.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.13.52.92.41.91.51.21.111.1
Warehouse2026-01-03219.417.696.76.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.13.52.92.41.91.51.21.111.11.2
Workshop2026-01-0322417.246.465.554.43.83.22.72.21.71.41.1111.11.31.72.12.63.23.84.34.95.566.46.76.9776.86.66.25.85.24.74.13.52.92.41.91.51.21.111.11.21.5

10,000 rows and 52 columns. Scroll either way: the document holds a screenful at a time, and the first column stays put.

填充手柄,以及一步撤销整次拖拽

UndoRedo0 of 0 steps
Code Task Hours
INV-001Site survey8
INV-002Cabling16
Patch panel
Labelling
Handover

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.

调整列宽与重新排序,以及行重新排序

Reset the layoutNothing resized yet
Name Company Email City
Ana RuizFerretería Surana@ferreteriasur.esSevilla
Luis PratMetalls Pratluis@metallsprat.catGirona
Eva MoraSuministros Moraeva@sumora.esAlbacete
Jon DíazBilbo Toolsjon@bilbotools.eusBilbao

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.

状态与结构

每个单元格的保存状态

Tariff Price Margin
Standard420.18
Volume38.50.14
Partner350.11
Launch290.06
Written, not sent Saving Saved Failed Changed elsewhere

Edit a price. Anything ending in 9 fails on purpose, so you can see the error state.

单元格无法保存的文本会保留在屏幕上

Part Qty Price
M6 bolt12000.12
Wing nut12000.09
Washer24000.04
Hinge801.35
Save Every cell holds a value it can store.

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 lineAdd a noteAdd a column Remove the last column
Task Hours
Site survey
Cabling

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 fardescription · col-1

使用信号表单进行逐单元格校验

Product Units Unit price
M6 zinc-plated bolt12000.12
M6 flat washer34000.04
Self-locking nut8000.09
Submit Clear a product name or set units to 0, then leave the cell.

导出到 Excel 或 CSV,再导回来

Item Units Price Total
Steel bolt M64000.1248
Washer12000.0448
Hex nut8000.0972

Export it, open it in Excel, change a quantity, save it and bring it back.

单元格显示和打开的内容

可折叠的列组

Product Units Price Cost Margin
M6 bolt12000.120.070.05
Wing nut12000.090.060.03
Washer24000.040.020.02
Hex key402.51.70.8

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.

在标题下折叠的行组

Line Amount
Sales12000
Domestic8000
Export4000
Costs7000
Materials5000
Labour2000

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.

说明自己空在哪里的单元格

Product List price Discount
M6 bolt0.12
Wing nut0.09
Washer0.040.1
Hex key2.5

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.

带单位的数量,单位从列表中选择

Item Qty Price Discount Total
Site survey2 d48010 %864
Cabling16 h45720
Patch panel3 pcs12030 €330
Handover1300300

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.

可打开的单元格

Product SKU Price
M6 boltBOL-M60.12
Wing nutNUT-W40.09
WasherWSH-120.04
Hex keyKEY-52.5

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).

就地展开的行

Open the first orderNothing open
Customer Lines Total
Ferretería Sur3348
Metalls Prat1100
Suministros Mora2232