Hello Father Priest,
I think that your posting has two main questions. The first is that you are getting some empty cells when populating your excel spreadsheet, why?, and the second is that you'd like to copy one worksheet to another, how?.
The first question is hard to answer because there is no reason why if you populated a cell with data, that the data is not there. I would check your code to make sure that the cells that you are populating are the ones that you are selecting.
The second question can be answered, and there are a couple of different ways that you can perform this action. The first, and easiest way to copy a worksheet to another worksheet is to actually create a macro in Excel that selects a worksheet, selects all cells, copies the sel
ection, then selects the next worksheet, and pastes the data. You can make this macro using Microsoft Excel's Macro Creation tools. You can make your own Excel Macro by going to Tools>>Macro>>Record New Macro. Then you just start recording actions, perform the actions that you would like the macro to perform, then stop the macro with the Macro Editor's stop button. Save the Macro. You can call that macro in your LabVIEW Program using the Report Generation Toolkit built-in VIs.
Your Macro's code will probably look something like this:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 8/7/2001 by Dan Hoar
'
'
Sheets("Sheet1").Select
Cells.Select
Selection.Copy
Sheets("Sheet2").Select
Cells.Select
ActiveSheet.Paste
End Sub
But depending on what your worksheet names are, etc., it might look different.
I hope this helps you out. Have a great day.
-Dan Hoar
Applications Engineering
National Instruments