Hi @Harsh Sharma 

By looking at the Wijmo documentation can you please share what you've tried so far on top of what Giuliana shared?

Hi @Gonçalo Martins ,

I tried the approach which Giuliana shared by putting the code in a Run Javascript action which will trigger on click of a button. 

Also, I tried to customize the functions for exporting the csv written in GridFramework.JS of Data grid web component. By doing the changes mentioned in question above, now I was able to achieve all the cells of hidden columns as well but not getting the headers of those hidden columns. So, I tried using "includeColumnHeaders" and "includeRowHeaders" from wijmo doc but that didn't work for me.

Referring to below screenshot I am not getting the headers but all the cells of those columns

Hi @Harsh Sharma,

As I could not reproduce this issue on my side, could you please share a file reproducing this behavior, so I can assist you better?

Thanks,

Giuliana.

Hi @Harsh Sharma 

In order to use Giuliana's code you need to override the exportCSV function.
By doing that you can change the method on the page level and use the includeColumns which is what you need to achieve your use case. Can you share your sample oml?

Hi @Harsh Sharma 

I think I understood the issue but am not sure about the solution - will need to get some time to investigate. It seems that the includeColumns is only used for Excel export and the code always looks at the page view so we can only get the columns that are rendered since they're the ones we can access by looking at gObj.grid.column like the method that is implemented. Once I have some time throughout the week I'll try to find a way of doing this if possible. If you find some examples of this use case on Wijmo's documentation please share them since it will be easier to understand if we can do it and how.

Hi @Harsh Sharma 

I was able to find a solution and to be honest after trying two different approaches, I think this will be the best solution.

Assumptions:

• you need to have all the columns you want to have on the exported CSV as column blocks and with the property Hide=true so that the columns are created on the Columns Collection:
• the row header will always be included, so a blank column will be seen on the exported Excel - this is a rule from Wijmo that in the future can change but currently there's no way to avoid

Solution:

• Wrote a different method to use the object ClipStringOptions (find the oml attached):

/* Create export all to CSV 
Using ClipStringOptions */

function exportAllToCSV (gridId,filename) {    
    
    var gObj = GridOS.ComponentUtils.getGridObjectById(gridId);

    // add a filter to show that it works while exporting
    var f = new wijmo.grid.filter.FlexGridFilter(gObj.grid);

    var options = wijmo.grid.ClipStringOptions.CSV;
    options ^= wijmo.grid.ClipStringOptions.InvisibleColumns;

    var rng = new wijmo.grid.CellRange(0, 0, gObj.grid.rows.length - 1, gObj.grid.columns.length - 1),
    csv = gObj.grid.getClipString(rng, options, true, true);
    exportFile(csv, filename);

}

//Export the file
function exportFile(csv, fileName) {
    var fileType = 'txt/csv;charset=utf-8';
    if (navigator.msSaveBlob) { // IE 
      navigator.msSaveBlob(new Blob([csv], {
        type: fileType
      }), fileName);
    } else {
      var e = document.createElement('a');
      e.setAttribute('href', 'data:' + fileType + ',' + encodeURIComponent(csv));
      e.setAttribute('download', fileName);
      e.style.display = 'none';
      document.body.appendChild(e);
      e.click();
      document.body.removeChild(e);
    }
  }

Hope it helps.

Cheers,
GM