How to hide specific column in excel using js-report

[Sanjeev139]

Hi,
I came across one requirements, where I need to hide few fields from excel sheet report. I am using js-report as a libraray.
Please suggest me, If is it possible with js-report or not and if yes how I can do that.

Thanks,
Sanjeev

[jan_blaha]

The xlsx recipe can remove a cell like this
https://playground.jsreport.net/w/anon/3x0JT_HC

[vikky-noelle]

Can you create a new playground or post the code here?

[jan_blaha]

The updated broken link
https://playground.jsreport.net/w/anon/G8r0dqYg

[vikky-noelle]

I tried this on my end and it does not work properly. Does this work on excel that I am making?

{{xlsxRemove "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row" 0}}

{{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row"}}
<row>
    <c t="inlineStr"><is><t>I should have no style</t></is></c>
    <c t="inlineStr"><is><t>I should have no style</t></is></c>
</row>
{{/xlsxAdd}}

{{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row"}}
<row>
    <c t="inlineStr"><is><t>I should be red</t></is></c>
    <c t="inlineStr"><is><t>I should be red</t></is></c>
</row>
{{/xlsxAdd}}

{{xlsxRemove "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row[0].c" 0}}

{{{xlsxPrint}}}

This does not work. It removes the last cell and not the one at the 0th index.

[vikky-noelle]

How will I remove an entire column as well?