PSExcel

PSExcel copied to clipboard

Add readonly feature

1

Hi, need the ability to open an excel file in read-only mode

jensenjkaare

EPPlus.dll didnt work in Linux because the path is case sensitiv

gforke97

Removed Records: Named range from /xl/workbook.xml part (Workbook) Error

2

I Get a Removed Records: Named range from /xl/workbook.xml part (Workbook) Error When I open a Excel File after I apply a "Set-CellValue -WorkSheet $Worksheet -Coordinates 'C4:C4' -Value "Test5"" Then...

DrPepper124

Currently we get errors when interacting with files with certain characters, such as square brackets, in their filename; e.g. `$myFile = 'c:\temp\myfile[1].xlsx'`. We can work around this by escaping those...

JohnLBevan

Will this module work on Powershell Core? Looking to potentially use it in a Azure Function

andy968

Currently, the call to `Trim` is failing because column headers might be numbers or dates, which have no `Trim` method. Since any object has a `ToString` method, this should fix...

psytrx

If a sheet contains multiple rows with the same name, the Add-PivotTable invalidates the output file even that the columns are not used. repro step: Add a sheet with the...

Kmdkca

Please can somme explain me the meanning of this message and hwo to solve it # File "D:\Users\projet\AppData\Local\Continuum\anaconda2\lib\site-packages\xlrd\__init__.py", line 130, in open_workbook if 'xl/workbook.xml' in component_names: NameError: global name 'component_names'...

abnassiri

PSExcel does not Refresh Pivot Table on Excel

1

Hi, I am trying to use PSExcel for refreshing pivots present on my excel, but unable to achieve it. Basically my server will no more have MS Excel app on...

blue9manish

Throw exception when worksheet is empty/not found due to wrong worksheet name or because worksheet was renamed.

hs-hub-world