comp.lang.idl-pvwave archive: archive » how to read string data from excel file

Home » Public Forums » archive » how to read string data from excel file

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: how to read string data from excel file [message #86061 is a reply to message #86009]

Fri, 27 September 2013 12:46

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

[Message index]

		how to read string data from excel file By: Adele on Wed, 18 September 2013 07:51
		Re: how to read string data from excel file By: kagoldberg on Mon, 23 September 2013 19:55
		Re: how to read string data from excel file By: Adele on Fri, 27 September 2013 12:46

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) ] [

] [

]

Current Time: Sun Oct 12 13:18:39 PDT 2025

Total time taken to generate the page: 0.40190 seconds