ConvertTo-DataRange

1.1.3

ConvertTo-DataRange converts tables in all sheets of an Excel workbook to data ranges, and then saves the changes. The path to the workbook to convert is supplied to the Path parameter.

Workbooks with tables cannot be shared, so this command is useful in preparing a workbook to be shared.

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Script -Name ConvertTo-DataRange

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

2017 Chris Carter

Package Details

Author(s)

  • Chris Carter

Tags

Excel ComObject ExcelTables ShareWorkbook

Functions

Remove-ComObject

Dependencies

This script has no dependencies.

Release Notes

SaveAs parameter added so that the original file can be kept untouched. Help information updated with minor corrections Verbose statments added.

FileList

Version History

Version Downloads Last updated
1.1.3 (current version) 325 6/16/2017
1.0 27 6/16/2017