LabVIEW Excel Report Generation

[BigAl34]

Hi,

I am using the LabVIEW Excel Report Generation toolkit and I have about 15 worksheets to make inside of the created workbook. Right now I can do this and everything seems to be working but since I create 2 graphs per page I am generating 30 graphs! Generating these graphs appears to be the slowest part of the process.

Are there ways to optimize creating a large Excel workbook? Since I am creating multiple worksheets, if I can do this in parallel, it would dramatically speed things up as right now I am doing it in series. 

I am also expecting that it is going to be suggested to create the graphs in LabVIEW and insert them in. I need the charts to be connected to the data in the worksheet though so this would not be the preferred solution. 

Any solutions to speed up report generation? Are templates faster? Can worksheets be created and added in parallel?

[Bob_Schor]

I really like using the RGT to create graphs in Excel.  Yes, it is a little slow (think about the data passing back and forth with Excel, and LabVIEW running Excel), but it's a good time to have some coffee, take a walk, talk to a colleague, while your computer grinds away producing lots of nice graphs for you.

Consider the alternative of entering all of the data yourself into an Excel WorkSheet, pulling up the Graph tool, specifying the axes, the labels, etc., and doing it for 50 data sets, each one coming from another data file.  Can you say "tedious"?

Bob Schor

[BigAl34]

If it was me as the end user, I would agree. It is a nice time to take a break and stretch the legs. 

However, since it is for a client and they are complaining about the time it takes to generate the report (a bit unfounded as you mention how much faster it is than doing it manually...). This is why if possible I would like to speed up the process and not just settle for it is what it is.