Suppose you want to create static country name drop down list from excel sheet column then for option tag,
1. Copy country id and name columns from excel sheet and paste in first textbox.
2. Select 'Tab' as column separator and 'New Line' as row separator
3. Type following in format textbox:
<option value="{0}">{1}</option>
4. Click on Convert button.
Enter Text Below: |
Select Column Separator: |
New Line Comma(,) Semicolon(;) Single Space( ) Tab Other |
Select Row Separator: |
New Line Comma(,) Semicolon(;) Single Space( ) Tab Other |
Enter Format: |
Type {0} to use data. e.g. myobject.{0} = value({0}) |
Output: |