Need help to convert Excel data to XML

[uakash7]

Hi Alan,

Please see the enclosed excel sheet, I tried with multiple date/text format and different machine. However, it's still giving "00:00" instead of actual time.
Enclosing the text file as well.

Thanks

[DocAElstein]

Hi

Your file is different to the type you told me before. My macro was written to work on the file type you gave. ( You have an extra column in your latest file ). ( I am surprised you did not notice that? )

The macro that I wrote works assuming specific headings, in particular those you gave me.

This is the sort of test data you were talking to me about before ( https://excelfox.com/forum/showthrea...ll=1#post15351 )

_____ Workbook: Sample excel file.xls ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E
1	Entity ID	day	month	year	time
2	700	19	2	2021	08:00
3	700	19	2	2021	08:30

Worksheet: Sheet1

The macro I wrote works on that and gives the results you asked for ( https://excelfox.com/forum/showthrea...ll=1#post15351 )
( You would have seen that if you had downloaded and tried the macro in the sample workbook I did for you ( https://excelfox.com/forum/showthrea...ll=1#post15365 ) )



Your last uploaded workbook , xlFox1.xlsm , looks like this

_____ Workbook: xlFox1.xlsm ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G
1	Entity ID	day	month	year	recID	time
2	700	19	2	2021	7001	8:00
3	700	19	2	2021	7001	8:30

Worksheet: Sheet1

---

If I look back over the Thread we can see you have had a few different file formats, with different headings.

Maybe you should check and make sure you know what you want., that is to say what headings you are going to have and what output you want.

If you want a macro which will give you the results that you want for any different set of headings, then that probably can be done, but would be quite a long and complicated macro

The macro I wrote was for the specific headings you gave to me in the test data
Entity ID __ day __ month __ year __ time


You have two options
_ (i) A macro or macros, each for a specific set of headings
or
_ (ii) A more complicated single macro that will work on different headings

In case (i) it is essential to know the headings, as obviously I can’t guess.
In case (ii) it would still be helpful to know what might be typical headings


If you just want a macro for your last file, then you might be able to figure out yourself the modifications that you need to do to my macro


Alan

[kanetom]

Hi Uakash,

If you're still in trouble please try to use this online free tool below Excel to XML converter.
https://onlineconvertfree.com/conver...at/xls-to-xml/
It's really great. And I hope this will work for you.

[uakash7]

Thank you Alan for all your help and support, I did final testing on my data today and with just some edits it's working for me as I wanted.
You're a champ. Thanks again and hope to connect with you soon.

[DocAElstein]

Thx for the feedback
Alan