Labview report generation toolkit and Excel

[Localfolder]

Hello,

I have an issue within my application.

I use the Report generation toolkit to populate an excel template report.

Works fine under dev mode on my computer.

Works fine in build mode on my computer (I have included the _Excel Dynamic VIs.vi).

Works fine in build mode on another computer (old installation)

But :

Dont works in build mode on a computer with a fresh installation.

The application start, open the excel template, populate(i guess its to fast to notice) the report but doesnt save the xls or pdf.

Using Labview 2018 to build

Runing on W10 Excel 365 + runtime 2018 + daqmx 19

What i am missing ?

Thanks for your help,

L

[aputman]

Did you check file permissions where you are trying to save the report?

[Frozen]

Are you sure Office is available and licensed on the alternate computer?

[Localfolder]

Hi;

With my test vi, I try to create files directly in the application folder, I guess I have the rights, I copied files in this folder 2 min before running the app.

Office is available, I tested it with a manual report creation with the template, saving and PDFing were Ok.

Regards,

L

[BertMcMahan]

Could be a bitness issue- in my experience, the Report Generation Toolkit in LabVIEW 32-bit doesn't work *at all* with Office 365. (If anyone has a tip on that one I'd appreciate it...)

Edit: I just saw you mentioned the application folder. Try either running your executable as admin, or changing the folder location to somewhere definitely writeable, like the desktop. Generally, *installed* executables don't have write access to their application folders.

[Localfolder]

Hi,

I tried multiples folder and Running with administrator rights. same issue.

I still cant figure why it works with an old pc (w10+365+runtime 2018+daqmx19) and not with the new one.

Rgds,

L

[Localfolder]

Hi,

So I merge my error output to see if there is a difference between all my pc.

And yes.

On the computer where my app dont work I get the message :

"Membre introuvable.
in NI_Excel.lvclass:Excel Find and Replace (str).vi->testreport.vi"

I guess I will look into this.

Regards,

L

[Bob_Schor]

Are you getting an Error message?  Microsoft changed the properties of Excel, which generates a "fixable" Error in the LabVIEW code (posted numerous times in this Forum, including several times by me).  If this is the case, a search on the Error would, I imagine, find the fix ...

Bob Schor

[Localfolder · Accepted solution]

Hi,

I replaced all "Excel Find and Replace" VIs that seem to produce errors by "Append Report Text" VIs

I have to use Office parameters to place the text Ihave where I want, witch is less convinient than find and replace a key string but finally it works as attended so I consider myself satisfied.

Thanks for the support,

L