Title: Gravity Forms To Excel AddOn Author: Dieter Pfenning Published: 2015 年 7 月 6 日 Last modified: 2016 年 3 月 5 日 --- 搜索插件 ![](https://ps.w.org/gravity-forms-to-excel-addon/assets/banner-772x250.jpg?rev= 1193126) **该插件尚未通过WordPress的最新3个主要版本进行测试**。 当与较新版本的WordPress一起 使用时，可能不再受到维护或支持，并且可能会存在兼容性问题。 ![](https://ps.w.org/gravity-forms-to-excel-addon/assets/icon-128x128.jpg?rev=1193171) # Gravity Forms To Excel AddOn 作者：[Dieter Pfenning](https://profiles.wordpress.org/winball/) [下载](https://downloads.wordpress.org/plugin/gravity-forms-to-excel-addon.0.1.5.2.zip) * [详情](https://cn.wordpress.org/plugins/gravity-forms-to-excel-addon/#description) * [评价](https://cn.wordpress.org/plugins/gravity-forms-to-excel-addon/#reviews) * [安装](https://cn.wordpress.org/plugins/gravity-forms-to-excel-addon/#installation) * [开发进展](https://cn.wordpress.org/plugins/gravity-forms-to-excel-addon/#developers) [支持](https://wordpress.org/support/plugin/gravity-forms-to-excel-addon/) ## 描述 This Gravity Forms AddOn saves form data into a given Excel document and attaches it to notification emails. You don’t need any programming skills to get native Excel documents back as the result of your Gravity Forms web form. After uploading your Excel 2007 file (.xslx, other versions are not supported) the form data is saved into one sheet (which you can define) of your document. You can then select to which notification emails this Excel file should be attached to. Using simple Excel formulas( =A1) you can fill out complex Excel sheets with data from the web form. No further export or import of CSV data is required. #### Operating instructions 1. Create your form with Gravity Forms 2. Give all your fields admin field labels (under the tab “Advanced”) 3. Create your notification emails 4. Open the GF2Excel form settings, upload your Excel file, type in your sheet number to insert the form data and finally select the notifications you would like to attach the filled in Excel file. 5. Submit your form and open your Excel file. Connect your actual form fields through formulas (=A1) with data of the sheet which is filled by Gravity Forms. The admin field labels will help you to associate the data with the form fields. 6. Open the WP4O-GF2Excel form settings again and upload the Excel file with your formulas. 7. Repeat steps 5 and 6 until you are satisfied with the result. 8. Be happy 🙂 _This plugin requires Gravity Forms by RocketGenius to be active._ _This plugin was successfully tested on WordPress Multisite without any abnormalities._ This plugin is maintained [by winball.de](http://winball.de) on [wp4office.winball2.de](http://wp4office.winball2.de/gf2excel). We welcome your pull requests, comments and suggestions for improvement. Additional [help and example files](http://wp4office.winball2.de/gf2excel/help) with descriptions are available. You can [try out a demo](http://wp4office.winball2.de/gf2excel/demo) before installing. #### You do have problems or need individual service? If you do have problems with your Excel files please have a look at the [FAQ](https://wordpress.org/plugins/gravity-forms-to-excel-addon/faq/). Professional web services are our actual business. If you need help with your form or your Excel file, please feel free to [contact us](http://winball.de/wp4office-gf2excel-services). ## 屏幕截图 [⌊Use the admin field labels to associate the data with the form fields.⌉⌊Use the admin field labels to associate the data with the form fields.⌉[ Use the admin field labels to associate the data with the form fields. [⌊Upload your Excel file, type in your sheet number and select the notifications.⌉⌊ Upload your Excel file, type in your sheet number and select the notifications.⌉[ Upload your Excel file, type in your sheet number and select the notifications. [⌊The target sheet will contain the admin field labels in column A and the form data in column B.⌉⌊The target sheet will contain the admin field labels in column A and the form data in column B.⌉[ The target sheet will contain the admin field labels in column A and the form data in column B. [⌊Using simple formulas (e.g. A1=...) your Excel sheet will show the data coming from the web form.⌉⌊Using simple formulas (e.g. A1=...) your Excel sheet will show the data coming from the web form.⌉[ Using simple formulas (e.g. A1=…) your Excel sheet will show the data coming from the web form. ## 安装 Upload the plugin to your blog into ‘/wp-content/plugins/’ (manually via ftp or through the dashboard) and activate it. _This plugin requires Gravity Forms by RocketGenius to be active._ ## 常见问题 Can i use Excel templates containing macros and form fields? **No**. Based on the functional range of the PHPExcel library we use in this AddOn there are some limitations regarding to the Excel files and the contents within these files. * We **only** support Excel 2007 (.xslx) (more formats on the wishlist) * We do not support macros (on the wishlist) * We do not support Excel form fields like buttons ## 评价 ![](https://secure.gravatar.com/avatar/a84c9dbfe12aa6ed2ea58abb8d6fb4d96b620a3b977f0bf6ec9e22deba4a796a? s=60&d=retro&r=g) ### 󠀁[very good – very smart plugin](https://wordpress.org/support/topic/very-good-very-smart-plugin/)󠁿 [roycegracie](https://profiles.wordpress.org/roycegracie/) 2016 年 12 月 14 日 a little bit hard to understand what to do. it’s better if you show on video. but the plugin itself is perfect ! ![](https://secure.gravatar.com/avatar/8b51ccec171abad65888ce9f5056494c803b32f09458fade5fe060e9fa28bcd4? s=60&d=retro&r=g) ### 󠀁[Good online solution for Excel based workflows](https://wordpress.org/support/topic/good-online-solution-for-excel-based-workflows/)󠁿 [Udo79](https://profiles.wordpress.org/udo79/) 2016 年 9 月 3 日 We are a consultant company supporting customers by optimizing their Office workflows. Using this plugin we already optimized several customer online based workflows. ![](https://secure.gravatar.com/avatar/450c5927217d309aca50ee07e7a5340002b46e7be97c5efe2ea62925e7929960? s=60&d=retro&r=g) ### 󠀁[Simply works](https://wordpress.org/support/topic/simply-works-99/)󠁿 [kalle22](https://profiles.wordpress.org/kalle22/) 2016 年 9 月 3 日 This plugin is very simple to use and does what it promises. [ 阅读所有4条评价 ](https://wordpress.org/support/plugin/gravity-forms-to-excel-addon/reviews/) ## 贡献者及开发者 「Gravity Forms To Excel AddOn」是开源软件。 以下人员对此插件做出了贡献。 贡献者 * [ Dieter Pfenning ](https://profiles.wordpress.org/winball/) [帮助将「Gravity Forms To Excel AddOn」翻译成简体中文。](https://translate.wordpress.org/projects/wp-plugins/gravity-forms-to-excel-addon) ### 对开发感兴趣吗? 您可以[浏览代码](https://plugins.trac.wordpress.org/browser/gravity-forms-to-excel-addon/)， 查看[SVN仓库](https://plugins.svn.wordpress.org/gravity-forms-to-excel-addon/)， 或通过[RSS](https://plugins.trac.wordpress.org/log/gravity-forms-to-excel-addon/?limit=100&mode=stop_on_copy&format=rss) 订阅[开发日志](https://plugins.trac.wordpress.org/log/gravity-forms-to-excel-addon/)。 ## 更新日志 #### 0.1.5.0 * changed sample excel file to contain VLOOKUP in cield C7 * fixed blank page of death after activation, when activated without having Gravity Forms active * fixed $form[‘gf2excel-addon’] not defined #### 0.1.4.2 * changed readme, added FAQ #### 0.1.4 * changed saving of values from multiple selected checkboxes in multiple lines to single line (like Multi Select) * fixed missing admin labels for checkboxes * added check for missing GET field * fixed file not found bug (for excel templates) with WordPress installations in subdirectories, replaced ABSPATH * fixed missing charts in output excel to templates containing charts #### 0.1.3 * make first sheet (index 0) active, not the sheet, where the form data is stored * columns A and C switched, to allow the use of VLOOKUP in Excel * validate user input and create error messages when required * language support added (I18n) * Gift Certificate sample added #### 0.1.2 * fixed issue with no selected notifications in wp4o-gf2excel and blank screen after sending form #### 0.1.1 * Initial release. ## 额外信息 * 版本 **0.1.5.2** * 最后更新：**10 年前** * 活跃安装数量 **70+** * WordPress 版本 ** 3.7 或更高版本 ** * 已测试的最高版本为 **4.4.34** * 语言 * [English (US)](https://wordpress.org/plugins/gravity-forms-to-excel-addon/) * 标签 * [attachment](https://cn.wordpress.org/plugins/tags/attachment/)[excel](https://cn.wordpress.org/plugins/tags/excel/) [excel export](https://cn.wordpress.org/plugins/tags/excel-export/)[forms](https://cn.wordpress.org/plugins/tags/forms/) [GravityForms](https://cn.wordpress.org/plugins/tags/gravityforms/) * [高级视图](https://cn.wordpress.org/plugins/gravity-forms-to-excel-addon/advanced/) ## 评级 4 星（最高 5 星）。 * [ 3 条 5 星评价 ](https://wordpress.org/support/plugin/gravity-forms-to-excel-addon/reviews/?filter=5) * [ 0 条 4 星评价 ](https://wordpress.org/support/plugin/gravity-forms-to-excel-addon/reviews/?filter=4) * [ 0 条 3 星评价 ](https://wordpress.org/support/plugin/gravity-forms-to-excel-addon/reviews/?filter=3) * [ 0 条 2 星评价 ](https://wordpress.org/support/plugin/gravity-forms-to-excel-addon/reviews/?filter=2) * [ 1 条 1 星评价 ](https://wordpress.org/support/plugin/gravity-forms-to-excel-addon/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/gravity-forms-to-excel-addon/reviews/#new-post) [查看全部评论](https://wordpress.org/support/plugin/gravity-forms-to-excel-addon/reviews/) ## 贡献者 * [ Dieter Pfenning ](https://profiles.wordpress.org/winball/) ## 支持 有话要说吗？是否需要帮助？ [查看支持论坛](https://wordpress.org/support/plugin/gravity-forms-to-excel-addon/)