ImportExcel
PowerShell module to import/export Excel spreadsheets, without Excel
파일 탐색기
최종 버전 다운로드 (.zip)- ci.yml
- stale.yml
- spellright.dict
- construction.xlsx
- DataInDiffRowCol.xlsx
- DataInDiffRowColMultipleSheets.xlsx
- ImportExcelEndRowEndColumn.tests.ps1
- ImportExcelReadSheets.tests.ps1
- LargerFile.xlsx
- MaxRows.xlsx
- MultipleSheets.xlsx
- ReadMultipleXLSXFiles.tests.ps1
- rows05.xlsx
- rows10.xlsx
- SheetVisibleTesting.xlsx
- Simple.tests.ps1
- Simple.xlsx
- TestData1.xlsx
- TestData2.xlsx
- TestImportOnly.tests.ps1
- yearlySales.xlsx
- Invoke-ExcelQuery.Tests.ps1
- Read-OleDbData.TestA.sql
- Read-OleDbData.TestB.sql
- Read-OleDbData.TestC.sql
- Read-OleDbData.TestD.sql
- Read-OleDbData.TestE.sql
- Read-OleDbData.Tests.ps1
- Read-OleDbData.xlsx
- Get-CimInstanceDisk.xml
- Get-CimInstanceNetAdapter.xml
- Get-Process.xml
- Get-Service.xml
- Samples.ps1
- AddTrendlinesToAChart.tests.ps1
- Compare-WorkSheet.tests.ps1
- ConvertFrom-ExcelSheet.Tests.ps1
- ConvertFromExcelToSQLInsert.tests.ps1
- Copy-ExcelWorksheet.Tests.ps1
- Export-Excel.Tests.ps1
- ExtraLongCmd.tests.ps1
- First10Races.csv
- First10Races.tests.ps1
- First10Races.xlsx
- FunctionAlias.tests.ps1
- Get-ExcelColumnName.Test.ps1
- Get-ExcelFileSchema.tests.ps1
- Get-ExcelFileSummary.Tests.ps1
- ImportExcelHeaderName.tests.ps1
- InputItemParameter.tests.ps1
- Join-Worksheet.tests.ps1
- Mockservices.xml
- MSFT_NetAdapter.xml
- New-ConditionalFormattingIconSet.tests.ps1
- Open-ExcelPackage.tests.ps1
- PasswordProtection.tests.ps1
- Path.tests.ps1
- ProtectWorksheet.tests.ps1
- RangePassing.Tests.ps1
- Read-Clipboard.tests.ps1
- Remove-WorkSheet.tests.ps1
- Set-CellComment.tests.ps1
- Set-Row_Set-Column-SetFormat.tests.ps1
- testImportExcel.xlsx
- testImportExcelHeaderOnly.xlsx
- testImportExcelImportColumns.xlsx
- testRelative.xlsx
- UnsupportedWorkSheetNames.xlsx
- Validation.tests.ps1
- win32_logicaldisk.xml
- Charting.ps1
- barchart.md
- columnchart.md
- dochart.md
- linechart.md
- piechart.md
- README.md
- build.ps1
- CI.ps1
- Install.ps1
- InstallPowerShell.ps1
- pipeline.yml
- PS-CI.ps1
- Publish.ps1
- PublishToGallery.ps1
- Test-SingleFunctions.ps1
- ImportExcel-help.xml
- Strings.psd1
- Add-ExcelImage.ps1
- AddImage.ps1
- Octocat.jpg
- README.md
- AddMultiWorkSheet.ps1
- AddWorkSheet.ps1
- ChartAndTrendlines.ps1
- ChartDataSeparatePage.ps1
- Multiplecharts.png
- MultipleCharts.ps1
- MultiSeries.ps1
- MultiSeries1.ps1
- NumberOfVisitors.ps1
- plot.ps1
- MultipleWorksheets.ps1
- CodeGenExamples.ps1
- ConditionalFormattingIcontSetOnlyIcon.ps1
- ConditionalText.ps1
- ContainsBlanks.ps1
- Databar.ps1
- FormatCalculations.ps1
- GenDates.ps1
- GetConditionalFormatting.ps1
- GetConditionalFormatting.xlsx
- GetProcess.ps1
- Highlight-DiffCells.ps1
- Highlight-Last7Days.ps1
- Highlight-LastMonth.ps1
- Highlight-LastWeek.ps1
- Highlight-NextMonth.ps1
- Highlight-NextWeek.ps1
- Highlight-ThisMonth.ps1
- Highlight-ThisWeek.ps1
- Highlight-Today.ps1
- Highlight-Tomorrow.ps1
- Highlight-Yesterday.ps1
- HighlightDuplicates.ps1
- MonthlyTemperatuesDatabar.ps1
- RangeFormatting.ps1
- SalesReportWithDatabar.ps1
- TextComparisons.ps1
- Top10-DataBar-TwoColorScale.ps1
- ConvertFrom.ps1
- testSQLGen.xlsx
- Out-Excel.ps1
- ShortenNumbers.ps1
- CustomReport.ps1
- DSUM.png
- DSUM.ps1
- VLookUp.png
- VLOOKUP.ps1
- MutipleValidations.ps1
- DemoSQLInsert.ps1
- Movies.xlsx
- Export-MultipleExcelSheets.ps1
- tryExportMultipleExcelSheets.ps1
- Get-ModuleStats.ps1
- ShowFibonacci.ps1
- ApplyFormatInScriptBlock.ps1
- ApplyStyle.ps1
- PassInScriptBlock.ps1
- GetAsMarkdownTable.ps1
- GetAsYaml.ps1
- Sample.csv
- Sample.xlsx
- FreezePane.ps1
- GenDataForCustomReport.ps1
- First10Races.csv
- GroupDateColumn.ps1
- GroupDateRow.ps1
- GroupNumericColumn.ps1
- GroupNumericRow.ps1
- TimestampBucket.ps1
- First10Races.csv
- Hyperlinks.ps1
- Races.ps1
- ImportMultipleSheetsAsArray.ps1
- ImportMultipleSheetsAsHashtable.ps1
- yearlySales.xlsx
- FruitCity.xlsx
- import-by-columns.ps1
- VM_Build_Example.xlsx
- ImportColumns.ps1
- DemoGraphics.ps1
- PeriodicElements.ps1
- StarTrek.ps1
- Analyze_that.ps1
- Analyze_this.ps1
- Examples.ps1
- testOleDb.xlsx
- EastSales.csv
- Join-worksheet-blocks.sample.ps1
- Join-Worksheet.sample.ps1
- JoinSalesData.ps1
- NorthSales.csv
- SouthSales.csv
- WestSales.csv
- CentralLimitTheorem.ps1
- PieChartHandles.ps1
- PieChartPM.ps1
- TargetData.csv
- TargetData.ps1
- TryBarChart.ps1
- TryColumnChart.ps1
- TryPieChart.ps1
- Merge_2_Servers_Services.ps1
- Merge_3_Servers_Services.ps1
- MergeCSV.ps1
- MortgageCalculator.ps1
- MoveSheets.ps1
- MultiplierTable.xlsx
- FireBalls.ps1
- ColorizeNumbers.ps1
- CurrencyFormat.ps1
- PercentagFormat.ps1
- PosNegNumbers.ps1
- Win32LogicalDisk.ps1
- Win32LogicalDiskFormatted.ps1
- EnableFeatures.ps1
- demo.txt
- start-demo.ps1
- targetout.html
- tryConvertFromExcel.ps1
- sales.csv
- TryPassThru.ps1
- Pester test report.ps1
- PesterConfiguration.json
- MultiplePivotTables.ps1
- PivotTableWithName.ps1
- TableAndPivotTable.ps1
- testPivotFilter.ps1
- PlotCos.ps1
- GenerateXlsx.ps1
- Get-ExcelSheets.ps1
- ReadAllSheets.ps1
- SetColumnBackgroundColor.ps1
- SalesByQuarter.ps1
- Sparklines.ps1
- CalculatedFields.ps1
- ExcelFormulasUsingAddMember.ps1
- ExcelFunctions.ps1
- HyperLink.ps1
- Example.ps1
- Example2.ps1
- Get-StockInfo.ps1
- GetStocksAvgTotVol.ps1
- MultipleStyles.ps1
- NewExcelStyle.ps1
- MultipleTables.ps1
- SalesData-WithTotalRow.ps1
- TotalsRow.ps1
- PSExcelPester.psm1
- RunAndShowUnitTests.ps1
- ShowPesterResults.ps1
- TestAPIReadXls.ps1
- testlist.xlsx
- TryIt.ps1
- AddModuleMultipleWorksheetVBA.ps1
- AddWorksheetVBA.ps1
- ChangePivotTablesVBA.ps1
- HelloWorldVBA.ps1
- XlRangeToImage.ps1
- Index - Music.ps1
- New-PSItem.ps1
- Pester-To-XLSx.ps1
- PsGallery.ps1
- Subtotals.ps1
- TryMultiplePivotTables.ps1
- TryMultiplePivotTablesFromOneSheet.ps1
- How to Create an Empty Excel File.md
- How to Read an Existing Excel File.md
- How to Write to an Existing Excel File.md
- DataStructureExcelPkg.png
- ExcelFileContents.png
- ExcelFileContentsPostAdd.png
- ExcelFileDebugImg.jpg
- ValueAtIndexData.png
- AutoCompleteSheetNames.png
- CellFormatting.png
- ConditionalDates.gif
- ConditionalText.gif
- ConditionalText2.gif
- CustomReport.png
- ExportMultiple.gif
- exportstockinfo.gif
- FilterFreezeBold.gif
- fluent.gif
- Formatting.png
- GetExcelSheetInfo.png
- GroupDateColumn.png
- GroupingNumeric.png
- GroupNumericColumn.png
- GTConditional.png
- ImportHtml.gif
- ImportHtmlSecretaryOfState.gif
- logo.png
- logoWithInstall.png
- MonthlyTemperaturesWithDatabar.png
- MultiplePivotTables.png
- MultiplePivotTablesInAWorkbook.png
- MultiSeries.gif
- MultiSeries.png
- NewExcelStyle.png
- PassThru.png
- PivotAsColumns.png
- PivotAsRows.png
- PivotTableFilter.png
- PivotTablesAndCharts.png
- plot.gif
- plotNew.gif
- PSPlot.gif
- SalesData.png
- SalesDataChart.png
- SalesDataChartPivotTable.png
- SalesDataWithDatabar.png
- SQL-Spreadsheet.png
- testimonial.png
- Title.png
- Tracking.gif
- TryImportExcel.gif
- XLToPesterForRestAPI.gif
- XLToPesterForRestAPIAndOutput.gif
- InferData.ps1
- invoke-alltests.md
- README.md
- test-boolean.md
- test-date.md
- test-integer.md
- test-number.md
- test-string.md
- add-conditionalformatting.md
- add-excelchart.md
- add-exceldatavalidationrule.md
- add-excelname.md
- add-exceltable.md
- add-pivottable.md
- add-worksheet.md
- close-excelpackage.md
- compare-worksheet.md
- convert-excelrangetoimage.md
- convertfrom-excelsheet.md
- convertfrom-exceltosqlinsert.md
- copy-excelworksheet.md
- expand-numberformat.md
- export-excel.md
- get-excelsheetinfo.md
- get-excelworkbookinfo.md
- import-excel.md
- join-worksheet.md
- merge-multiplesheets.md
- merge-worksheet.md
- new-conditionalformattingiconset.md
- new-conditionaltext.md
- new-excelchartdefinition.md
- new-pivottabledefinition.md
- open-excelpackage.md
- README.md
- remove-worksheet.md
- select-worksheet.md
- send-sqldatatoexcel.md
- set-excelcolumn.md
- set-excelrange.md
- set-excelrow.md
- update-firstobjectproperties.md
- buildHelp.ps1
- README.md
- pivot.md
- Pivot.ps1
- README.md
- ArgumentCompletion.ps1
- Invoke-ExcelReZipFile.ps1
- Add-ConditionalFormatting.ps1
- Add-ExcelChart.ps1
- Add-ExcelDataValidationRule.ps1
- Add-ExcelName.ps1
- Add-ExcelTable.ps1
- Add-PivotTable.ps1
- Add-Worksheet.ps1
- Close-ExcelPackage.ps1
- Compare-Worksheet.ps1
- Convert-ExcelRangeToImage.ps1
- ConvertFrom-ExcelData.ps1
- ConvertFrom-ExcelSheet.ps1
- ConvertFrom-ExcelToSQLInsert.ps1
- ConvertTo-ExcelXlsx.ps1
- Copy-ExcelWorksheet.ps1
- Enable-ExcelAutoFilter.ps1
- Enable-ExcelAutofit.ps1
- Expand-NumberFormat.ps1
- Export-Excel.ps1
- Get-ExcelColumnName.ps1
- Get-ExcelFileSchema.ps1
- Get-ExcelFileSummary.ps1
- Get-ExcelSheetDimensionAddress.ps1
- Get-ExcelSheetInfo.ps1
- Get-ExcelWorkbookInfo.ps1
- Get-HtmlTable.ps1
- Get-Range.ps1
- Get-XYRange.ps1
- Import-Excel.ps1
- Import-Html.ps1
- Import-UPS.ps1
- Import-USPS.ps1
- Invoke-ExcelQuery.ps1
- Invoke-Sum.ps1
- Join-Worksheet.ps1
- Merge-MultipleSheets.ps1
- Merge-Worksheet.ps1
- New-ConditionalFormattingIconSet.ps1
- New-ConditionalText.ps1
- New-ExcelChartDefinition.ps1
- New-ExcelStyle.ps1
- New-PivotTableDefinition.ps1
- New-PSItem.ps1
- Open-ExcelPackage.ps1
- Read-Clipboard.ps1
- Read-OleDbData.ps1
- Remove-Worksheet.ps1
- Select-Worksheet.ps1
- Send-SQLDataToExcel.ps1
- Set-CellComment.ps1
- Set-CellStyle.ps1
- Set-ExcelColumn.ps1
- Set-ExcelRange.ps1
- Set-ExcelRow.ps1
- Set-WorksheetProtection.ps1
- Update-FirstObjectProperties.ps1
- ConvertFrom-ExcelColumnName.ps1
- t1.png
- .gitattributes
- .gitignore
- Add-Subtotals.ps1
- azure-pipelines.yml
- changelog.md
- EPPlus.dll
- Export-charts.ps1
- Export-StocksToExcel.ps1
- GetExcelTable.ps1
- ImportExcel.psd1
- ImportExcel.psm1
- InstallModule.ps1
- LICENSE.txt
- llms-examples.txt
- Plot.ps1
- PublishToGallery.ps1
- README.md
- README.original.md
- SUMMARY.md
// repository documentation
Was this content helpful?
(0 ratings)