Read multiline excel cel (text)

[suresh_37]

Hi,

I am trying read a excel sheet which has text data and some of them are multi-line cels (entered with ALT+Enter).  How do I read this to a array ... multi-lines cels are seems to be disorganizing the arra...

please advise

[Mathan]

Please post what you have did so far, so that it will be easy to help you.

[Mathan]

Read this thread and provide your comments if it helps you.

[suresh_37]

Hi mathan, thanks for the reply...

here is what I have sofar...(see attached ZIP file).  ZIP contain a VI and a excel file... please select the path to the excel file and run... I have indiacted in the file the format that I like have..

please advise if this can be done.

thanks

[Mathan]

Hai suresh,

How you entered the data in cells B2 and C3?

Is there just a space in between [one three] and [134 145]?

This works for me. Please explain me if it was right?

[suresh_37]

Hi Mathan,

Some cells will have multilines (\n... with the use of ALT+ENTER key stroke).  I belive when I am reading the file the"\n" is creating a problem.  The excel file is created by some other process and I am trying to utlize the file as it is.

onother thought...

can activex used to find the cell range of a workbook... like what is the range of Col and Row that has data.  If I know the cell rage, then I should be able to read data cell by cell and replace any "\n" with some other char.. then I guess I should be able to write to a table.

thanks

//Suresh

[smercurio_fc]

First off, you are not reading an Excel file. You are reading a text file. That's a big difference. The inclusion of the linefeed means that you have to parse the file manually. The built-in Read From Spreadsheet File will treat the linefeed as a new row. The attached VI is one way you can do this.

You can also read the original Excel file directly, but that requires ActiveX. There are a couple of shipping examples showing you how to use ActiveX with Excel. You can also look over the Excel thread. 

[Zinnium]

I actually have a method of reading and writing directly from excel sheets without the activeX.  This includes the 2007 format.

Is this really desired?  I have been joking about selling it for the last year to two.

[Zguljo]

So, would you be so kind to provide us the solution?

Pretty please.. 🙂

Regards,

Vedran