<span =“apple-style-span” style="color: rgb(51, 51, 51); font-size: 12px; border-collapse: collapse; font-family: arial, helvetica, sans-serif; "><div =“jive-content-er clearfix” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 15px; margin-right: 15px; margin-bottom: 15px; margin-left: 15px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 10px; padding-left: 0px; min-height: 0px; border-bottom-style: dotted; border-bottom-color: rgb(187, 187, 187); : relative; background-: initial initial; background-repeat: initial initial; "><div =“jive-content-title” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 0px; margin-right: 100px; margin-bottom: 5px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-: initial initial; background-repeat: initial initial; ">
From Excel to LabVIEW with style
<div =“jive-content-er-version” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; : ; right: 0px; top: 0px; text-trans: uppercase; background-: initial initial; background-repeat: initial initial; ">版本 6

<div =“jive-content-er-details” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 0.8889em; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 5px; margin-right: 0px; margin-bottom: 5px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; color: rgb(102, 102, 102); background-: initial initial; background-repeat: initial initial; ">?建于: 2010/10/9 下午 12:33 作者
GriffinRU - 最后修改: 2011/6/8 上午 10:17 作者
GriffinRU<div =“jive-content-” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 15px; margin-right: 15px; margin-bottom: 15px; margin-left: 15px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; overflow-x: auto; overflow-y: ; : relative; background-: initial initial; background-repeat: initial initial; "><div =“jive-rendered-content” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 2px; padding-right: 2px; padding-bottom: 2px; padding-left: 2px; overflow-x: visible; overflow-y: visible; : relative; background-: initial initial; background-repeat: initial initial; ">
From Excel to LabVIEW with style.
Simple, one layer example, of passing Excel’s cell properties to LabVIEW table control.
Download example.xls and Table DropDown.vi into the same directory, run VI.
Edit Excel spreadsheet and re-run VI again.
Current example loads data from Excel’s cells A1:C5, obtains cell’s background color from A1 and validation data from 5th row only. In LabVIEW spreadsheet name passed as Table caption (on the bottom), data from A1:C1 passed to LabVIEW table as headers and A1’s background color as headers background color, validation data passed to combobox strings.
Following this example more advanced interface, expanded to all rows and colums with tracking changes on-the-fly, can be created. More features, like Font type, style, alignment and such can be passed as well.
10.16.2010 Update…
Table DropDown ver.2.vi
Quick and dirty implementation of how to:
- obtain last record from Excel (i.e. reading not fixed 5 rows but as many as spreadsheet holds)
- read cells comments and pass them as tip strips
- get all validation data from spreadsheet and apply it in LabVIEW to appropriate table cells only (current example limited to column B)

<div =“jive-attachments” style="font-family: arial, helvetica, sans-serif; background-image: url(
http://www.ni.com/images/clearspace/global/ni-overview--bg.gif); background-attachment: scroll; background-origin: initial; background-clip: initial; : white; border-top-width: 1px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 15px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 10px; padding-right: 5px; padding-bottom: 10px; padding-left: 5px; border-top-style: none; clear: both; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; background-: 50% 100%; background-repeat: repeat no-repeat; "><strong style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; color: rgb(85, 85, 85); background-: initial initial; background-repeat: initial initial; ">附件:
<li =“ni-attachment-download-item” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 0.8889em; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 3px; padding-right: 0px; padding-bottom: 3px; padding-left: 0px; color: rgb(102, 102, 102); background-: initial initial; background-repeat: initial initial; "><span =“jive-icon-sml jive-icon-doc-labview-vi” style="font-family: arial, helvetica, sans-serif; background-image: url(http://www.ni.com/images/clearspace/global/icons/vi.png); background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: -1px; margin-right: 3px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 2px; padding-right: 0px; padding-bottom: 2px; padding-left: 22px; display: block; float: left; height: 12px; width: 12px; background-: 0% 50%; background-repeat: no-repeat no-repeat; ">Table DropDown.vi (48.9 K) <span =“labview-version” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-: initial initial; background-repeat: initial initial; ">LabVIEW 2009<div =“ni-attachment-downloads-label” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 22px; background-: initial initial; background-repeat: initial initial; ">1,147 Downloads<li =“ni-attachment-download-item” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 0.8889em; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 3px; padding-right: 0px; padding-bottom: 3px; padding-left: 0px; color: rgb(102, 102, 102); background-: initial initial; background-repeat: initial initial; "><span =“jive-icon-sml jive-icon-doc-labview-vi” style="font-family: arial, helvetica, sans-serif; background-image: url(http://www.ni.com/images/clearspace/global/icons/vi.png); background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: -1px; margin-right: 3px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 2px; padding-right: 0px; padding-bottom: 2px; padding-left: 22px; display: block; float: left; height: 12px; width: 12px; background-: 0% 50%; background-repeat: no-repeat no-repeat; ">Table DropDown ver.2.vi (58.1 K) <span =“labview-version” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-: initial initial; background-repeat: initial initial; ">LabVIEW 2009<div =“ni-attachment-downloads-label” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 22px; background-: initial initial; background-repeat: initial initial; ">1,199 Downloads<li =“ni-attachment-download-item” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 0.8889em; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 3px; padding-right: 0px; padding-bottom: 3px; padding-left: 0px; color: rgb(102, 102, 102); background-: initial initial; background-repeat: initial initial; "><span =“jive-icon-sml jive-icon-doc-spreadsheet” style="font-family: arial, helvetica, sans-serif; background-image: url(https://decibel.ni.com/content/4.5.5/images/jive-icon-sprites-sml.png); background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: -1px; margin-right: 3px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; display: block; float: left; height: 12px; width: 12px; background-: -464px -80px; background-repeat: no-repeat no-repeat; ">Example.xls (28.0 K)<div =“ni-attachment-downloads-label” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 22px; background-: initial initial; background-repeat: initial initial; ">1,029 Downloads<li =“ni-attachment-download-item” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 0.8889em; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 3px; padding-right: 0px; padding-bottom: 3px; padding-left: 0px; color: rgb(102, 102, 102); background-: initial initial; background-repeat: initial initial; "><span =“jive-icon-sml jive-icon-doc-labview-vi” style="font-family: arial, helvetica, sans-serif; background-image: url(http://www.ni.com/images/clearspace/global/icons/vi.png); background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: -1px; margin-right: 3px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 2px; padding-right: 0px; padding-bottom: 2px; padding-left: 22px; display: block; float: left; height: 12px; width: 12px; background-: 0% 50%; background-repeat: no-repeat no-repeat; ">Table DropDown LV8.5.vi (61.2 K) <span =“labview-version” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-: initial initial; background-repeat: initial initial; ">LabVIEW 8.5<div =“ni-attachment-downloads-label” style="font-family: arial, helvetica, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; : transparent; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-collapse: collapse; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-size: 12px; list-style-: none; list-style-: initial; list-style-image: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 22px; background-: initial initial; background-repeat: initial initial; ">30 Downloads