Please advice on how to read xls file format using skill.
I'm not sure but i think you can try to use the function: axlHttp("your_file.xls") to open an excel file.
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...
In reply to Pawandeep: