January 2017 – Alan's Blog

Export to XLSX without Excel: Export-XLSX.ps1 Revisited and Tweaked

Posted on January 30, 2017February 5, 2017 by Alan

I often look at the code of others with respect and admiration. Peter Kriegel (Germany) wrote Export-XLSX.ps1, an amazing script which lets you export data into a real XLSX file without Excel being installed. The script also enables you to directly append worksheets to XLXS files. His website, http://www.admin-source.de, hasn’t been updated in a while,…

Get the NetBIOS AD Domain Name from the FQDN

Posted on January 30, 2017January 30, 2017 by Alan

I hate using NameTranslate, because it is a COM object, and because the output is often really hard to get into a clean, trimmed string. The netBIOS name isn’t a part of the AD domain object, but I suspected that the information could be gotten using a LDAP query. My searching lead me to a post…

All the scripts are saved as .txt files. Newer files have a “View Script” button which will let you save or open a script in notepad. For earlier posts, the easiest way to download with IE is to right click on the link and use “Save Target As”. Rename file from Name_ext.txt to Name.ext.

To see a full post after searching, please click on the title.

PowerShell Scripts were written with version 3 or later.

https connections are supported.

All new users accounts must be approved, as are comments. Please be patient. If you find a post error or a script which doesn’t work as expected, I appreciate being notified. My email is my first name at the domain name, and you are welcome to contact me that way.