Introduction

When processing .xlsx files in DSH Web, the common practice is to copy the file path, open an external spreadsheet tool, modify it, and then save. dsh-excel-panel puts “open, preview, edit, and save” steps into the right sidebar, suitable for scenarios where quick table processing is needed directly within the DSH Web interface. Below introduces its features, installation method, and typical usage.

What is this

dsh-excel-panel is a right sidebar plugin for DSH Web that runs within dsh-better-sidebar, used to directly preview, edit, and save .xlsx files. The maintainer is Melody-max114, and the license is MIT. The core problem it solves is: completing cell editing, style adjustments, formula preview, and worksheet operations within the DSH Web right sidebar and saving the results back to the original file.

Core Features

Cell Selection and Editing

  • Click to select a cell.
  • Double-click to edit cell text.
  • Drag or Shift+click to select a range.

Format Toolbar

You can adjust the following styles:

  • Font size
  • Bold, Italic, Underline
  • Align Left, Align Center, Align Right
  • Font Color
  • Background Color

Custom color selection supports the color palette for quick selection, RGB sliders, and HEX input.

Real-time Formula Preview

After entering a formula in the fx bar, you can see the calculation result. The listed formula capabilities include:

  • + - * / ^
  • Cell/Range references
  • SUM, ROUND, IF, MAX, MIN, AVERAGE, COUNT, ABS, INT, LEN, UPPER, LOWER

For example, you can enter:

=D2*0.15

Worksheet Operations

  • Merge or unmerge cells
  • Insert/Delete rows and columns
  • Drag to adjust column width/row height
  • Bottom Sheet bar and new worksheet
  • Right-click menu: Copy, Paste, Clear, Merge, Insert/Delete rows/columns

Save and Undo

  • Rebuilds the entire .xlsx upon saving to avoid gradual corruption of the stylesheet.
  • Format is not lost after multiple saves.
  • Prompts specific reasons when save fails.
  • Offers “Close the occupied program and retry” when the file is in use.
  • Ctrl+Z to undo.
  • Ctrl+Y or Ctrl+Shift+Z to redo.

Installation and Enablement

The plugin targets DSH Web. The dependency information declares:

  • dsh-better-sidebar: ^0.12.0
  • react: ^18.2.0
  • exceljs: ^4.4.0

Confirm that the DSH Web environment meets these dependency requirements before installing the plugin.

Common Installation Commands

dsh plugin --profile web add dsh-excel-panel

It can also be installed as an npm package in a project:

npm install dsh-excel-panel

If using a local directory, you can add it as a file dependency, for example:

dsh plugin --profile web add file:D:/apps/DP专武/dsh-excel-panel

If using a zip package, you can download it from GitHub Releases:

dsh-excel-panel-v0.6.1.zip

After decompressing, add it via the file dependency method.

After installation is complete, restart DSH Web.

Typical Usage

  1. Restart DSH Web.
  2. Open any .xlsx file in the right sidebar.
  3. Click to select a cell, double-click to edit text.
  4. Enter a formula in the top fx bar, for example:
=D2*0.15
  1. After selecting a range, use the format toolbar to batch adjust font, color, alignment, etc.
  2. Click “Save” in the top right corner to write back to the original file on disk.

Applicable Scenarios and Notes

Suitable for scenarios where .xlsx files are viewed and modified in the DSH Web right sidebar, especially when needing to adjust formats, input formulas, manage worksheets, and save directly back to the original file.

Notes:

  • The plugin runs with the permissions of the current dsh process.
  • You should check the source code and license before installing.
  • The license is MIT, allowing free use, modification, and distribution.
  • When a file is in use, you need to close the occupied program before retrying.
  • It depends on dsh-better-sidebar and react; confirm version requirements before installing.

Getting It

Community Plugin Directory Page:

https://www.skillhub.cn/plugins/Melody-max114/dsh-excel-panel

GitHub Repository:

https://github.com/Melody-max114/dsh-excel-panel