LV2014 64bit missing Word Excel report generation

[richjoh]

I realized that LV2014 Professional version 64bit does not include the Word specific and Excel specific report generation VIs. I open the 32bit version and whalla Word and Excel are in the report generation pallette.

Do I just copy the library from 32bit folder over to 64 bit folders to make this appear? What the library name?

Rich J

[DevonR]

Have you tried reinstalling the report generation toolkit?  If not, could you please follow the steps in this KnowledgeBase article:

http://digital.ni.com/public.nsf/allkb/986243270824BD188625722C0070CC4B?OpenDocument

Please let me know if this works for you. 

Regards,

DevonR

[natasftw]

http://www.ni.com/gate/gb/GB_EVALTLKTREPGEN/US

You should be able to download the toolkit there.  2014 is apparently the first version of the toolkit to offer 64-bit support.

[richjoh]

"2014 is apparently the first version of the toolkit to offer 64-bit support"

Are you sure about that? I have 2014 toolkit, Word and Excel specific VIs are there for 32bit not in 64bit though, unless thisis a recent change.

Rich J

[natasftw]

http://www.ni.com/white-paper/10383/en/#toc3

That says 2014.

Did you try installing the toolkit by itself?

[thutch79]

I'm in the same situation. I'm trying to use some of the ms office function in 64bit Labview. I have an active service request open and they are investigating. Here's what I tried so far (all versions are 2014):

1. Installed Dev Suite

2. Installed 64bit Labview

3. Tried reinstalling the dev suite to allow the toolkits to recognize the 64bit version of LV

4. Uninstalled/reinstalled MS office to switch from 32bit office to 64bit. This made sense to me and I figured this would fix the issue, but no luck.

5. Tried uninstalling the toolkit and reinstalling using the standalone installer for the toolkit.

No luck so far and the NI engineer is investigating. I'll report back when/if I learn anything more.

[thutch79 · Accepted solution]

I found that there is a seperate installer for a 64bit version of the toolkit. Hope this helps.

http://www.ni.com/download/labview-report-generation-toolkit-for-microsoft-office-2014/5006/en/

[Darren]

[edit] nevermind, y'all figured this out. 🙂

[richjoh]

I went ahead, dug through MS office Dev Center and looking at Excel 32bit example, I created my own Excel write data and write data and plot chart.

See attached 64bit LV 2014 zipped VIs below. Here's how they work,

"OpenMSExcel" - open Excel then adds an unused sheet.

"WriteExcel" - takes a 2D array (or 1D), creates a new sheet if the name does not exist or to named sheet, writes the data to Excel sheet.

"'WriteExcelChart" - same as above but adds option to plot the Excel data using your chart type. Both WriteExcel VIs are reentrant this way your able to run seperate code modules that continue writing where the last write line ended. This VI will have some code I stripped out, modify as needed.

"ExcelRefsGetSet" - action engine caches references, no need to wire Excel VIs in your code.

"CloseExcelRef" - must use to close Excel reentrants refs when done.

Rich J