xlsx2email

• Auto generate inline css html and text version for your template
• Auto read through a xlsx file and generate html emails based on template you create

Using librarys

• Gulp
• Gulp-compass
• Ink ---> responsive css frame work
• Premailer ---> inline css generating
• simpleXLSX --> xlsx reading

Install

Preinstall Premailer required

npm install

Setting

open gulpfile and you can modify:

var file = 'template/normal/template.html';
var xlsx_file = "xlsx/xlsx.xlsx";
var email_dir = "html/";
var key_code = "file-name";

Running

Gulp

Template lauguage

• Put '{{' and '}}' next to your key words
• Key words must match to index row in your spread sheet
• Ex:

<h1> {{title}} </h1>
<p> {{body}} </p>

##xlsx File

• It has to be .xlsx
• Row index must match key words in template
• There need to be one index for unique key code to generate the emails name
• Do not put white space in key code if you are using guard
• Ex:

keycode	title	body
1	hello	world
2	hi	how are you