comp.lang.idl-pvwave archive - RDF feed
type: channel
description: Messages from Usenet group comp.lang.idl-pvwave, compiled by Paulo Penteado
items: how to read string data from excel file
items: Re: how to read string data from excel file

how to read string data from excel file
type: item
description: 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
creator: Adele
date: 2013-09-18T14:51:32-00:00

Re: how to read string data from excel file
type: item
description: 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.
creator: kagoldberg
date: 2013-09-24T02:55:19-00:00

Re: how to read string data from excel file
type: item
description: 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.
creator: Adele
date: 2013-09-27T19:46:04-00:00