to store data in excel format using write to spreadsheet file

[Veena]

I get to store a 2d array of data using the write to spreadsheet function.When I open the excel file later and do some modification and want to save them bac, I get a series of file dialog asking to be saved in excel format.How to i override this and get to store my 2d array in excel format directly instead of in the text format as done by the write to spreadsheet function.

[RayFarmer]

Hi,


You will need to store your data directly to an excel sheet via activeX.

Try looking at the examples with LabVIEW in particular Write Table to XL.vi found in C:\Program Files\National Instruments\LabVIEW\examples\comm\ExcelExamples.llb.

Also, you might try doing a search in this forums as I know there has been questions like this before and there are probably more examples.

Hope this helps.
Regards
Ray Farmer