cellref
所属分类:OA办公系统
开发工具:JavaScript
文件大小:0KB
下载次数:0
上传日期:2023-06-02 08:11:14
上 传 者:
sh-1993
说明: 在单元格引用样式(A1表示法和R1C1表示法)之间转换,
(Convert between cell reference styles (A1 notation & R1C1 notation),)
文件列表:
.editorconfig (188, 2023-07-19)
.npmignore (14, 2023-07-19)
CHANGELOG.md (609, 2023-07-19)
CONTRIBUTING.md (1198, 2023-07-19)
LICENSE (1060, 2023-07-19)
index.js (1725, 2023-07-19)
package-lock.json (111227, 2023-07-19)
package.json (948, 2023-07-19)
spec.js (1608, 2023-07-19)
# cellref
[![Version](https://img.shields.io/npm/v/cellref.svg?style=flat-square)](https://www.npmjs.com/package/cellref)
[![Build Status](https://img.shields.io/github/actions/workflow/status/mike182uk/cellref/ci.yml?branch=main&style=flat-square)](https://github.com/mike182uk/cellref/actions/workflows/ci.yml?query=workflow%3ACI)
[![Coveralls](https://img.shields.io/coveralls/mike182uk/cellref/main.svg?style=flat-square)](https://coveralls.io/r/mike182uk/cellref)
[![npm](https://img.shields.io/npm/dm/cellref.svg?style=flat-square)](https://www.npmjs.com/package/cellref)
[![License](https://img.shields.io/github/license/mike182uk/cellref.svg?style=flat-square)](https://www.npmjs.com/package/cellref)
Convert between cell reference styles (`A1` notation & `R1C1` notation).
## Installation
```
npm install --save cellref
```
## Usage
### Convert A1 to R1C1
```js
const cellref = require('cellref')
cellref.toR1C1('BU59') // will return R59C73
```
### Convert R1C1 to A1
```js
const cellref = require('cellref')
cellref.toA1('R59C73') // will return BU59
```
### Convert automatically based on the input
```js
const cellref = require('cellref')
cellref('R59C73') // will return BU59
cellref('BU59') // will return R59C73
```
If an invalid cell reference (not `A1` or `R1C1` notation) is passed as an argument to any of cellref functions, an `Error` will be thrown.
近期下载者:
相关文件:
收藏者: