1.6.5 • Published 10 months ago
luckysheetvue v1.6.5
luckysheetVue
LuckySheet Wrapper for vue 2
Features
- Open Form File
- Open From Url
Tested in (desktop)
- Edge
- Chrome
- Firefox
Installation
npm i luckysheetvue --saveprops
| Prop | Type | Description |
|---|---|---|
| url | String | Excel Url |
| file | String | Excel File |
| lang | String | set Ui Language |
| showInfoBar | Boolean | Show/Hide Info Bar |
| backUrl | String | Url Address For Back Button |
Method
| Method Name | Description |
|---|---|
| downloadExcel | Download Excel File |
| getCellValue | Get the value of the cell |
| setCellValue | Set the value of a cell |
| clearCell | Clear the contents of the specified cell of the specified worksheet |
| deleteCell | Delete the specified cell of the specified worksheet |
| setCellFormat | Set the properties of a cell |
| find | Find the specified content in a worksheet |
| replace | Find the specified content in a worksheet and replace it with new content |
| exitEditMode | Exit edit mode. After double-clicking the cell with the mouse, it will enter the cell editing mode |
| setHorizontalFrozen | Freeze row operation |
| setVerticalFrozen | Freeze column operation |
| setBothFrozen | Freeze rank operation |
| cancelFrozen | Cancel freeze operation |
| insertRow | Insert a blank line in the number line at the position of the row line |
| insertColumn | Insert a blank column in column number at the position of column column |
| deleteRow | Delete the specified row |
| deleteColumn | Delete the specified column |
| hideRow | Hide the specified row |
| hideColumn | Hide the specified column |
| showRow | Show the specified row |
| showColumn | Show the specified column |
| getRange | Returns an array of current selection objects, there may be multiple selections |
| getRangeWithFlatten | Returns an array representing the positions of all cells in the specified area |
| getRangeValuesWithFlatte | Returns an array of objects representing the contents of all cells in a specified range |
| getRangeAxis | Returns an array of coordinate strings corresponding to the current selection |
| getRangeValue | Returns the data of a two-dimensional array of cells in the specified range of |
| getRangeJson | Copy the data in the specified cell area and return the data in json format |
| getRangeDiagonal | Copy the data in the specified cell area |
| getRangeBoolean | Copy the data in the specified cell area |
| setRangeShow | Specify selection areas to be selected and choose whether to highlight or not |
| setRangeValue | Assign a cell array data to the specified area |
| setRangeFormat | Set the cell format of the specified range, generally used as a processing format |
| setRangeMerge | Set the merged cells for the worksheet with the specified subscript and the selected range |
| cancelRangeMerge | Unmerge cells in the selected range for the worksheet with the specified subscript |
| setRangeSort | For the worksheet of the specified subscript |
| setRangeSortMulti | For the worksheet of the specified subscript |
| setRangeConditionalFormatDefault | Conditional format |
| setRangeConditionalFormat | Conditional formatting rule |
| deleteRangeConditionalFormat | For the worksheet of the specified subscript |
| getAllSheets | Return all worksheet configurations |
| getLuckysheetfile | Returns a one-dimensional array luckysheetfile of all table data structures |
| setSheetAdd | Add a sheet and return the newly added worksheet object |
| setSheetMove | Specify the worksheet to move one position to the left or right, or specify subscript |
| showGridLines | Show the grid lines of the specified subscript worksheet |
| hideGridLines | Hide the grid lines of the specified subscript worksheet |
| setWorkbookName | Set workbook name |
| getWorkbookName | get workbook name |
| refreshFormula | Force refresh formula |
| refreshMenuButtonFocus | Refreshes the top status bar status of the specified cell |
| transToCellData | data => celldata, data two-dimensional array data is converted into a one-dimensional array |
| toJson | The exported json string can be directly |
Event
| Event Name | Description |
|---|---|
| updated | The method executed after each operation is updated |
| cellEditBefore | Triggered before entering the cell editing mode |
| cellUpdateBefore | Triggered before updating this cell value |
| cellUpdated | Triggered after updating this cell |
| cellRenderBefore | Triggered before the cell is rendered |
| cellRenderAfter | Triggered after the cell rendering ends |
| cellAllRenderBefore | The method executed before all cells are rendered |
| rowTitleCellRenderBefore | Triggered before the row header cell is rendered |
| rowTitleCellRenderAfter | Triggered after the row header cell is rendered |
| columnTitleCellRenderBefore | Triggered before the column header cell is rendered |
| columnTitleCellRenderAfter | Triggered after the column header cell is rendered |
| rangeSelect | Frame selection or trigger after setting selection |
| rangeMoveBefore | Before moving the selection |
| rangeMoveAfter | After moving the selection |
| rangeEditBefore | Before the selection is modified |
| rangeEditAfter | After the selection is modified |
| rangeCopyBefore | Before copying selection |
| rangeCopyAfter | After copying selection |
| rangePasteBefore | Before pasting the selection |
| rangePasteAfter | After pasting the selection |
| rangeCutBefore | Before selection cut |
| rangeCutAfter | After selection cut |
| rangeDeleteBefore | Before the selection is deleted |
| rangeDeleteAfter | After the selection is deleted |
| rangeClearBefore | Before the selection is cleared |
| rangeClearAfter | After the selection is cleared |
| rangePullBefore | Before selection drop down |
| rangePullAfter | After selection drop down |
| workbookCreateBefore | Triggered before the worksheet is created |
| workbookCreateAfter | Triggered after the worksheet is created |
| workbookDestroyBefore | Triggered before the workbook is destroyed |
| workbookDestroyAfter | Triggered after the workbook is destroyed |
| resized | After resize is executed |
| imageInsertBefore | Before the picture is inserted |
| imageInsertAfter | After the picture is inserted |
| imageUpdateBefore | Before the picture is modified |
| imageUpdateAfter | After the picture is modified |
| imageDeleteBefore | Before the picture is deleted |
| imageDeleteAfter | After the picture is deleted |
| commentInsertBefore | Before inserting comments |
| commentInsertAfter | After inserting comments |
| commentDeleteBefore | Before deleting comments |
| commentDeleteAfter | After deleting comments |
| commentUpdateBefore | Before modifying comments |
| commentUpdateAfter | After modifying comments |
| pivotTableEditBefore | Before modifying the PivotTable, operations such as dragging fields, etc |
| pivotTableEditAfter | After modifying the PivotTable, operations such as dragging fields, etc |
| frozenCreateBefore | Before setting freeze |
| frozenCreateAfter | After setting freeze |
| frozenCancelBefore | Before unfreezing |
| frozenCancelAfter | After unfreezing |
| onTogglePager | Click the page button to call back the function, return the current page number |
Usage
import LuckySheet from "luckysheetVue";<lucky-sheet
url=""
show-info-bar
backUrl="/"
lang="en"
@updated="onUpdateData"
/>More information
1.6.5
10 months ago
1.6.4
10 months ago
1.6.3
10 months ago
1.6.2
10 months ago
1.6.1
10 months ago
1.6.0
10 months ago
1.5.0
10 months ago
1.4.2
10 months ago
1.4.1
10 months ago
1.4.0
10 months ago
1.3.1
10 months ago
1.3.0
10 months ago
1.2.3
10 months ago
1.2.2
10 months ago
1.2.0
10 months ago
1.1.0
10 months ago
1.0.1
10 months ago
1.0.0
10 months ago