From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
04-27-2014 03:04 PM - edited 04-27-2014 03:13 PM
Hi,
There is an example about how to use LabVIEW and ActiveX to programmatically read in Excel data. It uses Range and then by reading Value2 it is possible to read excel values in that range in a specific sheet.
http://www.ni.com/example/28409/en/
Now I would like to write data ( 2D string ) to specific excel sheet. Could you please let me know if there is a way to modify this code to use it for writing to Excel instead of reading
I actually would like to write 2D data to specific sheet of an Excel form. The Read_Excel_Values.llb works perfect for opening an Excel file, specify a sheet and then read the data but I would like to write instead of read.
Thanks
04-27-2014 03:20 PM
04-27-2014 05:43 PM
Could you plz let me know how can I write to a specific Excel sheet using Write to Spreadsheet File?
04-27-2014 05:57 PM
04-27-2014 09:26 PM
There are few examples in the Excel forum but I still couldn't fine any example to write to specific Excel sheet.
04-27-2014 10:26 PM
04-28-2014 03:45 AM - edited 04-28-2014 03:59 AM
04-28-2014 03:23 PM
If you have the Report Generation Toolkit, there are some Excel specific functions for writing values into cells of a workbook.