Using JqxGrid's excel export 'exportview'

[inee814Participant]

Hello.
I’m using jqxGrid’s client-side excel export ‘exportview’ method.
I don’t want to display hidden columns, but ‘exportview’ method displays all datafields.
(On the other hand, ‘exportdata’ method provides the column hiding feature.)
Is there no way to hide columns using ‘exportview’ method? Where can I find the API documentations abot this method?
You can view the code at the following link. https://jsfiddle.net/inee814/pL7e4ay8/15/
When I open downloaded .xlsx file, it shows hidden “Price” column.
And so on, ‘exportdata’ method has a problem as “the page as loaded over HTTPS, but requested an insecure HTTP”

P.S) This site seems a bit laggy. Is it just me?

[svetoslav_borislavovParticipant]

Hi,

You can find the dataexport.php file in the jqwidgets build downloaded from the client portal, host it on your own server and pass its url as an argument to the exportdata method.
This way you can use the additional parameters of the exportdata method

Best regards,
Svetoslav Borislavov

jQWidgets Team
https://www.jqwidgets.com/

[inee814Participant]

Hi, Svetoslav Borislavov.

Creating an additional server for hosting dataexport.php seems cumbersome and inconvenient.
Also, I prefer xlsx, but it seems to only support xls files.
Do you have plans to add features like column hiding to the “exportview” function?
And could you please provide a download link for the dataexport.php file?”

Thank you.

[svetoslav_borislavovParticipant]

Hi,

On the hidden columns, you can set the exportable property to false.
This way you will export only the visible columns with ‘exportview’

I have opened a feature request for this!
To access the file follow the steps from my previous reply

Best regards,
Svetoslav Borislavov

jQWidgets Team
https://www.jqwidgets.com/

[inee814Participant]

It’s perfect!
Thanks Svetoslav Borislavov.

[Author]

Posts