Converting Excel data into an XML file (Pre-defined template)
Posted: Sun Jan 24, 2021 9:24 pm
Hello Everyone,
I have an excel file with 5 sheets and I want to convert this into an XML File. The XML file has to be one continuous file with the data blocks repeated in a pattern.
For example in from the Big File with 5 sheets (attached), from the first sheet,
B5 goes to Line 5
B9 goes to Line 34
B11 goes to Line 59
E5:E105 goes to Line 92 (Tabular data separated by commas)
F5:F105 goes to Line 96
of the ExcelToXML file (attached). I could not attach the XML file directly so have converted it to a .txt file.
This same pattern is repeated for each sheet and pasted one below the other in the XML file (attached). I need to do this for 110 sheets automatically.
Please suggest a way to solve this.
Thank you
warm regards,
Pratik
I have an excel file with 5 sheets and I want to convert this into an XML File. The XML file has to be one continuous file with the data blocks repeated in a pattern.
For example in from the Big File with 5 sheets (attached), from the first sheet,
B5 goes to Line 5
B9 goes to Line 34
B11 goes to Line 59
E5:E105 goes to Line 92 (Tabular data separated by commas)
F5:F105 goes to Line 96
of the ExcelToXML file (attached). I could not attach the XML file directly so have converted it to a .txt file.
This same pattern is repeated for each sheet and pasted one below the other in the XML file (attached). I need to do this for 110 sheets automatically.
Please suggest a way to solve this.
Thank you
warm regards,
Pratik