Number Format of Excel Set Cell Format VI

Updated May 19, 2020

Reported In

Software

  • LabVIEW Report Generation Toolkit

Issue Details

I want to change the format of cell in my Excel sheet programmatically. I found Excel Set Cell VI but I do not have any idea which number format I should use.

Solution

The basic idea is using Excel number formatting guidelines as described in the Help page of the function. You can refer to the guideline in proper Website.
Or you can obtain number format programmatically as follows.

1. Prepare test Excel file.
2. In the Excel file, set format which you want to use in your application in the cell A1. In the following example, format is set as Accounting.
3. Use the following program. In Template Excel File Path control, choose the Excel file you prepared. Then run the program.

Note: You can find Excel Get Range.vi in the following path.
C:\Program Files (x86)\National Instruments\<LabVIEW version>\vi.lib\addons\_office\_exclsub.llb

4. You can obtain corresponding number format in Number Format indicator like below. Copy and paste it in number format input of Excel Set Cell Format.vi.