If you use Office 365 and store documents in SharePoint or OneDrive for Business, the Office applications can autosave as you work to ensure that you never lose any content. It’s a good idea and the implementation works well. But I have a slight nagging doubt about the network impact for some tenants.
Microsoft Excel causes problems in genetic research. That’s the claim of three researchers from an Australian institute, who discovered almost 20% of data sets contained errors introduced by Excel. The problem is Excel being “clever”—guessing the type of data it’s being asked to import. Unfortunately…
Microsoft has announced the general availability of its REST API for Excel that will extend the capaiblites of the spreadsheet application to new products.
Microsoft’s productivity future is based heavily on the fact that corporations are addicted to Excel, and there is not a compelling alternative.
Jeff Hicks shows us how to easily query Excel workbooks as a database with some help from PowerShell.
Russell Smith serves us three helpful ways to connect to the Office 365 Reporting Service from Excel for easier report viewing.
In part three of this series, learn how to read data from an Excel file using PowerShell.
In the second of this three-part series, Jeff Hicks goes into even more detail about how to create a rich Excel document with PowerShell. In the conclusion of this series, which will be posted next week, he will explain how to look at reading data from Excel files.
In the first of this three-part series, Jeff Hicks details how to integrate PowerShell with Microsoft Excel by exporting Excel files from PowerShell.