# spread_sheet

> Add single row to spreadsheet

Latest version **2.2.1** (published 2017-07-19) · MIT license · 0 weekly downloads

## Install

```sh
npm install spread_sheet
pnpm add spread_sheet
yarn add spread_sheet
bun add spread_sheet
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 2.2.1 |
| Published | 2017-07-19 |
| First published | 2017-07-01 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 2 |
| Known vulnerabilities | 0 (+5 in 1 direct dependencies) |
| Install scripts | no |
| GitHub stars | 4 |
| Author | Pranjal Sharma |
| Maintainers | pr306500 |
| Keywords | xlsx, excelrange |

## Links

- npm: https://www.npmjs.com/package/spread_sheet
- Repository: https://github.com/pr306500/spread-sheet
- Homepage: https://github.com/pr306500/spread-sheet#readme
- Issues: https://github.com/pr306500/spread-sheet/issues
- npm.io page: https://npm.io/package/spread_sheet

## Dependencies (2)

- [xlsx](https://npm.io/package/xlsx.md) 0.10.5
- [excelrange](https://npm.io/package/excelrange.md) 0.0.3

## Recent versions

- 2.2.1 (latest) — 2017-07-19
- 1.2.1 — 2017-07-04
- 1.2.0 — 2017-07-03
- 1.1.0 — 2017-07-01
- 1.0.0 — 2017-07-01

## README

# Spread Sheet

  The spread sheet helps in by adding rows and reading rows by providing 'from_row', 'to_row' params present in spread sheet.


##In order to add a row, a person must following info :-

1. Rows (you want to add in spread sheet)
2. Filepath (path where your spreadsheet resides)
3. Sheet Name (Name of your sheet where yoou want to add row)


### Detailed steps

#### Step 1. After installing "spread_sheet" module, do [var spreadSheet = require('spread_sheet')].

#### Step 2. spreadSheet.addRow(row,filePath,sheetName,function(err,result){}).

#### Step 3. Arguments behaviour:-

      1. Row

         It must be string.

         var row = [[1,2,3],['a',45,56]]; // To add multiple rows.

      2. filePath

         var filePath = '/home/pranjal/Desktop/test.xlsx';

      3. sheetName

         var sheetName = 'Sheet1';

      4. Last argument is the callback (cb), which accepts error and result.   


## In order to get rows, follow the following steps :-

1. Filepath (path where your spreadsheet resides)
2. Sheet Name (Name of your sheet where yoou want to add row)
3. From Row (Add value of row ex. 1 or 5 .., to get info from specific row)
4. To Row (Add value of row ex. 1,2 or 6 .., to get info from specific row)


### Detailed steps

#### Step 1. After installing "spread_sheet" module, do [var spreadSheet = require('spread_sheet')].

#### Step 2. spreadSheet.getRows(filepath,sheet_name,from_row,to_row,function(err,result){}).

#### Step 3. Arguments behaviour:-

      1. fromRow

         It must be string/numeric.

         var from_row = 4;

      2. filePath

         var filePath = '/home/pranjal/Desktop/test.xlsx';

      3. sheetName

         var sheetName = 'Sheet1';

      4. toRow

         It must be string/numeric.

         var to_row = 8;  

      5. Last argument is the callback (cb), which accepts error and result.   

 It will fetch only those rows mentioned in from_row to to_row from spreadsheet.

---
_Source: https://npm.io/package/spread_sheet · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._
