This blog post will show how to make a quirky macro that imports CSV and TXT data and converts it into a fillable combo box.

ONLYOFFICE products are very powerful solutions that cover all the demands of our digital age. Starting from version 7.0, the team of ONLYOFFICE experts extended the functionality of our editors with <a href="/blog/?p=26182&amp;utm_source=blog&amp;utm_medium=social&amp;utm_id=combo_box_oforms" target="_blank" rel="noopener">ONLYOFFICE forms</a>. Designed to make working with electronic documents easy, ONLYOFFICE forms can alleviate a lot of mundane tasks. One of the good examples is using fillable forms for creating a<a href="https://oforms.onlyoffice.com/sale-and-purchase-agreement-form?utm_source=blog&amp;utm_medium=article&amp;utm_id=combo_box_oforms" target="_blank" rel="noopener"> sales agreement template</a>. But what if you have your clients’ information stored in separate CSV/TXT files? In this blog post, we will show you how to build a macro that imports CSV and TXT data and converts it into a fillable combo box.

<img decoding="async" loading="lazy" class="aligncenter wp-image-49519" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/Illyustratsiya-v-blog-ONLYOFFICE-Convert-CSV-and-TXT-data-into-a-fillable-combo-1.jpg" alt="Convert CSV and TXT data into a fillable combo box with ONLYOFFICE macro" width="736" height="371" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/Illyustratsiya-v-blog-ONLYOFFICE-Convert-CSV-and-TXT-data-into-a-fillable-combo-1.jpg 1472w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/Illyustratsiya-v-blog-ONLYOFFICE-Convert-CSV-and-TXT-data-into-a-fillable-combo-1-300x151.jpg 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/Illyustratsiya-v-blog-ONLYOFFICE-Convert-CSV-and-TXT-data-into-a-fillable-combo-1-1024x516.jpg 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/Illyustratsiya-v-blog-ONLYOFFICE-Convert-CSV-and-TXT-data-into-a-fillable-combo-1-768x387.jpg 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/Illyustratsiya-v-blog-ONLYOFFICE-Convert-CSV-and-TXT-data-into-a-fillable-combo-1-634x320.jpg 634w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/Illyustratsiya-v-blog-ONLYOFFICE-Convert-CSV-and-TXT-data-into-a-fillable-combo-1-353x178.jpg 353w" sizes="(max-width: 736px) 100vw, 736px" />
<h2>About ONLYOFFICE forms</h2>
The extended functionality brings formats that allow users to effortlessly create and operate with fillable forms in their documents. DOCXF format is a file extension based on DOCX that offers a wide range of tools for creating and editing forms. It allows building forms from scratch or from an existing DOCX file. OFORM is an OOXML extension for online ready-to-fill-out forms. It makes a form template fillable and restricts editing by other users.
ONLYOFFICE forms inherit the structure of a <a href="https://api.onlyoffice.com/docbuilder/textdocumentapi?utm_source=blog&amp;utm_medium=article&amp;utm_id=combo_box_oforms" target="_blank" rel="noopener">text document</a> and include several major classes:
<ul>
<li>text field</li>
<li>combo box</li>
<li>checkbox </li>
<li>picture form</li>
<li>complex form</li>
</ul>
These classes contain methods that incorporate creating text fields, complex fields, combo boxes, drop-down lists, radio buttons, image forms, phone and email address fields.
We will use a combo box class for our macro. The combo box element incorporates a drop-down list of values that we will import from the external CSV/TXT file.
<img decoding="async" loading="lazy" class="aligncenter size-full wp-image-48055 img-popup" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/text-to-OFORM.png" alt="Convert CSV and TXT data into a fillable combo box with ONLYOFFICE macro" width="736" height="364" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/text-to-OFORM.png 736w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/text-to-OFORM-300x148.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/text-to-OFORM-353x175.png 353w" sizes="(max-width: 736px) 100vw, 736px" />
<h2>Building a macro</h2>
The Form section of our <a href="https://api.onlyoffice.com/docbuilder/formapi/api/createcomboboxform" target="_blank" rel="noopener">API documentation</a> includes the Api.CreateComboBoxForm method. It creates a combo box with specified parameters:
<pre class="theme:github font:monospace lang:js decode:true "> var oComboBoxForm = Api.CreateComboBoxForm({"key": "Personal information", "tip": "Choose your country", "required": true, "placeholder": "Country", "editable": false, "autoFit": false, "items": ["Latvia", "USA", "UK"]});
</pre>
The items parameter contains the array of the values displayed in the drop-down list. So our course of action is to replace this array with the array of values obtained from the external CSV/TXT file.
But first, we need to fetch the external file and process the data. We used a similar strategy with the <a href="/blog/?p=40977&amp;utm_source=blog&amp;utm_medium=article&amp;utm_id=combo_box_oforms" target="_blank" rel="noopener">Import CSV/TXT data macro</a>. ONLYOFFICE macros are JavaScript based which makes them extremely versatile and allows us to use AJAX requests:
<pre class="theme:github font:monospace lang:js decode:true ">function LoadFile() {
        $.ajax({
            url: 'file:///C:/Users/LEOPARD/Desktop/Book1.csv',
            dataType: 'text',https://wpblog.onlyoffice.com//wp-admin/post-new.php?lang=en#
        }).done(successFunction);
    }
        LoadFile();
</pre>
Now that we have fetched the file, we need to process this raw data and format it. So we add the succesFunction. It will take the data and break the text into an array of items by lines:
<pre class="theme:github font:monospace lang:js decode:true "> function successFunction(data) {
      var arrAllItems = data.split(/\r?\n|\r/);
}
</pre>
Then we target the active document and create the combo box with the arrAllItems array in the items parameter:
<pre class="theme:github font:monospace lang:js decode:true "> var oDocument = Api.GetDocument();
 var oComboBoxForm = Api.CreateComboBoxForm({ "key": "Personal information1", "tip": "Choose your country", "required": true, "placeholder": "Country", "editable": false, "autoFit": false, "items": arrAllItems });</pre>
After that we create a paragraph and add the combo box to it:
<pre class="theme:github font:monospace lang:js decode:true ">  var oParagraph = Api.CreateParagraph();
oParagraph.AddElement(oComboBoxForm);
</pre>
Now we need to insert our combo box into the document. There are several ways to tackle this task, but we suggest using the InsertContent method. It inserts an element right where the cursor is positioned. We also suggest specifying the text and paragraph proprieties in the parameters. It will prevent possible mistakes and macro malfunctioning:
<pre class="theme:github font:monospace lang:js decode:true ">oDocument.InsertContent([oParagraph], { "KeepTextOnly": true });
</pre>
The entire macro code is the following:
<pre class="theme:github font:monospace lang:js decode:true ">(function()
{
   function LoadFile() {
      $.ajax({
          url: 'file:///filePath,
          dataType: 'text',
      }).done(successFunction);
    }
        LoadFile();

   function successFunction(data) {
        var arrAllItems = data.split(/\r?\n|\r/);
        var oDocument = Api.GetDocument();
        var oComboBoxForm = Api.CreateComboBoxForm({ "key": "Personal information", "tip": "Choose your option", "required": true, "placeholder": "Option", "editable": false, "autoFit": false, "items": arrAllItems });
        var oParagraph = Api.CreateParagraph();
oParagraph.AddElement(oComboBoxForm);
oDocument.InsertContent([oParagraph], { "KeepTextOnly": true });
    }
})();
</pre>
Now, let&#8217;s run our macro and see how it works!
<div style="width: 640px;" class="wp-video">
<video class="wp-video-shortcode" id="video-48019-1" width="640" height="334" preload="metadata" controls="controls"><source type="video/mp4" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/importToOformRev.mp4?_=1" /><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/importToOformRev.mp4">https://static-blog.onlyoffice.com/wp-content/uploads/2022/12/importToOformRev.mp4</a></video></div>
Note!
<ul>
<li>To insert a combo box, press space after running a macro.</li>
<li>In order to insert multiple combo boxes into the document use different key parameters of the Api.CreateComboBoxForm method.</li>
</ul>
This macro is just one of the many examples of what you can do by implementing our API methods. We kindly encourage you to experiment and hope that you will utilize the concepts outlined in this post to build your own macros.
Our macros are JavaScript based which makes them extremely versatile and practical. Don’t hesitate to ask questions or share your ideas with us. We are open to discussion and cooperation. Best of luck in your exploratory endeavors!
<div class="useful-links">
<h3>Useful links</h3>
<a href="https://api.onlyoffice.com/docbuilder/formapi/api/createcomboboxform?utm_source=blog&amp;utm_medium=article&amp;utm_id=combo_box_oforms" target="_blank" rel="noopener">ONLYOFFICE API</a>
<a href="https://oforms.onlyoffice.com/?_ga=2.31292415.1330805340.1670148236-1206280962.1664693917&amp;utm_source=blog&amp;utm_medium=article&amp;utm_id=combo_box_oforms" target="_blank" rel="noopener">OFORMS library </a>
<a href="/blog/?p=26182&amp;utm_source=blog&amp;utm_medium=article&amp;utm_id=combo_box_oforms" target="_blank" rel="noopener">How to create fillable forms</a>
<a href="/blog/?p=27268&amp;utm_source=blog&amp;utm_medium=article&amp;utm_id=combo_box_oforms" target="_blank" rel="noopener">New OFORM &amp; DOCXF formats explained</a>
<a href="/blog/?p=40977&amp;utm_source=blog&amp;utm_medium=article&amp;utm_id=combo_box_oforms" target="_blank" rel="noopener">Import CSV and TXT data into your spreadsheet</a>
</div>
&nbsp;

Convert CSV and TXT data into a fillable combo box with ONLYOFFICE macro

Recent posts

Use ONLYOFFICE macro to analyze spreadsheet data

Back to school 2023 with ONLYOFFICE: discounts for education

Best AI writers 2023