luckysheetVue

LuckySheet Wrapper for vue 2

Features

• Open Form File
• Open From Url

Tested in (desktop)

• Edge
• Chrome
• Firefox

Installation

npm i luckysheetvue --save

props

| 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

LuckySheet Method Documents

| 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

LuckySheet Event Documents

| 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

LuckySheet Documents