topic Re: Executable will not WRITE to spreadsheet in LabVIEW

Executable will not WRITE to spreadsheet

Murph — Fri, 04 May 2018 15:38:05 GMT

LV2016.

Application reads from XL spreadsheet, finds a field based on searching row label, pulls and manipulates data, then updates one field of the spreadsheet.

Works like a charm in development mode. I've also ran the exe on the pc running LabVIEW.

Transported to target PC, installed runtime libraries. Nothing errors.

Calls spreeadsheet, pulls data as expected but will NOT write back to it!

Re: Executable will not WRITE to spreadsheet

Gregory — Fri, 04 May 2018 15:54:14 GMT

Are you getting any errors out of your write function? (assuming you are handling your errors).

My first guess would be that the file to be written was installed as "read only", and you don't have permissions to write to it.

Any further guesses would require a look at your code.

Re: Executable will not WRITE to spreadsheet

aeastet — Fri, 04 May 2018 15:56:54 GMT

Depending on what operating system and where you are storing the file, you may not have permission to write to the file. You need to be careful where you place files now in Windows. It does not allow you to edit files in certain locations on your computer without having to do extra work to make it allow access.

Re: Executable will not WRITE to spreadsheet

altenbach — Fri, 04 May 2018 16:10:11 GMT

@Murph wrote:

LV2016.

Transported to target PC, installed runtime libraries. Nothing errors.

Calls spreeadsheet, pulls data as expected but will NOT write back to it!

I don't know what "transported" means. Did you create an installer and install the exe on the target system? What is the actual full path of the file?

Re: Executable will not WRITE to spreadsheet

Murph — Fri, 04 May 2018 16:10:40 GMT

I believe it has something to do with that.

My dev station is Windows7, the target machine is Windows10

I am doing file exchange with a folder called C:\LN Files

Re: Executable will not WRITE to spreadsheet

altenbach — Fri, 04 May 2018 16:13:02 GMT

Yes, newer windows versions discourage the use of the root folder. Does it work if you run the exe as administrator (right-click...run as administrator). Even if you have admin privileges, the exe might not.

Re: Executable will not WRITE to spreadsheet

Gregory — Fri, 04 May 2018 16:37:48 GMT

I would create an installer, then select the file you want the user to be able to write to (here it is config.ini) and check the "unlock" button.

Re: Executable will not WRITE to spreadsheet

Bob_Schor — Sun, 06 May 2018 10:10:03 GMT

@gregoryj:

Thanks for the picture. I've built a number of executables, but have not (yet) had to "drill down" to such detail to even realize that all those settings were available.

My tendency has been to keep "rarely-changed" data, such as Configuration files, in "User-space", either in a defined Public Folder (which is where I tend to install the Executables, e.g. <Public>\LabVIEW Builds\<Project>\<Executable>\<Files go here>) or in a defined Data Folder accessable to the User. So far, this has worked well and has required little variation in going from Windows XP -> Windows 7 -> Windows 8.x -> Windows 10. But next week, Microsoft could change the rules yet again ...

Bob Schor

Re: Executable will not WRITE to spreadsheet

Steffen01 — Sun, 06 May 2018 12:45:19 GMT

default seems to be c:\users\name\Documents, best chance to have write permissions in there.

Other thing could be the document is not closed i.e. held open by something. Plus firewall/virus scanner paranoia towards your compiled version. Seems Windows 10 blocks more things than WIndows 7.

Re: Executable will not WRITE to spreadsheet

Murph — Tue, 08 May 2018 16:47:05 GMT

Frustrating!

I went back and added a bunch of error traps, LV does not generate the error. It appears to be something with Excel itself.

Re: Executable will not WRITE to spreadsheet

Steffen01 — Wed, 09 May 2018 01:51:50 GMT

is it on a network drive, the Excel spreadsheet? What happens, when you open it, does it say something about being protected? Open the spreadsheet yourself, see, if you can edit it, maybe it throws a warning.

Alternatively, can you save as .csv?

How about Open Office?

Some programs I cannot save to my desktop, only into my documents.

Another HD partition an option?

Excel not installed as Admin?

There is a software called "take ownership". maybe do that on the folder where you want to save into.

Recently I tried to get rid of Windows 10 on a laptop, what a pain that was.....

Re: Executable will not WRITE to spreadsheet

Steffen01 — Wed, 09 May 2018 10:12:34 GMT

one more thing, is it Excel 2016? With all that 360 stuff, it takes forever to open the 1st time after PC reboot. Logging in to check, if its still licensed. Maybe run excel first, close, and then try again

Re: Executable will not WRITE to spreadsheet

Murph — Wed, 09 May 2018 12:33:46 GMT

Looks like we are all on the same track.

The dev machine is networked running Windows 7 Enterprise 64Bit, Office 2010

The target machine (that won't work) is a network pc running Windows 10 and Office 2016

Re: Executable will not WRITE to spreadsheet

oscarfonseca — Wed, 09 May 2018 13:38:17 GMT

I read in one of our documents: "Microsoft Excel spreadsheets [...] increased these limits to 16,384 columns and 1 million rows. If these limits are exceeded and there is an attempt to access a row or column outside the allowed range, this error will occur: Error -2146827284 from the Excel_Get_Range VI." - Error 2146827284 Occurs When Writing to Excel Report Using Report Generation Toolkit VIs

Another document states that this can be caused because of the file not being accessible: Error-2146827284: File Does Not Exist When Opening Excel in LabVIEW

Not sure if this could be the problem you are seeing (since it is the same ActiveX error code), but might be worth double checking if the Excel application is being initialized as Minimized, that the amount of samples being written to it is not too large, and that the file or destination can be accessed correctly.

Re: Executable will not WRITE to spreadsheet

Murph — Wed, 09 May 2018 17:15:49 GMT

BINGO!

Kudos to whomever suggested to make sure to NOT select Minimized.

Suggestion to the good folks at NI. Perhaps add this to the help file.