Hi,
So I am playing around with PlanMaker and PowerShell. I am basing some of this code off code I have from a PowerShell script to enumerate AD groups and populate an Excel spreadsheet. Starting small, I thought I would create the spreadsheet and autofit the column.
$groupName = 'somereallylongname'
$row = 1
$column = 1
$pmSpreadsheet = New-Object -ComObject PlanMaker.Application
$pmSpreadsheet.Visible = $True
$workbook = $pmSpreadsheet.Workbooks.Add()
$worksheet = $workbook.ActiveSheet
$worksheet.Cells.Item($row, $column).Value = $groupName
$worksheet.Range("A:B").AutoFit
If run the above code in a PowerShell console everything works up until the AutoFit. Which throws the following message:
OverloadDefinitions
-------------------
void AutoFit ()
I converted the code to BasicScript, ran it in the BasicScript editor, and everything works as expected.
Any ideas?
Thanks,
-Eric
W10 1903 x64
SMO2018 x64 Rev970
PlanMaker and PowerShell
Post your questions, bug reports and suggestions here for PlanMaker 2018 for Windows.
Moderator: SoftMaker Team
Post Reply
1 post
• Page 1 of 1
Return to “PlanMaker 2018 for Windows”
Jump to
- SoftMaker Office 2018 for Windows
- ↳ SoftMaker Office 2018 for Windows (General)
- ↳ TextMaker 2018 for Windows
- ↳ PlanMaker 2018 for Windows
- ↳ Presentations 2018 for Windows
- ↳ Thunderbird for Windows
- ↳ BasicMaker 2018 for Windows
- SoftMaker Office 2018 for Mac
- ↳ SoftMaker Office 2018 for Mac (General)
- ↳ TextMaker 2018 for Mac
- ↳ PlanMaker 2018 for Mac
- ↳ Presentations 2018 for Mac
- SoftMaker Office 2018 for Linux
- ↳ SoftMaker Office 2018 for Linux (General)
- ↳ TextMaker 2018 for Linux
- ↳ PlanMaker 2018 for Linux
- ↳ Presentations 2018 for Linux
- SoftMaker FreeOffice 2018 for Windows
- ↳ SoftMaker FreeOffice 2018 for Windows (General)
- ↳ FreeOffice TextMaker 2018 for Windows
- ↳ FreeOffice PlanMaker 2018 for Windows
- ↳ FreeOffice Presentations 2018 for Windows
- SoftMaker FreeOffice 2018 for Mac
- ↳ SoftMaker FreeOffice 2018 for Mac (General)
- ↳ FreeOffice TextMaker 2018 for Mac
- ↳ FreeOffice PlanMaker 2018 for Mac
- ↳ FreeOffice Presentations 2018 for Mac
- SoftMaker FreeOffice 2018 for Linux
- ↳ SoftMaker FreeOffice 2018 for Linux (General)
- ↳ FreeOffice TextMaker 2018 for Linux
- ↳ FreeOffice PlanMaker 2018 for Linux
- ↳ FreeOffice Presentations 2018 for Linux
- SoftMaker Office 2016 for Windows
- ↳ SoftMaker Office 2016 for Windows (General)
- ↳ TextMaker 2016 for Windows
- ↳ PlanMaker 2016 for Windows
- ↳ Presentations 2016 for Windows
- ↳ Thunderbird for Windows
- ↳ BasicMaker 2016 for Windows
- SoftMaker Office 2016 for Linux
- ↳ SoftMaker Office 2016 for Linux (General)
- ↳ TextMaker 2016 for Linux
- ↳ PlanMaker 2016 for Linux
- ↳ Presentations 2016 for Linux
- SoftMaker Office HD for Android
- ↳ SoftMaker Office HD for Android (General)
- ↳ TextMaker HD
- ↳ PlanMaker HD
- ↳ Presentations HD
- FlexiPDF 2019
- ↳ FlexiPDF 2019
- Miscellaneous
- ↳ SoftMaker Fonts
- ↳ Water Cooler
- ↳ SoftMaker FreeOffice 2016 for Windows
- ↳ SoftMaker FreeOffice 2016 for Windows (General)
- ↳ FreeOffice TextMaker 2016 for Windows
- ↳ FreeOffice PlanMaker 2016 for Windows
- ↳ FreeOffice Presentations 2016 for Windows
- ↳ SoftMaker FreeOffice 2016 for Linux
- ↳ SoftMaker FreeOffice 2016 for Linux (General)
- ↳ FreeOffice TextMaker 2016 for Linux
- ↳ FreeOffice PlanMaker 2016 for Linux
- ↳ FreeOffice Presentations 2016 for Linux
- ↳ FlexiPDF 2017
- ↳ FlexiPDF 2017
- ↳ SoftMaker Office Mobile for Android
- ↳ SoftMaker Office Mobile for Android (General)
- ↳ TextMaker Mobile for Android
- ↳ PlanMaker Mobile for Android
- ↳ Presentations Mobile for Android