How Can I Keep the Default Cell Appearance of Excel Sheet?

Updated Nov 8, 2019

Reported In

Software

  • LabVIEW
  • LabVIEW Report Generation Toolkit

Issue Details

I am using Excel Easy Table to add data on excel sheet, however, the cell border disappears after the addition on excel.
I want to keep the default appearance of tables on excel sheet. Is there any way to do so?

Solution

Follow the following steps to keep the default cell appearances on excel sheet.
  1. Add Excel Set Cell Color and Border after Excel Easy Table
  2. Set the input parameter for inside border (T, xlThin, D2D2D2) as shown in image below

Additional Information

The cell border appearance changes after using Excel Easy Table due to the default values as shown in the image in solution. 
You could implement the suggested value to keep the appearance the same after adding table from LabVIEW. 

WAS THIS ARTICLE HELPFUL?

Not Helpful