LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Write to spreadsheet

I am using write to spreadsheet.But y is the data alignment not proper initially?Please have a look at the attachment?
0 Kudos
Message 1 of 8
(3,949 Views)
It would help if you posted your code. It would seem you are calling two different instances of the Write to Spreadsheet File and using different delimiters.
0 Kudos
Message 2 of 8
(3,944 Views)
All fields are separated by single tab characters, but you are opening it in a word processor, that probably has tabs spaced in a user defined way.
 
You simply need to change the tab spacing in your application (MS word) such that there is enough room for each field. It seems numbers with 6 digits overlap the next tab setting, so the tab character makes it align to the next tab instead. Your problem is with MS office, not with LabVIEW.
 
Make you font smaller, space the tabs further apart, etc.
 
Open your file in e.g. excel and everything will be OK. 🙂


Message Edited by altenbach on 07-04-2008 10:14 AM
0 Kudos
Message 3 of 8
(3,940 Views)
Wow sir dennis and the dennis to be answering my question,i am honouredSmiley Surprised

Please see the attachment
0 Kudos
Message 4 of 8
(3,930 Views)

As I said, this is not a LabVIEW problem, just a display issue of MS word.

Of course your program could use a few improvements, for example:

  • You don't need to check for the array size, because the "search index= -1" always wins.
  • There is a +1 primitive.
  • Growing arays at an autoindexing output tunnel of a while loop is not necessarily efficient because the code cannnot know the final size.
0 Kudos
Message 5 of 8
(3,912 Views)
And here's a better way to find the indices of all elements that are 255.
 
This is much more efficient in terms of memory, because the size of the output array is known from the start and thus can be allocated once.
 
 

Also, your code adds an element with -1 at the end of the output array, something that is probably not very useful.

Message Edited by altenbach on 07-04-2008 11:35 AM
Message 6 of 8
(3,905 Views)
Thanx altenbach. U r right.When i open it using excel i dont have any problem.
0 Kudos
Message 7 of 8
(3,875 Views)

Wow sir dennis and the dennis to be answering my question,i am honoured

Please see the attachment


Why has someone rated this ???????
0 Kudos
Message 8 of 8
(3,816 Views)