mirror of
https://github.com/dfinke/ImportExcel.git
synced 2025-12-06 00:23:20 +00:00
23 lines
871 B
Plaintext
23 lines
871 B
Plaintext
# ConvertFrom-Excel
|
|
''
|
|
|
|
.\test.xlsx
|
|
|
|
Import-Excel .\test.xlsx | ft
|
|
|
|
ConvertFrom-Excel -ExcelFile .\test.xlsx -outFile .\targetout.html
|
|
|
|
# Create a column definition
|
|
$columnOptions = @()
|
|
|
|
$columnOptions += New-ColumnOption -ColumnName Progress -formatter progress
|
|
ConvertFrom-Excel -ExcelFile .\test.xlsx -outFile .\targetout.html -columnOptions $columnOptions
|
|
|
|
$columnOptions += New-ColumnOption Activity -formatter lineFormatter
|
|
ConvertFrom-Excel -ExcelFile .\test.xlsx -outFile .\targetout.html -columnOptions $columnOptions
|
|
|
|
$columnOptions += New-ColumnOption -ColumnName Rating -formatter star
|
|
$columnOptions += New-ColumnOption Driver -formatter tickCross
|
|
ConvertFrom-Excel -ExcelFile .\test.xlsx -outFile .\targetout.html -columnOptions $columnOptions
|
|
|
|
ConvertFrom-Excel -ExcelFile .\test.xlsx -outFile .\targetout.html -columnOptions $columnOptions -groupBy Gender |