All Questions
Tagged with excel powershell
1,695
questions
0
votes
1
answer
19
views
How to prevent the message "File open in another application" when creating excel instance
I was running a PowerShell script perfectly fine earlier, but for some reason this message popped up that's saying the file is open in another application. I have checked task manager and the excel ...
0
votes
0
answers
35
views
Why does csv consider data in one column to be an empty string
I have a powershell script, which basically takes an xlsx file with data, converts it to csv and then fills certain cells in another (template) xlsx file with values from certain columns. There are ...
0
votes
0
answers
37
views
how to attach file into pdf using console commands (shell)
I currently have a project in which I need to automate file attachment to a .pdf file using Excel VBA.
Is it possible to attach a file (.xml) to a .pdf file using only console commands or Windows ...
0
votes
1
answer
47
views
excel file not calculating using the formula
I am using Import-Excel to calculate some data using excel formula.
Below is the code
# Import the ImportExcel module
Import-Module ImportExcel
# Define the path to the existing Excel file
$...
1
vote
1
answer
24
views
Issue while populating data in excel sheet using powershell
I am having below code in powershell which I am using to populate the data in excel
# Apply the formula in column O for all rows
$lastRowO = $sheet1.UsedRange.Rows.Count
for ($rowO = 2; $...
0
votes
0
answers
35
views
Issues Running Macro with Cap IQ Plugin via PowerShell Script
I need assistance with automating an Excel process that involves running a macro which utilizes functions from the Cap IQ plugin. Here’s the scenario:
Objective:
Generate an email from an Excel ...
0
votes
1
answer
62
views
When Converting excel to csv for empty cells quotes not coming
I'm trying to import excel file to csv format through power shell using this command
import-excel c:\users\xxxx\TestFile.xlsx | export-csv c:\users\xxx\CSVFile.csv -NoTypeInformation -Encoding UTF8
...
0
votes
0
answers
33
views
Excel hangs in Python script to export excel as a pdf in Task Scheduler, but works normally
I'm trying to just automate creating a pdf from an excel file to email it out everyday. It should be simple, but it isn't. If I run these files in command line, they will run, create the pdf, and ...
0
votes
2
answers
62
views
SAS day of week name to char (downame.)
I have a date variable and want to create a new variable with the name of the day of the week.
I use the following for this.
a.date format=DOWNAME. AS DayOfWeek
date | DayOfWeek
----------------...
0
votes
0
answers
23
views
Overwrite existing Excel file with PowerShell [duplicate]
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 ...
1
vote
1
answer
70
views
Gnuplot fit vs excel trendline
I try to do linear regression on datapoints and was wondering why gnuplot fit is different to an excel trendline and my powershellscript.
My datapoints:
Timestamp Value
1709289398 3.89
1711018216 ...
0
votes
0
answers
17
views
Powershell command to update sharepoint not executing from excel button
within excel, i have a button with the following macro when i click it
Sub MigrateFile_Click()
strCommand = "Powershell -File ""C:\Test\migrate.ps1"""
Set WshShell =...
0
votes
0
answers
42
views
Formula in last row of xlsx not parsed in Powershell
I am downloading an xlsx file linked to a MS Form (so each new row is a new form submission) from Sharepoint and importing it in Powershell via ImportExcel module
$f = Import-Excel -Path "$path&...
0
votes
1
answer
54
views
Is there a way to speed things up, when applying conditional formatting to an Excel sheet from PowerShell?
I'm using the Excel com interface from PowerShell to apply conditional formatting to particular cells. Here is an example excerpt.
# Conditional formats
$SafeCheck = $OutputSheet.Range(...
0
votes
2
answers
72
views
Use PowerShell to open multiple Excel workbooks in parallel
I have a script that opens a set of Excel workbooks in a single Excel instance and updates connections and pivot caches. The end user reports that they usually open all the workbooks and refresh ...