Navigate to the src/lib/components folder and make any changes or improvements you'd like to the component(s) in this folder.

Clone your forked repository to your local machine by running git clone.

Fork this repository by clicking the 'Fork' button on the top-right corner of this page.

We welcome contributions from anyone interested in improving this package! To get started, please follow these steps:

Note that for fields where you want to retain the original value, specify null as the action. On the other hand, if the action is a function, it will be passed the field value as an argument, and whatever is returned from the respective function will be put in the final CSV. If the action is an object, such as ethnicityOptions, the value of the field will be used as the key to look up in the object. Lastly, if you want to look up a value in an object, define the object as the action for the field. For the date of birth field, you can calculate the age using the calculateAge method. For instance, for the admit date field, you can define a getDateString function that will receive the 'admit_date' value as an argument and return the formatted string. The function will receive the value of the field as an argument and return the formatted string. To format a field, such as the admit date, define a function in the 'actions' array for that field. For example, to merge the first name and last name fields, use profile.first_name_profile.last_name. To merge two fields, such as the first name and last name, use a double underscore (_) in the respective value in the 'keys' array. This will automatically fetch the value of 'name' and include it in the exported CSV. For instance, if you have an object that has an object inside it, and that object has another object inside it, you can simply get the value you want by using dot notation (e.g., ). Since JSON data can be deeply nested, you can traverse the path to the value you want to use by separating it with a dot. In the example above, we have an array of profiles that we want to transform into a CSV file. function main(workbook: ExcelScript.Import Explanation

For more information about working with JSON, read Use JSON to pass data to and from Office Scripts. Note that for column names with spaces, be sure to place your key in quotation marks, such as with 'Event ID' in the sample. You can change the interface TableData structure to match your table columns.

Convert csv to json javascript