Paul's Programming Notes     Archive     Feed     Github

PHP - Loop Through Excel Document and Print Cells

require_once 'excel_reader2.php';

foreach($reader->sheets as $k=>$data)
    echo "\n\n ".$reader->boundsheets[$k]."\n\n";

    foreach($data['cells'] as $row)
        foreach($row as $cell)
            echo "$cell\t";
        echo "\n";

Check If Workbook Is Open By Name - VBA

This code from StackOverflow helped me find whether a workbook was open with its name. Here's the link to the thread: Link

Function BookOpen(strBookName As String) As Boolean
    Dim oBk As Workbook
    On Error Resume Next
    Set oBk = Workbooks(strBookName)
    On Error GoTo 0
    If oBk Is Nothing Then
        BookOpen = False
        BookOpen = True
    End If
End Function

Sub testbook()
    Dim strBookName As String
    strBookName = "myWork.xls"
    If BookOpen(strBookName) Then
        MsgBox strBookName & " is open", vbOKOnly + vbInformation
        MsgBox strBookName & " is NOT open", vbOKOnly + vbExclamation
    End If
End Sub