Sheet: Data Exporter support

[anatoliaDev]

Describe the feature you would like to see added

I would like to use data export for sheet like how primefaces datatable support. Currently there is no component to export data for sheet table.

Additional context

https://stackoverflow.com/questions/76032572/data-exporter-for-primefaces-extensions-sheet

[melloware]

I think this is a good suggestion. Let me investigate this.

[melloware]

This will be tougher than I thought as the Exporter component was not expecting exporters defined outside of PF. See
https://github.com/primefaces/primefaces/blob/1bd89e0ca90398e642b57978990efd753bd4adbf/primefaces/src/main/java/org/primefaces/component/export/DataExporter.java#L185-L197

Right now its expecting the types to be declared there.

    protected Class<? extends UIComponent> guessTargetClass(List<UIComponent> targets) {
        Class<? extends UIComponent> targetClass = null;
        if (targets != null) {
            for (UIComponent current : targets) {
                if (current instanceof DataTable) {
                    targetClass = DataTable.class;
                }
                else if (current instanceof TreeTable) {
                    targetClass = TreeTable.class;
                }
            }
        }
        return targetClass;
    }

[melloware]

I think this can be fixed now with the latest changes in core PF allowing more pluggable exporters