How to write spreadsheet with number and string?

[hugoliang]

Dear All,

I want to write spreadsheet not only with number but also with string.

But the write to spreadsheet file.vi only accept 2D array.

I only want to insert a line to display the unit of the row.

Is there any good way?

Thank you very much.

[Nishant]

Dear Hugoliang,

       you can use the "Array to Spreadsheetstring"  vi to  convert the Array into the  Spreadsheet string or either you can convert  your  string into Array with  "Spreadsheet string to Array", and you can get both the vi in string  palette in block diagram. Hope this helps.

Thanks,
Nishant

[hugoliang]

Thank you for your reply.

I have written an 2D-array to the spreadsheet, I only want to insert a line to display the unit of the row.

The array is number. I see that it is impossible that the number and string in one array.

Is there any easy way?

Thank you!

帖子被hugoliang在08-24-2006 07:41 PM时编辑过了

帖子被hugoliang在08-24-2006 07:42 PM时编辑过了

[albertm]

Hi,

Convert the number to a string and then put it in an array of strings.  Then use <b>Array to Spreadsheet String</b>.

Albert

[LipingZhao]

Could send your code to liping.zhao@gmail.com?

You could also use Chinese to post your question on http://forums.ni.com/ni/board?board.id=2170 

🙂

[hugoliang]

Thank you for your reply!

Under albertm's suggestion, I have solved the problem.

Next time, I will try chinese forum.

Thank you.

[paul821102]

Two files:

First such as:

SN:a

WL    PDL 

1590     0.32

1600     0.45

Second such as:

SN:a

WL  PDL

1590    0.03

1600    0.04

I want to get a result such as:

SN:a

WL  PDL

1590  0.29                                             (0.32-0.03)This I don't need

1600  0.41                                             (0.45-0.04)

How can I get it? Any suggestion?

[tbob]

Read first 3 lines using Read Lines From File and write them to a new file.  Use Read From Spreadsheet File to read the rest.  Wire the Mark After Read output from the Read Lines to the offset input of Read From SS; this will start the read on the 4th line.  Now you have a 2D array.  You may have to convert to numbers.  Use Index Array and wire a constant 1 to the columns input.  This will give you a 1D array of the numbers you want to subtract.  Do the same for the second file.  Subtract the 1D arrays to get a difference array.  You will also have to index column 0 and use it and the difference array to create a new 2D array.  Write this to the new file.  You will probably have to convert the numbers to strings since the file contains other strings.

[elly.fan@ni.com]

thank you very much