Display none HTML tags of a column shown . How exclude those from excel export
Display none HTML tags of a column shown . How exclude those from excel export
haiderTyagi
Posts: 11Questions: 2Answers: 0
<tr>
<td>Meeting<label calss="hide" style="display:none">0</label></td>
</tr>
or it can be
<tr>
<td><sapn>Meeting</span><label calss="hide" style="display:none">0</label></td>
</tr>
In column there is a label with dispay none attribute .. that label is not showing in browser but when i excel export
its show in excell sheet like Meeting0
How Show only Meeting not the display none tag
This discussion has been closed.
Answers
exportOptions: { columns: [':visible'] }, not works bcz. its not the column which is hidden. this is a label inside column,, and i also try stripHtml this stripHtml work in print but not in excel export
In Excel Export it shows
Meeting<label calss="hide" style="display:none">0</label>
Hi @haiderTyagi ,
We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.
Cheers,
Colin
Hi @colin
This Is The Link Of Use Case
https://jsbin.com/himiqepalo/edit?html,css,js,output
Thanks for the example. You could use an export formatter, but it would be better if you could just put the label information as an attribute for the
tdtag - e.g.:could become:
The data is still present (assuming you need it for some scripting thing, since it isn't visible to the end user) and the export will work just fine.
Allan
@colin @allan
Will you please check that
Hi @haiderTyagi ,
What would you like us to check? Allan gave a couple of solutions in his reply.
Cheers,
Colin
Hi @allan
Thank You for ur suggestion
What if i use
<td><sppn class="show">2000 Usd<span><span style="display:none" class="notS">Hr001</spanl></td>
**
instead of **<td data-label="Hr001">2000 Usd</td>
is there any other way to over come the problem
by D wy Thx for ur answer
@allan
actually.. i also give an id to that label and showing that label on behalf of some condition
Hi @allan
Go To This Use Case
https://jsbin.com/jerudusoro/edit?html,css,js,output
This My table With Real Data