What's new in ExcelReader 2021.3.2
Preview
ExcelReader has updated the SQL search mode, which can query based on multiple conditions at the same time.
Supported Versions
| Plugin Version | IDE Version |
|---|---|
| 2021.3.2 | 2021.3 ~ 2021.3.2 |
| 2021.2.2 | 2021.2 ~ 2021.2.4 |
| 2021.1.2 | 2021.1 ~ 2021.1.3 |
| 2020.3.2 | 2020.3 ~ 2020.3.4 |
| 2020.2.2 | 2020.2 ~ 2020.2.4 |
| 2020.1.2 | 2020.1 ~ 2020.1.4 |
Usage
After opening ExcelReader, press Alt + Q or click 
in the ExcelReader toolbar can be turned on.
Press / for the first time, all column names of the current table will be displayed. After selecting a column name,
it will be automatically filled with \column name=\, and then enter
match the value you wanted. If there are multiple conditions, you can
enter / again, and after the auto-fill is complete, enter the matching value you wanted.
There are more conditions for query the operation remains as above.
After a column has been selected, when you press / again,
it will not appear in the candidate list.