Coder Social home page Coder Social logo

xlsx-replacer's Introduction

xlsx-replacer

Description

This is a project for making .xlsx file as a template. With a template xlsx file containing ${slot} inside and this wonderful xlsx-replacer tool , You can get a target xlsx file !

Installation

# Using npm
npm install xlsx-replacer --save

# Or
# Using pnpm
pnpm install xlsx-replacer --save

How To Use

//  import it
import { XlsxReplacer } from 'xlsx-replacer'
// or default import
// import XlsxReplacer from 'xlsx-replacer'

const replacer = new XlsxReplacer()

//then you can await the replace method with your option
async function main(){
  const options = {
    template 'path/to/your/template/xlsx',
    rMap:{}
  }
  await replacer.replace(option)
}

replace function option should be set like this:

export type ReplaceOptions = {
  // template file path
  template: string;

  // replace map object
  rMap: { [k: string]: any };

  // empty slot, default is ${slotName}
  empty?: (slotName: string) => string;

  // whether to override the template instand of create a new file
  override?: boolean;

  // target xlsx output file path, not aviable when override is true,default path is same as template with ! in front
  target?: string;

   // unpacked path, where to generate unpacked, default dir is same as target's 
  unpacked?: string

  // whether to keep unpacked files when replaced
  keepUnpacked?: boolean;
};

Contribution

For now , it's just a basic version for our persion project. You can join the project to make it better if you want.

LICENSE

MIT

xlsx-replacer's People

Contributors

wusonw avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.