Filter

[SerPivas]

Hi!
i need create filter, which contains part of the text.
for example
i need all value in row, which contain,or start with "sr"
sr031239,sr5949345,sr123125 ....
but i can't do this.
help pls

[William.Zhang]

Hello,

Thanks for your inquiry.
To help us further investigate your issue, please provide us with your excel file, you can upload it here as an attachment or send it to this email address: support@e-iceblue.com. Thank you in advance.

Sincerely,
William
E-iceblue support team

[SerPivas]

Unfortunately, i can't do that
cuz this file from my work
it's forbidden.

[William.Zhang]

Hello,

Thanks for your reply.
Sorry, if you cannot provide the documents, it will be difficult for us to further investigate. You can remove key information from the document and send it to this email: support@e-iceblue.com. We will keep your documents confidential. Thank you for your understanding.

Sincerely,
William
E-iceblue support team

[SerPivas]

My bad
I mean column, not row
Sorry
Some value in column
Start with "sr01-....."
I need filter shows all value
Which start with "sr"

I can't remove key information
If i do that
The document will be empty

[William.Zhang]

Hello,

Thanks for your reply.
Sorry, regarding the issue you mentioned, we cannot further investigate without the source file.Could you please simulate a document based on your source file and provide it to us? Thanks for your understanding.

Sincerely,
William
E-iceblue support team

[SerPivas]

Книга2.7z

(6.03 KiB) Downloaded 373 times

[William.Zhang]

Hello,

Thanks for your file.
Please refer to the following code to filter cells starting with "sr", If you have any questions, please feel free to write to us at any time.

Code: Select all

Workbook workbook = new Workbook();;
workbook.loadFromFile("нига2.xlsx");
//Get the first sheet
Worksheet sheet = workbook.getWorksheets().get(0);
// Filter cells data which strat with "sr"
sheet.getAutoFilters().setRange(sheet.getCellRange("A1:A9"));
FilterColumn filterColumn = sheet.getAutoFilters().get(0);
sheet.getAutoFilters().customFilter(filterColumn, FilterOperatorType.Equal,"sr*");
sheet.getAutoFilters().filter();
workbook.saveToFile("filterCellsByString_result.xlsx", ExcelVersion.Version2013);

Sincerely,
William
E-iceblue support team

[SerPivas]

Thanks!