Listware for Excel:US:Processing Range - Revision history

Admin at 23:57, 31 May 2018

2018-05-31T23:57:04Z

@@ Line 1: / Line 1: @@
-[[Listware for Excel:Reference|&larr; Listware for Excel Reference]]
+{{LWEUSNav
+|StepsCollapse=
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+}}
 {{CustomTOC}}

Admin at 21:33, 15 September 2014

2014-09-15T21:33:47Z

← Older revision		Revision as of 21:33, 15 September 2014
Line 6:		Line 6:
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|
	\|-		\|-
	\|[[Listware for Excel:Check and Verify\|← Check and Verify]]		\|style="border-bottom:1px solid #aaaaaa;"\|[[Listware for Excel:Check and Verify\|← Check and Verify]]
	\|-		\|-
	\|[[Listware for Excel:US\|Overview]]		\|[[Listware for Excel:US\|Overview]]

Admin at 21:31, 15 September 2014

2014-09-15T21:31:28Z

← Older revision		Revision as of 21:31, 15 September 2014
Line 2:		Line 2:

	{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"		{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
	! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''US Navigation'''		! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''US Check and Verify Navigation'''
	\|-		\|-
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|
			\|-
			\|[[Listware for Excel:Check and Verify\|← Check and Verify]]
	\|-		\|-
	\|[[Listware for Excel:US\|Overview]]		\|[[Listware for Excel:US\|Overview]]

Admin at 17:48, 7 July 2014

2014-07-07T17:48:57Z

← Older revision		Revision as of 17:48, 7 July 2014
Line 62:		Line 62:
	:<span style="color:red;">'''Note: Listware can only process 50,000 or fewer rows per run.'''</span>		:<span style="color:red;">'''Note: Listware can only process 50,000 or fewer rows per run.'''</span>

	[[File:~~LWE_US_50kFewer~~.png\|link=]]		[[File:LWE_50kFewer.png\|link=]]


	[[Category:Listware for Excel]]		[[Category:Listware for Excel]]

Admin: Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

2014-07-03T22:04:30Z

Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

New page

[[Listware for Excel:Reference|← Listware for Excel Reference]]

{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''US Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Listware for Excel:US|Overview]]
|-
|[[Listware for Excel:US Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:US:Processing Range|Processing Range]]
|-
|[[Listware for Excel:US:Cleansing Operations|Cleansing Operations]]
|-
|[[Listware for Excel:US:Input Columns|Input Columns]]
|-
|[[Listware for Excel:US:Output Columns|Output Columns]]
|-
|[[Listware for Excel:US:Reporting|Reporting]]
|-
|[[Listware for Excel:US:Review Settings|Review Settings]]
|-
|[[Listware for Excel:US:Processing|Processing]]
|-
|[[Listware for Excel:US:Review Results|Review Results]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

{{CustomTOC}}

[[File:LWE_US_ProcessingRange.png|link=]]

Select the range of cells in your worksheet that you would like to process, then click the 'Select Data to Process' button.

Once you have selected your processing range, the following fields will be populated:

;Workbook
:Displays the workbook (file name) of the data you have selected.

;Worksheet
:Displays the worksheet (e.g. Sheet 1) of the data you have selected.

;Range
:Displays the range of data you have selected (e.g. A1:E10).

:<span style="color:red;">'''Note: Listware can only process 50,000 or fewer rows per run.'''</span>

[[File:LWE_US_50kFewer.png|link=]]

[[Category:Listware for Excel]]