Developed in LabVIEW Ver 7.1 this vi contains the necessary code to format an array of data (DBL) that is normally written to a flat tab delimited file to a predefined Excel Spreadsheet that is read by Canary Labs Historian.  The data in the spreadsheet is always logged to the same cells and is overwritten at the rate the vi runs.  It is best to extract the code in this vi and place it in your vi to accommodate your specific needs.

This vi was developed specifically for writting data form R&D tests to Canary Lab OPC Historian.  The same data that is written to flat file (tab delimited) on a daily basis is linked to the code in this vi which updates specific cells in a spreadsheet at the speed at which the vi runs.Important Excel issues:LabVIEW opens the Excel Spredsheet in the background.  If some opens Excel to view any spreadsheet and closes the application it will stop the vi.  To correct this implement the following changes.To make excel open each spreadsheet in a different instance, and thus only close the current one when you click the "x": change the file association stuff in windows. Go to explorer, choose tools, then folder options. Click the File Types tab. Scroll down to the XLS extension. Click the Advanced button. Choose "open", then click the edit button. At the end of the "Application used" entry, you'll probably see: /e After this, add: "%1" (be sure to include the quotes.) Should look like /e "%1" be sure to put a space after e Then uncheck the "Use DDE" checkbox. Then click OK. (Windows re-checks it at some point for some reason, but it still works)OK your way out of the file types dialog.Now when you double-click a spreadsheet, it will open it in a new instance of Excel.