Relative Content

Tag Archive for excelpowershell

Excel COM object method inaccessible

I am trying to insert a new row into an Excel sheet. I open a file with Powershell, get an object for the sheet, and then get a range object like

Excel COM object method inaccessible

I am trying to insert a new row into an Excel sheet. I open a file with Powershell, get an object for the sheet, and then get a range object like

Excel COM object method inaccessible

I am trying to insert a new row into an Excel sheet. I open a file with Powershell, get an object for the sheet, and then get a range object like

Generating Excel Chart using powershell and ImportExcel

I need to create some charts using data that already exist in my workbook. Generation of Chart is correct, but axis data is not. It is always numeric, but In some charts i have text or date-time values. After generation, there is no possibility to change type of xAsis

Overwrite existing Excel file with PowerShell

I have an excel file that I’m trying to open, refresh all of the cells (which pull data from an excel plug-in) and then save the file down as a new file. I’m trying to run it a few times a day though and overwrite the existing new file.

Powershell and excel

I need to delete rows from the excel file that do not contain this “%” character.
My code: