WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login
Search the WinSPC Knowledgebase Browse by Category
How does a WinSPC Excel Device deal with blank cells?
Article Details

Last Updated
27th of July, 2018

Applies to
WinSPC 8.0, WinSPC 8.1, WinSPC 8.2, WinSPC 8.3, WinSPC 9.0

The Excel device, which, in WinSPC 9.0 and above, can open XLS, XLSX and CSV files, handles blank (empty) cells in the Excel worksheet depending on the features enabled in the device setup for the specific device location that will be processing the blank cell.  A location in the Excel device can either be bounded (meaning it has a specific beginning and end row) or unbounded (meaning it has no specific end row - the user has specified the "End Row"' to be a "*").  In the screenshot below, the "Diameter Location" is a bounded location, while the "Weight Location" and "Shift" are unbounded.

The exact rules for dealing with blank cells are as follows:

Data Locations
  • If a bounded data location encounters a blank cell:
    • If the "Process" option is set to "New", then processing stops for that location.
    • If the "Process" option is set to "All", then that row is skipped.
  • If an unbounded data location encounters a blank cell, then processing stops for that location.
Tag Locations
  • If a bounded tag location encounters a blank cell, a blank tag value is then used.
  • If a unbounded tag location encounters a blank cell, then processing stops for that location.

kb153figure01a.png
Attachments
No attachments were found.
Related Articles
Visitor Comments
No visitor comments posted. Post a comment
Post Comment for "How does a WinSPC Excel Device deal with blank cells?"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Your Name:
   Email Address:
* Your Comment:
* Enter the code below:
 

All Content 2012 DataNet Quality Systems. All Rights Reserved.