comp.lang.idl-pvwave archive
Messages from Usenet group comp.lang.idl-pvwave, compiled by Paulo Penteado
Home » Public Forums » archive » how to read string data from excel file
Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend  		Switch to threaded view of this topic Create a new topic Submit Reply
how to read string data from excel file [message #85925] Wed, 18 September 2013 07:51 Go to next message
Adele is currently offline  Adele
Messages: 4
Registered: September 2013
Junior Member
I am using IDLffExcel to read data from excel files. It works fine to get number data, but seems it can not read string data, any suggestions please?

Thanks a lot.

Adele

Report message to a moderator

Re: how to read string data from excel file [message #86009 is a reply to message #85925] Mon, 23 September 2013 19:55 Go to previous messageGo to next message
kagoldberg is currently offline  kagoldberg
Messages: 26
Registered: November 2012
Junior Member
If it's possible to have Excel output the data as CSV (comma-separated values) then you can read it with read_csv() or read_ascii(), for example, or a text-file reading script you write yourself. The big warning for CSV is that you have to be careful to avoid commas in your Excel string-type cells, because they would be interpreted as 2 cells.

Report message to a moderator

Re: how to read string data from excel file [message #86061 is a reply to message #86009] Fri, 27 September 2013 12:46 Go to previous message
Adele is currently offline  Adele
Messages: 4
Registered: September 2013
Junior Member
Thank you very much, but unfortunate it can not be saved as CSV file. the string-type cell showed as XXXXXX in csv file.




On Monday, September 23, 2013 10:55:19 PM UTC-4, kagol...@lbl.gov wrote:
> If it's possible to have Excel output the data as CSV (comma-separated values) then you can read it with read_csv() or read_ascii(), for example, or a text-file reading script you write yourself. The big warning for CSV is that you have to be careful to avoid commas in your Excel string-type cells, because they would be interpreted as 2 cells.

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: multiline .compile syntax for a batch file
Next Topic: Re: map_image and latmin/latmax, lonmin/lonmax - edges or centres?

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Wed Oct 08 15:07:22 PDT 2025

Total time taken to generate the page: 0.00433 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.7.
Copyright ©2001-2013 FUDforum Bulletin Board Software