XML file conversion to Excel file using macro
Hi,
I want to know how to convert XML file into excel.
I know using wizard method, if i use that table format alignment will be differing.
i required data should be in regular format.
i enclosed a file with flow.
xml file is not uploading so i written script in one sheet..
please suggest me how to ensure this using macro functions.
Thank you,
Thara
Please Login or Register to view this content.
Hi,
Thank you.. for providing solution for xml to excel
if we want to convert excel to xml i.e vis versa means..
Last edited by thara.p24; 08-16-2014 at 07:00 AM.
Re: XML file conversion to Excel file using macro
Hi,
Along with the above query, I want one more clarification in which if we exported Xml file into excel file, i want to select only required fields/columns into a separate sheet, how this can be resolve...
I enclosed only excel file. please refer.
Thank you.
Search the first row for columns you want and copy to another sheet.
Because you stipped the xml information when converting to normal excel range you will need to write the xml file with code.
Perhaps you should not convert the imported xml if you want to save it as well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks