Microsoft Download CenterWarning: This site requires the use of scripts, which your browser does not currently allow.The power of Office. Everywhere.PreviousNextFind downloadsPopular downloadsProduct:
All categories
Business Solutions
Developer Tools
Games & Xbox
Internet Explorer
Windows Live
Windows Mobile
Windows Phone
Set MSN as your default homepage and Bing as your default search engine
Install this compatibility pack if you would like to open, edit, and save documents, workbooks, and presentations that were created in the newer versions of Word, Excel, and PowerPoint. Scroll down to see instructions and system requirements.
The Microsoft DirectX(R) End-User Runtime provides updates to 9.0c and previous versions of DirectX — the core Windows(R) technology that drives high-speed multimedia and games on the PC.
The Microsoft .NET Framework 4 web installer package downloads and installs the .NET Framework components required to run on the target machine architecture and OS. An Internet connection is required during the installation. .NET Framework 4 is required to run and develop applications to target the .NET Framework 4.
The Visual C++ Redistributable Packages install run-time components that are required to run C++ applications that are built by using Visual Studio 2013.
.NET Framework 4.5 is a highly compatible, in-place update to .NET Framework 4.
This tool checks your computer for infection by specific, prevalent malicious software (including Blaster, Sasser, and Mydoom) and helps to remove the infection if it is found. Microsoft will release an updated version of this tool on the second Tuesday of each month.
Service Pack 3 provides the latest updates to the 2007 Microsoft Office Suite. This update also applies to Microsoft Office Project, Microsoft Office SharePoint Designer, Microsoft Office Visio, and Visual Web Developer.
Microsoft Security Essentials provides real-time protection for your home or small business PC that guards against viruses, spyware, and other malicious software.
Loading your results, please wait...Featured itemsTry Visual Studio 2015 RC today.Extend it to the cloud easily with Microsoft Azure.The cloud that opens one stadium to 450 million fans.Bring your data to life in new ways.Manage users, devices, apps, and data safely and efficiently.Add-onsFor OfficeAdd-ons for OfficeFor WindowsAdd-ons for WindowsSjolzy'blog
当前位置:&&&&&&&JS技巧：兼容性导出表格为Excel文件
项目中经常需要导出Excel文件，不在服务器端处理而是富客户端采用Javascript脚本处理数据并导出文件。
的常见一种办法是调用：ActiveXObject(&Excel.Application&) ，但是这种方法有局限性，只能在IE系列下的浏览器里实现，兼容性方面不理想。
经测试,采用本文推荐的方法能兼容性较好的导出表格内容到Excel文件。
var str = &博客, 域名\nBlog, , 3&;var uri = 'data:text/charset=utf-8,' +var downloadLink = document.createElement(&a&);downloadLink.href =downloadLink.download = &export.csv&;document.body.appendChild(downloadLink);downloadLink.click();document.body.removeChild(downloadLink);
这种方法在谷歌/火狐系列浏览器里是OK的，但是在IE里会有&传递给系统调用的数据区域太小
&的报错提示，原因是href指定的值的字节数过多。
So，对于IE浏览器只好判断下，采用ActiveXObject的形式。
乳此便能较好的使用Javascript导出HTML内容到Excel文件。
发表评论：Download Microsoft Power Query for Excel from Official Microsoft Download CenterWarning: This site requires the use of scripts, which your browser does not currently allow.
Microsoft Power Query for Excel
Select Language:
BasqueBulgarianCatalanChinese (Simplified)Chinese (Traditional)CroatianCzechDanishDutchEnglishEstonianFinnishFrenchGalicianGermanGreekHebrewHindiHungarianIndonesianItalianJapaneseKazakhKoreanLatvianLithuanianMalay (Malaysia)Norwegian (Bokmål)PolishPortuguese (Brazil)Portuguese (Portugal)RomanianRussianSerbian (Latin)SlovakSlovenianSpanishSwedishThaiTurkishUkrainianVietnamese
Choose the download you wantFile NameSize
PowerQuery_2.23.-bit) [en-us].msi11.3 MB11.3 MB
PowerQuery_2.23.-bit) [en-us].msi11.4 MB11.4 MB
Release Notes (English-only).docx31 KB31 KB
Download Summary:KBMBGBYou have not selected any file(s) to download.Microsoft recommends you install a download manager.A download manager is recommended for downloading multiple files.Microsoft Download ManagerManage all your internet downloads with this easy-to-use manager.It features a simple interface with many customizable options:Download multiple files at one timeDownload large files quickly and reliablySuspend active downloads and resume downloads that have failedWould you like to install the Microsoft Download Manager?Yes, install Microsoft Download Manager(recommended)No, thanks
Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.
Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
2.23.PowerQuery_2.23.-bit) [en-us].msiPowerQuery_2.23.-bit) [en-us].msiRelease Notes (English-only).docx6/3/201511.3 MB11.4 MB31 KB
Microsoft Power Query for Excel, is a new add-in that provides a seamless experience for data discovery, data transformation and enrichment for Information Workers, BI professionals and other Excel users.
With Power Query you can:
Identify the data you care about from the sources you work with (e.g. relational databases, Excel, text and XML files, OData feeds, web pages, Hadoop HDFS, etc.).
Discover relevant data from inside(*) and outside your organization using the search capabilities within Excel.
Combine data from multiple, disparate data sources and shape it in order to prepare the data for further analysis in tools like Excel and Power Pivot, or visualization in tools like Power View and Power Map.
Share the queries that you created with others within your organization, so they can be easily found via Search. (*)
(*) This capability requires Power BI for Office 365. You can learn more at .
Supported Operating System
Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2012
Windows Server 2008 R2
Windows Server 2012
Windows 8.1
The following Office versions are supported:
Microsoft Office 2010 Professional Plus with Software Assurance
Microsoft Office 2013:
Power Query Premium: All Power Query features available for: Professional Plus, Office 365 ProPlus or Excel 2013 Standalone
Power Query Public: Available for all other Office 2013 Desktop SKUs. Includes all Power Query features, except the following ones: Corporate Power BI Data Catalog, Azure-based data sources, Active Directory, HDFS, SharePoint Lists, Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, Exchange, Dynamics CRM, SAP BusinessObjects, Salesforce.
Microsoft Power Query for Excel requires Internet Explorer 9 or greater.
Microsoft Power Query for Excel is available for 32-bit (x86) and 64-bit (x64) platforms, your selection must match architecture of the installed version of Office.
Download the version of the Power Query add-in that matches the architecture (x86 or x64) of your Office installation. Run the MSI installer and follow the setup steps.
Microsoft(R) SQL Server(R) 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.
Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.
Microsoft SQL Server 2008 R2 Express with Service Pack 2 is a free and feature-rich database for developing and deploying SQL Server 2008 R2.
Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.
Includes Windows PowerShell 3.0, WMI, WinRM, Management OData IIS Extension, and Server Manager CIM Provider
Loading your results, please wait...
Security patches
Software updatesService packsHardware driversExperience the new and enhanced capabilities.