labview with macro

[$anman23]

Hi 

Mansi here

I m doing a project on "warehouse monitoring system using wireless load cell".

In this i have to do only stock management. For that want to make excel sheet. the excel sheet 's format is attached.

Nw confused in how to make this excel sheet. What should i use? LV, Excel Macro or both's combination. Pl hepl me out, done so much search but nt get sucsses.

[Bob_Schor]

What is the connection with LabVIEW?  Are you using LabVIEW to generate the data that you then want to write into an Excel Workbook?  Do you want to create a new Workbook with LabVIEW or add data to an existing Workbook?

The Excel-specific functions in the LabVIEW Report Generation Toolkit make reading and writing Excel Workbooks fairly easy.  It is, of course, easiest if you do "simple things", like only write numeric (or other) data that are already in the proper array format.  In your case, if you had the Workbook example you showed, it would be easier to write the data starting in Row 6, leaving it to Excel to design the basic Workbook with the headers already filled in a formatted as you want. 

[$anman23]

hi Bob

thank u for reply

For the wireless communication i am here using the zigbee technology. So Loadcell is transmit the data using zigbee devices. Pc contains ETRX3USB stick. which is showing com port id. So data will come by choosing the com port id.

I want the data should be written directly in to the excel sheet and should be autosaved.

refering the previous asked question and disscusstion i have download the FGExcel toolkit. But dont know how to install it. 

Can you help me in installing it? Attaching the toolkit.