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
Owners
Copyright
2017 Chris Carter
Package Details
Author(s)
- Chris Carter
Tags
Excel ComObject ExcelTables ShareWorkbook
Functions
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
- ConvertTo-DataRange.nuspec
- ConvertTo-DataRange.ps1
Version History
Version | Downloads | Last updated |
---|---|---|
1.1.3 (current version) | 325 | 6/16/2017 |
1.0 | 27 | 6/16/2017 |