Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 12-05-2009
Member
 
Join Date: Apr 2009
Posts: 68
How to convert Excel file to XML format

I wanted to developed two applications, one will be developed in PHP and the other will be in excel. Between these two parties, I Need to have synchronization i will prefer for XML format,but to implement that I need to import all the data from XML to excel format, I had no problem. Now, I have the reverse. Can I have someone to help me.

Thank you
Reply With Quote
  #2  
Old 12-05-2009
Member
 
Join Date: Jan 2006
Posts: 211
Re: How to convert Excel file to XML format

You may get many situations where you need to validate the format of Excel data sheet against a specified XML schema. so you may also need to required to generate XML schema as per your requirement of an Excel Work Sheet. Once this has done then you will find the XML file and XML Schema based on provided range. Then requirement arise for Validation of Excel Worksheet/Workbook against the provided XML Schema.Then you need to make Provision of batch processing capability.
Reply With Quote
  #3  
Old 12-05-2009
Member
 
Join Date: Dec 2008
Posts: 161
Re: How to convert Excel file to XML format

You need to save your excel file as .CSV that will be Comma Separated Values format. This will include only the data which would be having any format in the sense that table and the table type or any other information. you need to copy the script in an empty text file and save that file as AnyName.php. Then keep both the .CSV and .PHP files in the same location. Now Open the .PHP file to set the same name for your .CSV and .XML file and run the script again this will creates a XML file from the corresponding .CSV.

NOTE: Requires PHP >= 5.1
Reply With Quote
  #4  
Old 12-05-2009
Member
 
Join Date: Dec 2008
Posts: 183
Re: How to convert Excel file to XML format

You may get many free software that will do the conversion of Excel file to XML format you don't need to follow any steps or nothing else, you just only need to give the file location and file type you want to have the conversion, this will saves your more time and effort as well.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to convert Excel file to XML format"
Thread Thread Starter Forum Replies Last Post
How to convert Mac/iWork numbers to MS Excel format tools Chau MS Office Support 1 17-01-2012 06:41 PM
How to convert avi format file to iPhone format ? hRYHORIY Portable Devices 5 13-06-2011 10:38 AM
How to convert XLS files To DBF Format in Excel 2007 Jhooda Windows Software 3 26-11-2010 05:14 PM
Convert a PDF file to Word, Excel or JPG Format Mastermind Tips & Tweaks 4 25-06-2009 12:21 AM
Convert avi file to DVD format Amelia Windows Software 2 06-02-2009 07:44 AM


All times are GMT +5.5. The time now is 07:58 PM.