distribution with the report generation toolkit

[jimstew]

I am using the LabView report generation toolkit to put data into an Excell spreadsheet. It works fine in Labview and the executable works on my development PC, but not on a client PC - it opens a template XLS spreadsheet OK but does not insert the data.

I have included the required dynamic vis in the application builder and checked 'NI Reports Support' in the installer settings.

LabView 7.1

Thanks,
Jim/.

[Elsa Fung]

did you include the report generation libraries?

http://forums.ni.com/ni/board/message?board.id=170&message.id=175651#M175651

[jimstew]

Elsa,
I have tried adding all four llb files to the application builder as support files, but this did not change the results.
Still no joy.
Thanks for your reply,
Jim/.

[Bob_Y.]

Is it a different version of Excel?  I have had problems with different versions of Microsoft Office products not connecting or behaving correctly.  That it opens the template seems to indicte that this is probably not the problem, but it is something to check.  There have been many posts about that problem here, so if that is what is going on, the solutions may be here as well.

Let us know what you find.
Bob Young

[jimstew]

It's the same version of Excel (2000).
Thanks anyway,
Jim/.

[jimstew]

I have found the problem - it's nothing to do with the distribution (sorry), but a bizarre problem with exporting data to Excel.

Here's the new problem:
I am sending a 2D array of data to a spreadsheet cell using 'Append table to report.vi' (part of the report generation toolkit). I want to specify a particular cell on a particular "sheet" (spreadsheet page), so for the string parameter "name (excel)" in the "MS Office parameters" cluster, I use the syntax 'SheetName'!CellName (e.g. 'Sheet1'!A1). This will only work for ONE of the sheets in the spreadsheet file, and the only one it will work for is the one which had its name edited most recently!

To put it another way if you use a new spreadsheet file, you can only send data to a cell on 'Sheet1'. Now if you change the name of 'Sheet2' (right click on the tab at the bottom and select 'rename'), save the xls file and start again, you cannot put data into 'Sheet1' anymore, but you can put it into the newly named sheet.

I can work around this, but it's not very user friendly for my customers, so a solution would be great!

Jim/.

[jimstew]

Oops, got it a bit wrong again! Ignore everything above.
For the purposes of accuracy - in case someone has this problem in the future...

Using this method I can only put data in the sheet that was foremost (visible) when the xls was saved. If I try to put data in any other sheet, I get an error.

There, closure, at last I can move on!
Jim/.