12-05-2008 09:24 AM
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
12-05-2008 11:07 PM
12-05-2008 11:53 PM
12-08-2008 02:53 PM
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
12-09-2008 01:04 AM
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?
12-09-2008 08:33 AM
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
12-09-2008 09:09 AM
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.
01-02-2009 10:01 PM
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.
01-20-2009 03:45 AM
So, would you be so kind to provide us the solution?
Pretty please.. 🙂
Regards,
Vedran