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.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Inserting formula in Excel cells, generating plots, adjusting the cell's text alignment (center, right, and left), and saving file using ActiveX

Hello, 

Since I don't have the Report Generation toolkit for Excel and I couldn't find more examples on how to do this

using ActiveX I need help in:

 

- How to insert a formula into Excel Cell(s)

- Selecting cells to insert plot(s) (polar and rectangular) from them.

- Adjusting the alignment of the text in the Cell(s). 

- Saving an excel file to a directory

 

Thank you in a advance,

Rifaah

0 Kudos
Message 1 of 6
(2,493 Views)

Are you expecting someone to just hand the code to you without you attempting to do anything on your own?

 

0 Kudos
Message 2 of 6
(2,489 Views)

The attahced vi's are what I have so far and I get stuck in trying to got what I mentioned. I dont need the code but I can't figure out how to choose between the properties to know which one I actually need.

 

Download All
0 Kudos
Message 3 of 6
(2,483 Views)

Go to the NI Code Exchange, select Excel from the most popular search list and take a look at examples. This should help you getting started.

 

Ben64

0 Kudos
Message 5 of 6
(2,466 Views)

Ok I'll try both of these and see what happens, 

 

Thanks for the help.

0 Kudos
Message 6 of 6
(2,451 Views)