You can use the short code [cfdb-export-link] to generate a link on a page. You could attach it to a button you put in your page.
Thread Starter
Urdz
(@urdz)
<a href="[cfdb-datatable form="myForm1" hide="Submitted From,Submitted Login"]" class="myExcelButton">ExcelButton</a>
Like this I mean.
Yes, try it.
But your example might have a problem. Make single quotes for href=’…….’ because you are using double quotes inside the short code.
Thread Starter
Urdz
(@urdz)
Thank you, it works. But when I click on my button it should generate excel file, but when it opens it’s an empty file. But when I open it in the plugin, short code is working.
Try this:
<a href='[cfdb-export-link form="myForm1" enc="CSVUTF8BOM" hide="Submitted From,Submitted Login"]' class="myExcelButton">ExcelButton</a>
Thread Starter
Urdz
(@urdz)
I messed up with permissions, but thank you! It opens now, but in excel it does not sort my table in excel table. There is just messy text.
Thread Starter
Urdz
(@urdz)
I put it in the Excel Internet Query and it generates a table in Excel, but only in plugin, when I type my wordpress password. When I put the shortcode in to “herf=’ it does not generate a table in Excel it does not ask me for my password in Excel, it puts my table just in one column.
You can also try this enc=”TSVUTF16LEBOM” in case Excel is not reading it correctly:
<a href='[cfdb-export-link form="myForm1" enc="TSVUTF16LEBOM" hide="Submitted From,Submitted Login"]' class="myExcelButton">ExcelButton</a>
