How to write data from Excel into a Report

[Ghilghi]

Hallo Everyboy,

i want to automatically generate a report with Data from an Excel file.

Information from from Line 1 to 875 should be sown on the report.

The line from

How could i do it?

I have loaded the kind of Exceldata.

Thanks

[annav]

Hi Ghilghi,

to automatically load data in your Report you have to write a Script.

Here are two pages of the DIAdem Help that should help you with this:

Excel-Import- und Excel-Export-Assistent

Objekt: Report

Best regards,

Anna

[Brad_Turpin]

Hi Ghilghi,

If you're interested in the data block starting on line 878, then I'd recommend building a DataPlugin to read in those four columns to four new channels in the Data Portal.  If you're truly interested in the first 875 lines, then probably a straight VBScript is the best way to go-- that's not data you would store in DIAdem channels.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Ghilghi]

Hey,

i have a question.

How could i manipulate the Feld in der first line?

What is the name of the field ? or of the array?

Bye

[Ghilghi]

Hallo Every ,

It ist difficult to write an select Field in the Report,

so the next question is, how could i write Columns in Report.

Thanks a lot.

bye

[Brad_Turpin]

Hi Ghilghi,

I'm not sure what you mean by the word "Field".  That's not a standard DIAdem term, nor is it really a standard Excel term.  Do you mean a DIAdem channel value?  Do you mean a DIAdem REPORT textbox?  Do you mean an Excel cell?

When you talk about writing to a column in DIAdem, do you mean a REPORT table column, or do you mean a column of values in a DIAdem channel?  Typically if you want to create a column of values in a REPORT table, you would create a DIAdem channel with those values and point the table column to display that channel.

You still haven't confirmed that you want the first 875 lines from your data file that don't look like they belong in DIAdem or the remaining lines from your data file that do look like they belong in DIAdem-- which is it?

Brad Turpin

DIAdem Product Support Engineer

National Instruments