Skip to main content
D
dariiah1559
November 15, 2023
Question

Excel from template

  • November 15, 2023
  • 3 replies
  • 0 views

Hi! I have task to generate excel file, I am using Text Doc from Template. Almost all parameters I am passing like ###parameter###  but I  also have checkbox in template in which I should pass true/false and I am not sure how to do that.

3 replies

mikes0011
mikes0011
Brainy
November 15, 2023

I wouldn't expect even the basic replacement fields to work when used in this manner - an excel file is not a text file (it's actually a sort of .zip file).  Have you tried it and found it works?  I'd be surprised but it would be interesting if it did.

I wouldn't have any expectation that checkboxes work even if the replacement fields did.  The text from template functionality is not meant to interact with this at all.  Even checkboxes themselves in Excel are finnicky - i'm not sure what the back-end data even looks like, with respect to the difference between a checkbox with a "checked" value versus "unchecked" - you could unzip the main .xml file contained in the zip .xlsx container and look and see if you can tell anything, though you'll need to be good at looking at a mass of disorganized XML code to pick out the data you're after.

D
dariiah1559Author
November 15, 2023

Thank you for answer. Yes basic replacement works that way with xls files. In documentation it is also mentioned.

mikes0011
mikes0011
Brainy
November 15, 2023

Ha, nice, I'd never noticed that.

Per your question about checkboxes though, i still expect it's not supported, but if you closely examine the backing data that determines when a box is "checked" or not, there's a small possibility you might stumble onto something workable.  I've never had the opportunity to do so.

Terms & ConditionsAccessibility statement