grunt-meta-excel

Update meta tags according to .xlsx file.
HTMLファイルのtitle, description, keywords, OGPなどの値を、Excelファイルの内容にあわせて更新するGruntプラグイン。

Getting Started

This plugin requires Grunt ~0.4.5

If you haven't used Grunt before, be sure to check out the Getting Started guide, as it explains how to create a Gruntfile as well as install and use Grunt plugins. Once you're familiar with that process, you may install this plugin with this command:

$ npm install grunt-meta-excel --save-dev

※インストールに失敗する場合、node-gypの動作条件が満たされていない可能性が考えられます。 https://github.com/TooTallNate/node-gyp

Once the plugin has been installed, it may be enabled inside your Gruntfile with this line of JavaScript:

grunt.loadNpmTasks( "grunt-meta-excel" );

The "meta_excel" task

Overview

In your project's Gruntfile, add a section named meta_excel to the data object passed into grunt.initConfig().

grunt.initConfig({
  meta_excel: {
    options: {
      // Task-specific options go here.
    },
    your_target: {
      // Target-specific file and options go here.
    },
  },
});

Options

• htmlDir String
  Path to html files root directory.

• xlsx String
  Path to xlsx file.

• options Object

  • dataStartingRow Number (*one-based row position)
  • mapping Object
  • charset String
  • patternsJsonPath String

Usage Examples

grunt.initConfig( {
    meta_excel: {
        options: {
            dataStartingRow: 8,
            mapping: {
                path: "A",
                title: "B",
                title_all: "D",
                description: "E",
                keywords: "F",
                url: "G",
                thumbnail: "H",
                canonical: "I"
            }
        },
        sample_site: {
            xlsx: "sample/pages.xlsx",
            htmlDir: "sample/htdocs/"
        }
    }
} );
 
grunt.loadNpmTasks( "grunt-meta-excel" );

$ grunt meta_excel