LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Error -2147024882 when writing to Microsoft Excel

Every now and then I get an error when writing to an Excel file. The error code is -2147024882. The error description is "Not enough storage is avaliable to complete this operation". Has anyone seen this. I have over 60G of free hard disk space so I am not sure why I am getting this error and it only happens once in a while.
 
Cheers,
Gord
0 Kudos
Message 1 of 4
(3,335 Views)
How many cells are you trying to write.  Its possible you have exceeded the maximum number of cells available in Excel.

What version of Excel are you using?

It may also be possible you are experiencing a memory leak.  Can you confirm this?
Mark
NI App Software R&D
Message 2 of 4
(3,317 Views)
I am using Excel 2003 and LV8.5 running on XP Pro. No I am not writing anywhere near the maximum cell count. I have been doing a bit of debuging / testing on my VI. I have tested the VI by writing a 2D string array (256 columns x 10000 rows) into excel as a range quite successfully. I have encountered that particular error 3 or 4 times now and the latest time I was able to confirm that it happened just after I opened the workbook & sheet. It's very odd, I have been using my VI for several months with no problem and this just started happening in the past week or so.
0 Kudos
Message 3 of 4
(3,309 Views)
Are you using the report generation toolkit?
Mark
NI App Software R&D
Message 4 of 4
(3,295 Views)