使用Powershell将仅可见行导出为CSV [英] Export only visible rows to CSV with Powershell

问题描述

我在Excel宏中具有逻辑，该宏可以解析文档并隐藏每行某些单元格中没有数据的行.希望仅将可见单元格导出为CSV.我有下面的代码可以导出所有内容，但是如何使它仅显示可见行?

I have logic in an Excel macro that parses the documents and hides rows that don't have data in certain cells per row. Looking to export only the visible cells to CSV. I have code (below) to export everything, but how do I make it only do visible rows?

 $oWorksheet = $objExcel.Worksheets.item(6)
 $oWorksheet.Activate()
 "saving $filecsv"
 $oWorksheet.SaveAs($filecsv,[Microsoft.Office.Interop.Excel.XlFileFormat]::xlCSVWindows)
 $workbook.Saved = $true

推荐答案

请参阅此答案我相信您可以使用以下方法仅复制可见行:

Please see this answer I believe you could copy only the visible rows by using the following:

$max = $sheet.UsedRange.Rows.Count
for ($i=2; $i -le $max; $i++)
{
    $row = $sheet.Cells.Item($i,1).EntireRow
    if ($row.hidden -eq $false)
    {
        ## append the row to new csv file
    }
}

这篇关于使用Powershell将仅可见行导出为CSV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！