Support for Case-Insensitive Matching in @ExcelColumnName Annotations

[jmrsnt]

It would be a valuable enhancement to add support for case-insensitive column name matching in the @ExcelColumnName annotation. This feature could be implemented through an optional parameter, such as ignoreCase, with a default value of false.

When ignoreCase is set to true, the library would match column names in a case-insensitive manner, allowing for greater flexibility when working with Excel sheets where column headers may not exactly match the case defined in the @ExcelColumnName annotation.

Example Usage:

@ExcelColumnName(value = "ColumnName", ignoreCase = true)
private String someField;

In this example, the column header could be ColumnName, columnname, COLUMNNAME, or any other case variation.

This feature would simplify integration and improve usability, especially in scenarios where column headers may not have a consistent case across different Excel files.

If this enhancement makes sense for the project, I would be happy to work on its implementation and submit a pull request.

[github-actions]

Thank you for contributing to Poiji! Feel free to create a PR If you want to contribute directly :)

[ozlerhakan]

Hi @jmrsnt ,

Thank you for the comprehensive suggestion on the topic! I hope you refer to a feature that Poiji has supported for a while among the PoijiOptions features; Have your tried out PoijiOptionsBuilder#caseInsensitive(boolean) for your use cases? Is this what you're looking for?

Thanks!

[jmrsnt]

Hi,

Yes, that's exactly what I was looking for. Thank you for pointing it out!