Hi,
We tried below code from this link https://blog.conholdate.com/total/how-to-convert-excel-to-xml-in-csharp/,
Workbook workbook = new Workbook(“sample.xlsx”);
workbook.Save(“Spreadsheet.xml”);
XmlSaveOptions xmlSaveOptions = new XmlSaveOptions();
workbook.Save(“data.xml”, xmlSaveOptions);
It is producing xml output as shown there.
We have custom requirement where we are expecting xml output in below format or refer attached image,
<root> <Student ID=1> <NAME>Student1</NAME> <DateofBirth>10-mar-2012</DateofBirth> </fund> <Student ID=2> <NAME>Student2</NAME> <DateofBirth>21-mar-2012</DateofBirth> </fund> <Student ID=3> <NAME>Student3</NAME> <DateofBirth>15-mar-2012</DateofBirth> </fund> </root>
image.png (2.7 KB)
and my data input will look like below,
Student NAME DateOfBirth
1 Student1 10-mar-2012
2 Student2 21-mar-2012
3 Student3 15-mar-2012
Could you let us know if this is possible using Aspose.
Also If we can set the format using dynamic template then It will be more helpful.