You are correct, that Revised Generate Excel Report example doesn't treat how to open an Excel File and read from it. Sigh, I overlooked that part. It's sort of a "hidden secret" that NI has not publicized. There are some "tricks", and difficulties along the way, particularly if you want to update an existing Excel Workbook (to say nothing of a Workbook with multiple Worksheets), but I'll try to get you started.
Let's assume you have an Excel Workbook with a single Worksheet. Let's also assume that the Worksheet is a rectangular array of floats (I'm assuming no Row or Column headers, to keep it simple).
Do the regular Create Report, specifying an Excel Report. Notice the input below Report Type, namely "Template". This is where you specify the Excel Workbook that you want to read. But how do you read it? Look in the "Excel General" folder, and insert "Excel Get Data". Wire a 2D Array of Dbl to the Data Type input. The next two inputs allow you to specify the "corners" of the rectangular region of the Workbook you want to read -- if you leave them both blank, it will read the entire Workbook into and M x N array of Dbl.
Now you have your Excel data. I recommend (for now) that you close this Excel Workbook and (using a different name) Generate a Revised Excel Report using the techniques in Revised "Generate Excel Report", saving the Excel Data as processed by your LabVIEW code.
Bob Schor
