Skip to main content

· One min read
吴子

In version 2024.1.26, we support comparison between sheets, You can select sheets on the left or right to compare.

· One min read
吴子

Add Sql Search Model

ExcelReader has been updated with a SQL search mode that allows queries to be made based on multiple criteria at the same time.

Preview1

Preview2

Support Versions

Plugin VersionIDE Version
2021.3.22021.3 ~ 2021.3.2
2021.2.22021.2 ~ 2021.2.4
2021.1.22021.1 ~ 2021.1.3
2020.3.22020.3 ~ 2020.3.4
2020.2.22020.2 ~ 2020.2.4
2020.1.22020.1 ~ 2020.1.4

Usage

Open ExcelReader,Press Alt + Q or Click to enable Sql Search Model.

The first time you press /, it will display all the column names for the current table. After selecting the column name, column name= will be filled in automatically, and then enter to match the value you want. If there is more than one condition, you can enter / again. After the autofill is complete, enter the value you want to match. If you have more than one condition, do the same as above.

After selecting a column, when you press / again, it will not appear in the candidate list.

· One min read
吴子

At the beginning, the naming method of the version number was: a.b.c.

Version numberDescription
amajor version
bminor version
crevision

Later, due to Platform API compatibility (because I still want to support the old version), the version name was changed to correspond to the version of the IDE (only, major and minor versions).

E.g.

Plugin version 2020.1 version indicates support for IDE 2020.1.* Plugin version 2020.2 version indicates support for IDE 2020.2.* ...

Regarding revisions: Revisions are controlled by ExcelReader's own updates, and have nothing to do with the IDE's version.

E.g.

ExcelReader 2021.3.2 has nothing to do with IDE 2021.3.2. All that matters is major version 2021 and minor version 3.