How to write records into .xlsx with OLEDB

Excel OLEDB PowerShell

satob.hatenablog.com satob.hatenablog.com So, how should you write records into .xlsx files with OLEDB? Requirement and Implementation You want to record some data into a .xlsx file with relational database style. In other words, you want …

2021-11-25

How to insert a new row with datatype constraints by using Microsoft.ACE.OLEDB

Excel OLEDB PowerShell

satob.hatenablog.com You can make an Excel file (.xlsx) without Excel by using Microsoft.ACE.OLEDB, but the behavior of INSERT is also a little bit weird. The behavior changes according to the CREATE TABLE is executed in the same connectio…

2021-11-24

How to create a new sheet with the desired name by using Microsoft.ACE.OLEDB

Excel PowerShell OLEDB

You can make an Excel file (.xlsx) without Excel by using Microsoft.ACE.OLEDB, but the behavior of CREATE TABLE is a little bit weird. The behavior changes according to the name of the sheet, suffix of the sheet name ($) in the CREATE TABL…

2020-05-20

Read from .xlsx in PowerShell (x64) without using Excel

PowerShell Character Encoding Excel Unicode OLEDB

This article shows how to read .xlsx in PowerShell without Excel. In Windows 10 (x64), you will have to do additional work. You have to install Microsoft Access Database Engine 2010 Redistributable (AccessDatabaseEngine_X64.exe) when you u…