Excel Easy Table changes column width

[dstack]

I am using Excel Easy Table to insert

an array into an excel report template I already have.  When I do this, the column width on the excel report changes.  How do I get the column width to not change?

[A.Thomas]

I usually use an add-on toolkit for writing to Excel. It's fairly easy to use and never causes such issues, but it's not free. You can find it here: http://www.aledyne.com/product/spreadsheet-express/

It has a 30-day trial period. I also want to add that I'm not affiliated with Aledyne Engineering in any way, I'm just their happy customer.

[dstack]

Thank you for the recomendation!  Unfortunately, I doubt my employer will go for that (but I will try).

Alternatively, do you know another way to solve this?  I have setting my desired colulmn width in excel then using the "protect sheet" option in excel.

This prevents any Report Generation > Excel Specific functions from operating.

In addition, I have tried font manipulation which also seems to not drive the change in column width from LabVIEW.

Thanks

[Gryffindor]

There is another VI called Append Table to Report.vi. There is a column width setting where you can can elect to not have the column change widths if you are using a template. For an example of how this VI is used you open the Excel Report-Conditionally Formatted Spreadsheet.vi Example from the LabVIEW Help Menu.

[ben64]

---

@Gryffindor wrote:

There is another VI called Append Table to Report.vi. There is a column width setting where you can can elect to not have the column change widths if you are using a template. For an example of how this VI is used you open the Excel Report-Conditionally Formatted Spreadsheet.vi Example from the LabVIEW Help Menu.

---

Append Table to Report.vi is used in the Easy Table.vi. If the column width is not specified (using default value of 1) the default width will be used (12.86 units when I tried it).

The simple workaround is to select your template range, right-click it, go to the protection tab and uncheck "Locked".

Then right-click the sheet tab, select protect sheet and allow the user to do everything except "format columns". Save your template.

When you run the code Excel will now throw error 0x800A03EC. Use the General Error Handler.vi to cancel this error on match.

Ben64

[ben64]

---

@ben64 wrote:

---

@Gryffindor wrote:

There is another VI called Append Table to Report.vi. There is a column width setting where you can can elect to not have the column change widths if you are using a template. For an example of how this VI is used you open the Excel Report-Conditionally Formatted Spreadsheet.vi Example from the LabVIEW Help Menu.

---

Append Table to Report.vi is used in the Easy Table.vi. If the column width is not specified (using default value of 1) the default width will be used (12.86 units when I tried it).

Ben64

---

I looked at the help file for the Append Table To Report.vi (first thing I should have done) and it specifies that if you are using a template set the column width input to -1 to let it unchanged.

Ben64