websheet

What is WEBSHEET Websheet is a pure front-end xlsx file display control developed based on HTML5 CANVAS and JAVASCRIPT. This control focuses on page display and mainly implements functions including file import/export, text display, formatted text, merged cells, borders, background colors, setting row/column width/height, hiding rows/columns, view locking, basic tables, undo/redo, keyboard shortcuts, formula parsing and calculation. It supports custom functions, cell display/editing, and right-click menu customization. 1. Getting Started If you're new to Websheet, you can start with the following articles. HTML Getting Started VUE Getting Started Open File Export File Currently supported shortcuts Shortcut Function Shortcut Function Ctrl+O Open new file Ctrl+X Cut Ctrl+C Copy Ctrl+P Paste Ctrl+Z Undo Ctrl+Y Redo Ctrl+A Select All Delete Clear cell value Ctrl+Shitf+PageDown Activate next sheet Ctrl+Shitf+PageUp Activate previous sheet Ctrl+↑ View to sheet start row Ctrl+↓ View to sheet end row Ctrl+← View to sheet start col Ctrl+→ View to sheet end col Ctrl+E Download file Ctrl+S Download file Enter Confirm edit, move next Alt+Wheel Move table left/right 2. Intermediate If you're already familiar with the control and want to dynamically control its functions using scripts. Cells Formatting Columns & Rows Sheet Operations View Freeze Name Management Table Management Editor Print Currently supported common functions: Function Description Example SUM Sum function Sum values from A1 to C1: SUM(A1:C1) IF Conditional function IF(10>5,"Yes","No") CONCATENATE Concatenation function CONCATENATE(text1,text2,[text3],...) NOW Current date/time function Reference: DateTime Formatting TRUNC Truncation function TRUNC(3.141593) // returns 3 More Functions → Currently supported common events: Event Description Binding ActiveCellChange Triggered when active cell changes Event Binding SheetChange Triggered when active sheet changes Event Binding CellValueChage Triggered when cell value changes Event Binding RowChange Triggered when rows added/deleted Event Binding ColChange Triggered when columns added/deleted Event Binding DocumentChange Triggered when file loading completes Event Binding More Events → 3. Advanced This section allows you to extend Websheet's functionality. Custom Functions Custom Display Controls Custom Right-Click Menu 4. Online Code All demo code and display address: Demo 5. About Copyright Commercial use is prohibited without permission. 6. Contact Us Email: [email protected]