import-excel import a single cell. OK in therory but not in practice what am I doing wrong.

[shaunsail]

I have created a simple file and used suggested code, but all I get the the complete row or null. so many suggested code snippets don't work will message like not supported yet upgrade :-(

This is my code and results - see $cell is blank.

$data = Import-Excel -Path "C:/powershell/file.xlsx" -workSheetName "sheet1" -startRow 2

Write-Host $data
Write-Host $data.Count
$cell = $data[0][0]
Write-Host $cell
write-Host $cell.count
$valueFromCellH1 = $data[0]["H1"] # Access the value in column H1
Write-Host $valueFromCellH1
@{H1=A1; H2=B1; H3=C1; H4=D1; h5=E1; H6=F1; H7=G1; H8=H1; H9=I1; H10=J1} @{H1=A2; H2=B2; H3=C2; H4=D2; h5=E2; H6=F2; H7=G2; H8=H2; H9=I2; H10=J2} @{H1=A3; H2=B3; H3=C3; H4=D3; h5=E3; H6=F3; H7=G3; H8=H3; H9=I3; H10=J3} @{H1=A4; H2=B4; H3=C4; H4=D4; h5=E4; H6=F4; H7=G4; H8=H4; H9=I4; H10=J4} @{H1=A5; H2=B5; H3=C5; H4=D5; h5=E5; H6=F5; H7=G5; H8=H5; H9=I5; H10=J5} @{H1=A6; H2=B6; H3=C6; H4=D6; h5=E6; H6=F6; H7=G6; H8=H6; H9=I6; H10=J6} @{H1=A7; H2=B7; H3=C7; H4=D7; h5=E7; H6=F7; H7=G7; H8=H7; H9=I7; H10=J7} @{H1=A8; H2=B8; H3=C8; H4=D8; h5=E8; H6=F8; H7=G8; H8=H8; H9=I8; H10=J8} @{H1=A9; H2=B9; H3=C9; H4=D9; h5=E9; H6=F9; H7=G9; H8=H9; H9=I9; H10=J9} @{H1=A10; H2=B10; H3=C10; H4=D10; h5=E10; H6=F10; H7=G10; H8=H10; H9=I10; H10=J10}
10
@{H1=A1; H2=B1; H3=C1; H4=D1; h5=E1; H6=F1; H7=G1; H8=H1; H9=I1; H10=J1}
1

PS C:\PowerShell> Get-Module -ListAvailable -Name ImportExcel | Select-Object Version

Version

7.8.6
7.8.6
7.8.6

PS C:\PowerShell> $PSVersionTable.PSVersion

Major Minor Patch PreReleaseLabel BuildLabel

---

7 4 1

All I want to do is import (long) rows from a spreadsheet and export the header as a label for each row (1 page per row) as a pdf. In theory simple using import-excel.