PowerShell で取得できるExcelのセルの情報は、テキスト情報だけでなく文字色や背景色など実に様々な情報を取得することができます。

Application Microsoft.Office.Interop.Excel.ApplicationClass
Creator 1480803660
Parent System.__ComObject
AddIndent FALSE
Areas System.__ComObject
Borders System.__ComObject
Cells System.__ComObject
Column 154
Columns System.__ComObject
ColumnWidth 8.38
Count 1
CurrentArray
CurrentRegion System.__ComObject
Dependents
DirectDependents
DirectPrecedents
EntireColumn System.__ComObject
EntireRow System.__ComObject
Font System.__ComObject
Formula
FormulaArray
FormulaLabel
FormulaHidden FALSE
FormulaLocal
FormulaR1C1
FormulaR1C1Local
HasArray FALSE
HasFormula FALSE
Height 0
Hidden
HorizontalAlignment 1
IndentLevel 0
Interior System.__ComObject
Left 8737.5
ListHeaderRows 0
LocationInTable
Locked TRUE
MergeArea System.__ComObject
MergeCells FALSE
Name
_NewEnum System.Runtime.InteropServices.CustomMarshalers.EnumeratorViewOfEnumVariant
Next System.__ComObject
NumberFormat G/標準
NumberFormatLocal G/標準
Orientation -4128
OutlineLevel
PageBreak
PivotField
PivotItem
PivotTable
Precedents
PrefixCharacter
Previous System.__ComObject
QueryTable
Row 4
RowHeight 0
Rows System.__ComObject
ShowDetail
ShrinkToFit FALSE
SoundNote System.__ComObject
Style System.__ComObject
Summary
Text
Top 27
UseStandardHeight TRUE
UseStandardWidth TRUE
Validation System.__ComObject
Value2
VerticalAlignment -4108
Width 54
Worksheet System.__ComObject
WrapText FALSE
Comment
Phonetic System.__ComObject
FormatConditions System.__ComObject
ReadingOrder -5002
Hyperlinks System.__ComObject
Phonetics System.__ComObject
ID
PivotCell
Errors System.__ComObject
SmartTags System.__ComObject
AllowEdit TRUE
ListObject
XPath System.__ComObject
ServerActions
MDX
CountLarge 1
SparklineGroups System.__ComObject
DisplayFormat System.__ComObject
広告