Hello Team,
I need to export the hidden columns from the Ignite UI grid (16.2).
I am using the below code to hide the column.
{ headerText: "Samples", key: "Samples", dataType: "string", width: "0px"}
I applied the gridFeatureOptions's property, "hiding:none". It works in chrome. But in Internet Explorer, the column is hidden. But I want hidden column to show always.
Please help us to proceed further.
Hello Satkhi,
Thank you for posting to our forum.
I looked into your code and noticed that you set the zero width to hide the column instead if you use ‘Hiding’ feature of the grid and hide the column through its column setting everything will work as expected.It will hide the column from the grid and will be visible while exporting.
I have attached a sample I have created for your reference.
Please find the attached sample and let me know if you need further assistance.
Hi,
I am also getting the same kind of issue. I had tried your attached sample. It works perfect.
But, could you please provide the sample without using "Hiding" property of grid.
Hello Gopi,
I would like to know if you are not using ‘hiding’ property of the grid then how are you hiding column?Can you also provide me more information about the configuration of the grid and the error message you are getting.
Hi Friends,
I can see the samples given and hiding property working fine but the hided column style was changed in the grid and it allowing user to hide/un-hide the corresponding column. please suggest is there any possibilities for don't show the hided column in the grid (Like by setting the column width to 0 PX, the column hided information shall not visible in the GRID interface)
As per our requirement, we should not display some of the column in the grid and shall need to display the columns in the excel export alone, for the purpose we also set the column width to 0 Px.
if we export the grid data using Chrome browser the corresponding columns shall be visible by-default.
if we use IE to export, the column shall remain hidden in the excel file.
Please suggest to proceed further.
Hai,
We need your help. It's urgent release. Please provide the samples to show the hidden column in IE browser.
The below code is the configuration of the grid.
{ headerText: "ID", key: "UserId", dataType: "number", width: "50px" },
And I didn't get any error message. But this column is hidden in IE only.
The below code is to export the grid data
$.ig.GridExcelExporter.exportGrid($("#gridUser"), { fileName: "User", gridFeatureOptions: { sorting: "applied", filtering: "filteredRowsOnly", columnFixing: "applied", hiding: "none" }, }, { exportStarting: function (args) { args._gridData = data.Records; } });