Write XSLT Program to Convert and Process Data in XML File Into .XLSX File
Budget: $30 – $250 USD
Write an XSLT program to convert and process an XML file into an excel spreadsheet. The actual XML file contains a set of 2000+ products and product options and values. Each product option has a set of values that can be selected from. Each unique value has an id associated with it.
Some products have zero options, some have one option and some have multiple options.
We need every combination of product options to be outputted into the excel file so that we can have an excel file of every unique option possible to be ordered from our product database.. The unique id for each product/option(s) combination is a concatenation of the product id and the option id(s) separated by an underscore. The option id's are to be appended to the product_id in ascending numerical order.
Some products have zero options, in which case there will only be one row in the excel file and the unique id will be just the product id.
Some products have multiple options in which-case, every combination of option value for each option must be represented as a line in the excel file.
For example, one product may be a balloon, which is available in 12 inch diameter and 24 inch diameter. In either size the balloon is available in red, blue, green, or yellow. In this case, you would need to generate 8 lines for this product; one for each possible combination:
12 inch, red
12 inch, blue
12 inch, green
12 inch, yellow
24 inch, red
24 inch, blue
24 inch, green
24 inch, yellow
I have attached a sample input data and output data. Please let me know any questions.
Some products have zero options, some have one option and some have multiple options.
We need every combination of product options to be outputted into the excel file so that we can have an excel file of every unique option possible to be ordered from our product database.. The unique id for each product/option(s) combination is a concatenation of the product id and the option id(s) separated by an underscore. The option id's are to be appended to the product_id in ascending numerical order.
Some products have zero options, in which case there will only be one row in the excel file and the unique id will be just the product id.
Some products have multiple options in which-case, every combination of option value for each option must be represented as a line in the excel file.
For example, one product may be a balloon, which is available in 12 inch diameter and 24 inch diameter. In either size the balloon is available in red, blue, green, or yellow. In this case, you would need to generate 8 lines for this product; one for each possible combination:
12 inch, red
12 inch, blue
12 inch, green
12 inch, yellow
24 inch, red
24 inch, blue
24 inch, green
24 inch, yellow
I have attached a sample input data and output data. Please let me know any questions.