Home > Community > Forums > PCB SKILL > Reading an excel file

Email

* Required Fields

Recipients email * (separate multiple addresses with commas)

Your name *

Your email *

Message *

Contact Us

* Required Fields
First Name *

Last Name *

Email *

Company / Institution *

Comments: *

 Reading an excel file 

Last post Mon, Apr 16 2012 3:55 AM by aeris. 7 replies.
Started by Pawandeep 04 Apr 2012 10:59 PM. Topic has 7 replies and 3062 views
Page 1 of 1 (8 items)
Sort Posts:
  • Wed, Apr 4 2012 10:59 PM

    • Pawandeep
    • Top 75 Contributor
    • Joined on Sat, Oct 15 2011
    • Singapore, 00-SG
    • Posts 106
    • Points 1,690
    Reading an excel file Reply

    Hi,

    Please advice on how to read xls file format using skill.

    Filed under: , ,
    • Post Points: 50
  • Wed, Apr 4 2012 11:58 PM

    • luanvn81
    • Top 150 Contributor
    • Joined on Fri, Sep 18 2009
    • dnai, Vietnam
    • Posts 61
    • Points 920
    Re: Reading an excel file Reply

     Hi!

    I'm not sure but i think you can  try to use the function:  axlHttp("your_file.xls") to open an excel file. 

    Luan.

    • Post Points: 5
  • Thu, Apr 5 2012 12:18 AM

    • Pawandeep
    • Top 75 Contributor
    • Joined on Sat, Oct 15 2011
    • Singapore, 00-SG
    • Posts 106
    • Points 1,690
    RE: Reading an excel file Reply
    Hi Luan,

    I need to parse data(so that I can manipulate further) on my data which is xls format.

    The function u mentioned will not be helpful.
    • Post Points: 5
  • Thu, Apr 5 2012 1:54 AM

    • pcbnagaraj
    • Top 150 Contributor
    • Joined on Tue, Dec 6 2011
    • bangalore, Karnataka
    • Posts 55
    • Points 1,130
    RE: Reading an excel file Reply
    Save the xls file as csv and use the parseString with comma as parser.

    Thanks,

    Nagaraj.
    • Post Points: 5
  • Thu, Apr 5 2012 2:00 AM

    • Pawandeep
    • Top 75 Contributor
    • Joined on Sat, Oct 15 2011
    • Singapore, 00-SG
    • Posts 106
    • Points 1,690
    RE: Reading an excel file Reply
    Guys,

    My requirement is to use xls only
    • Post Points: 5
  • Wed, Apr 11 2012 1:47 AM

    • eDaNoy
    • Top 200 Contributor
    • Joined on Fri, Sep 9 2011
    • SBMA, Philippines
    • Posts 41
    • Points 940
    Re: Reading an excel file Reply

     Hello Pawandeep,

    i presume that you will going to read normal xls file with random characters...

    I suggest these steps that could help.

    1. use axlDMFileBrowse to browse ur file.this wil give you the path of your xls

    2. use inFile to read your xls and outFile to write the content of your xls.

    3. use parseString(item "\n")to break down xls content per line..

    4. then your process.

     

    there are xls format that could be used with specific delimiter.

    when you want CSV format then your contents are separated by ","

    CSV=comma separated value, can be used with parseString(item ",")

    or xxxx.txt in form of xls, this could be tabbed delimited xls "\t" can be used with parseString(item "\t") to breakdown your content..

    or you can post a sample of your xls document so we could give you the right terms...

    thanks

     

     

     

    • Post Points: 5
  • Wed, Apr 11 2012 2:28 AM

    • Pawandeep
    • Top 75 Contributor
    • Joined on Sat, Oct 15 2011
    • Singapore, 00-SG
    • Posts 106
    • Points 1,690
    RE: Reading an excel file Reply
    Hello,

    Reading text from an *.xls file produces some “Non Readable” characters.

    Do you have small section of working code to read data from xls format?
    • Post Points: 20
  • Mon, Apr 16 2012 3:55 AM

    • aeris
    • Top 500 Contributor
    • Joined on Sun, May 16 2010
    • Posts 33
    • Points 435
    Re: RE: Reading an excel file Reply
    we are doing it this way,

    1. create a third party program that will read the xls file for you

    --> that program should save it to a txt file

    2. read using infile the txt file created

    --> use axlRunBatchDBProgram to run the program, then next to it the function that will read the txt file
    • Post Points: 5
Page 1 of 1 (8 items)
Sort Posts:
Started by Pawandeep at 04 Apr 2012 10:59 PM. Topic has 7 replies.