Stats

Replies 7
Subscribers 160
Views 15979
Members are here 0

Reading an excel file

Pawandeep over 13 years ago

Hi,

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

luanvn81 over 13 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Pawandeep over 13 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
pcbnagaraj over 13 years ago

Save the xls file as csv and use the parseString with comma as parser.

Thanks,

Nagaraj.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Pawandeep over 13 years ago

Guys,

My requirement is to use xls only
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
eDaNoy over 13 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.