Error code -2146827284 when trying to programmatically...
Robert M
You are probably getting this error because you are trying to access
cells outside the maximum range in Excel. A Microsoft Excel
spreadsheet is limited to 256 columns and 65,536 rows. This <a
href=http://digital.ni.com/public.nsf/websearch/23EF6DD43866726C86256D5C00687E51?OpenDocument>Knowledge
Base</a> has further information.
If you are interested in a more robust data tool for managing,
inspecting, analyzing and reporting test Data, check out <a
href=http://sine.ni.com/apps/we/nioc.vp?cid=5050&lang=US>DIAdem</a>.
It can handle data sets with over 1 billion values.
If none of these suggestions help, or if I’m not correctly
understanding your issue, please post the software and versions you
are using, the applicable portions of your code, and any other
information that may help, and I’ll be happy to look further into it.
Have a nice day!
Robert M
Applications Engineer
National Instruments
Robert M
It appears the code you attached this last time is significantly
different from what you attached before. In your “Create Chart”
subVI, after wiring Range.Cell2 to Cell2, it seemed to run without
errors. When you make that change and run it, does the chart appear
as you want it?
Robert M
I can give you a few suggestions, but it looks like this is an Excel
error, and not a LabVIEW issue. msdn.microsoft.com has some excellent
resources for the ActiveX controls for Excel.
Are you using this vi as a subVI of a larger program? In the code you
gave me, the cells you reference, A2:A4 and C2:C4, appear to be from a
new sheet you call temp, and are empty. Maybe XValues only takes a
range of cells with values. You’ll have to look that up.
One discrepancy I noticed, which you may already know about, is how
you reference both the “range” invoke nodes. You send “A2:A4” and
“C2:C4” to cell1, and nothing to cell2. Do you need to send A2 to
cell1 and A4 to cell2? When changing this, I still get the same
error, but that may be because all those cells are empty.
If you do a lot of Word and Excel report generation, you may be
interested in the <a
href=http://sine.ni.com/apps/we/nioc.vp?cid=5769&lang=US> LabVIEW
Report Generation Toolkit for Microsoft Office</a>.
Let me know if nothing here helps, and I’ll see what else I can find
out. Have a nice day!
Gavin Braithwaite
indeed that there was no data in those cells. Since I could set one
range successfully on blank data I assumed that was the case
generically. Obviously not, and I can't see that documented anywhere.
Never mind, I think I have it beaten now. Thanks for all your help,
Gavin
analog
This is what I used and it seems to work. But I have an extra series
in there for some reason.
Good luck