Messages from Usenet group comp.lang.idl-pvwave, compiled by Paulo Penteado
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
Re: how to read string data from excel file
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.
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.