A Flash Developer Resource Site

Results 1 to 5 of 5

Thread: xml to csv or excel?

  1. #1
    Member
    Join Date
    Feb 2007
    Posts
    52

    xml to csv or excel?

    We have a client who wants to send orders as xml files. We need an automated (easy) process to pull specific elements (order number, shipping method, etc.) from the xml and generate a csv file with those elements.

    My original plan of attack was to open the file in Excel and build macros to manipulate the data. But Excel will not open the files unless they are in an xml spreadsheet format.

    Next plan is to somehow convert the xml to a csv. Then open that in Excel and run custom macros to get what we need.

    But I can't find a solution. Anyone have any ideas?

  2. #2
    Member
    Join Date
    Feb 2007
    Posts
    52
    Any ideas would be greatly appreciated.

  3. #3
    madskool.wordpress.com brutfood's Avatar
    Join Date
    Apr 2002
    Posts
    469
    Not sure what your problem is exactly. It sound like you need to write a simple script to parse the XML and assemble the CSV file. Just e4x and string handling. You could write a simple AIR app to do it.

    I'm afraid I don't know an off-the-shelf solution, but this doesn't sound like rocket surgery.

    Will the structure of the XML, and elements extracted always be the same?
    AIR, ActionScript 3, Flex and Flash expert and freelance developer

  4. #4
    Member
    Join Date
    Feb 2007
    Posts
    52
    Should have prefaced this by saying I'm not a programmer nor do we have any on staff. We can outsource this, but were looking for something we could do in-house.

    Thanks for the reply.

  5. #5
    Junior Member
    Join Date
    Jul 2013
    Posts
    22
    You can integrate an excel converting tool on your windows system to convert the html or xml files into single-page or multi-page excel document just within very short time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




Click Here to Expand Forum to Full Width

HTML5 Development Center