Skip to main content

Quick Start

Usage​

The base usage can see ExcelReader docs

Data modification​

There are generally three formats of data: Date Format, Normal Text, and Formula.

Date Format​

When modifying the date format: the new value written must conform to the standard date format, otherwise the writing will fail and the original value will be restored. That is: the edit was unsuccessful.

DescEditDate

Normal Text​

Normal text data can be written directly.

Formula​

For formulas, modification will trigger recalculation, and the final value is the value calculated by the tool formula, not the actual written value.

For example: The value of cell A1 is: 256, the value of cell A2 is 512, the type of cell A3 is the formula: SUM(A1:A2). Under normal circumstances, the value of cell A3 is: 768. At this point, we modify the value of cell A3 to 1000, which will trigger the formula to recalculate. That is to say, without modifying cell A1 and cell A2, the calculated result of cell A3 is still 768. Suppose you modify cell A1 to 1000 before modifying cell A3, then when you modify cell A3, the calculated value should be: 1512, because A3(1512) = A1(1000) + A2(512).

DescEditFormula

File comparison​

The csv files can only be compared with csv files, xls files and xlsx files can be compared with each other arbitrarily

Excel Merge Function​

File Merge supports three modes: Merge Single Row, Merge Multiple Rows, Merge All Rows. Data writing rules: If you want to write the data on the left to the right, click . In turn, if you want to write the data on the right to the left, click . The direction of the arrow vividly illustrates the direction of the data.

Merge Single Row​

To merge a single line, you only need to click the or of the current line.

Merge Multiple Rows​

To merge the selected rows, just select the data on the left or right and click the merge button on the toolbar.

Merge All Rows​

To merge all rows, simply click the merge button on the toolbar to merge. But you cannot select multiple rows of data before the operation. That is to say, if you select multiple rows (the number of selected rows is greater than 1 row), it will be processed as multi-row merge, and not all rows will be merged.