Creat a report with excel

[Guillaume]

Hello,

I want create a report usable by Excel.

This report must contain two format of data : 2D string chain and 2D DBL.

The 2D string chain correspond to title of 2D DBL associate.

When I use "Write to a file table" or "Write to a file text", all data are written in format 1D in my excel file.

I have tested the use a template but I don't have same tools which are used in another subject on this forum.

If you want more informations I'm open to your questions.

Ciao

Guillaume

[ASTDan]

Here is one way to do it.

Basicly you use Array to spreadsheet string.vi and save it as a text file. This is a tab delimited file that can be read by excel.

You can also you the NI's Report generation toolkit for more control over excel.

Hope this helps

Dan

[Guillaume]

Ok, thank you

To finish, how can I put each column in different column under Excel ?

Because in this moment all data are in column A.

Ciao

[ASTDan]

I don't totally understand your question but here goes

You could try simply transposing the array. I

f your data was say

A B C

D E F

Transposing would yield

A D

B E

C F

Does that help?

[Guillaume]

Sorry, I was mistaken my programming...

This problem is solved.

Now, i seek a solution for puting in page my Excel file when I open it. (size of cell in function of my data).

Thank and sorry for my english.

Ciao

Guillaume

[ASTDan]

You might want to take a look at the Report Generation toolkit. This gives you programatic access to excel. It will allow you to name sheets, add graphs, etc.

http://sine.ni.com/nips/cds/view/p/lang/en/nid/5769

[SkifIL]

Hello,

I want create a report usable by Excel.

Hello.

I added to your VI some functions for create and save to Excel file.

Regards, SkifIL