YOUR ALTERNATIVE BI
PARTNER
Reporting and data analytics from any kind of data source - OLAP, SQL server, Oracle, DB2, SAP, API, REST, SOAP
HP ALM reporting and optimization
Robust Power BI interactive reports
MS Excel front ends & tools with advanced VBA
Data transformations
Robotic process automation with Selenium / PowerShell / Power Automate

Some of our clients


Use of the foreach programming function


PowerShell


	Get-ChildItem $SOURCE_PATH | Where-Object {$_.creationtime -gt $LAST_IMPORTED_FILE} | Foreach-Object {
		$READER = New-Object System.IO.StreamReader("$($_.FullName)")
	}
		

PHP

				
	foreach ($arr as $key => $value) {
		// $arr[3] will be updated with each value from $arr...
		echo "{$key} => {$value} ";
		print_r($arr);
	}
			

VBA

			
	Sub Loop_Range_on_Sheets()

		Dim ws As Worksheet
		Dim rng As Range
		Dim cell As Range
	    		
		For Each ws In ActiveWorkbook.Worksheets
			Set rng =  ws.Range("A1:A10")

			For Each cell in rng.Cells
				If cell = "string to search" Then
					Debug.Print ws.Name & " " cell.Address
				End If
			Next cell
	    			
			Set rng = Nothing	
		Next ws
	End Sub
	

XSLT


	<xsl:template match = "/">
		<xsl:for-each select = "users/authorized"> 		
			<li <xsl:value-of select = "@name"/> </li> 
		</xsl:for-each>
	</xsl:template>
	

Contact


Ready to start your next project with us? Give us a call or send us an email and we will get back to you as soon as possible!

+421 904 737 236

Foreach spol. s r. o.
Černyševského 10
851 01 Bratislava
Slovakia