本文整理汇总了TypeScript中xlsx.read函数的典型用法代码示例。如果您正苦于以下问题:TypeScript read函数的具体用法?TypeScript read怎么用?TypeScript read使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了read函数的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的TypeScript代码示例。
示例1: while
return new Promise<any>((resolve, reject) => {
this.workbooks = [];
for (let file of inputData) {
this.workbooks.push(xlsx.read(file, {"type": "buffer"}));
}
let workbook = this.workbooks.pop();
while (workbook != null) {
workbook.SheetNames.forEach((sheetName) => {
let worksheet = workbook.Sheets[sheetName];
let worksheetAsJson = xlsx.utils.sheet_to_json(worksheet);
let keys = [];
worksheetAsJson.forEach((item) => {
for(var k in item)
if(!keys.includes(k))
keys.push(k);
});
let properties = {};
for(let i=0; i<keys.length; i++)
properties[keys[i]] = {"type": "string"};
this.schema.toObject().properties[sheetName] = {"type": "array", "items":{"type": "object", "properties":properties}};
});
// next workbook
workbook = this.workbooks.pop();
}
resolve();
});
开发者ID:sebischair,项目名称:syncpipes-server,代码行数:32,代码来源:service.ts
示例2: Transform
export function Transform (buffer, options) {
let meta = options.meta || false;
let offset = options.offset || 0;
let excel = XLSX.read(buffer, {binary:true, bookProps: meta});
if (meta === true) {
return excel.Props;
}
let sheets = excel.Sheets,
sheet, k;
let output = [];
for (k in sheets) {
sheet = sheets[k];
let json = sheet_to_json(sheet, {
raw: false
});
output.push(json);
}
output = flatten(output)
if (offset >= output.length) {
output = [];
} else {
output = output.slice(offset, output.length);
}
return output;
};
开发者ID:kildevaeld,项目名称:pipe2,代码行数:31,代码来源:transform.ts
示例3: prepare
prepare(context: SyncPipes.IPipelineContext, logger: SyncPipes.ILogger): Promise<any> {
this.context = context;
this.workbooks = [];
// load xlsx file(s) from context
for (let file of context.inputData) {
this.workbooks.push(xlsx.read(file, {"type": "buffer"}));
}
// resolve immediately, since no async work is done
return Promise.resolve();
}
开发者ID:sebischair,项目名称:syncpipes-server,代码行数:10,代码来源:service.ts
示例4:
cellDates: false,
bookSST: false,
bookType: "xlsx",
sheet: "Sheet1",
compression: false,
Props: {
Author: "Someone",
Company: "SheetJS LLC"
}
};
const wb1 = XLSX.readFile("sheetjs.xls", read_opts);
XLSX.writeFile(wb1, "sheetjs.new.xlsx", write_opts);
read_opts.type = "binary";
const wb2 = XLSX.read("1,2,3\n4,5,6", read_opts);
write_opts.type = "binary";
const out2 = XLSX.write(wb2, write_opts);
read_opts.type = "buffer";
const wb3 = XLSX.read(fs.readFileSync("sheetjs.xlsx"), read_opts);
write_opts.type = "base64";
const out3 = XLSX.write(wb3, write_opts);
write_opts.type = "array";
const out4 = XLSX.write(wb3, write_opts);
const ws1 = XLSX.utils.aoa_to_sheet([
"SheetJS".split(""),
[1,2,3,4,5,6,7],
[2,3,4,5,6,7,8]
], {
开发者ID:CareerFairPlus,项目名称:js-xlsx,代码行数:31,代码来源:doc.ts
示例5:
import * as XLSX from 'xlsx';
console.log(XLSX.version);
const bookType: string = "xlsb";
const fn: string = "sheetjsfbox." + bookType
const sn: string = "SheetJSFBox";
const aoa: any[][] = [ ["Sheet", "JS"], ["Fuse", "Box"], [72, 62] ];
var wb: XLSX.WorkBook = XLSX.utils.book_new();
var ws: XLSX.WorkSheet = XLSX.utils.aoa_to_sheet(aoa);
XLSX.utils.book_append_sheet(wb, ws, sn);
var payload: string = "";
var w2: XLSX.WorkBook;
if(typeof process != 'undefined' && process.versions && process.versions.node) {
/* server */
XLSX.writeFile(wb, fn);
w2 = XLSX.readFile(fn)
} else {
/* client */
payload = XLSX.write(wb, {bookType: "xlsb", type:"binary"});
w2 = XLSX.read(payload, {type:"binary"});
}
var s2: XLSX.WorkSheet = w2.Sheets[sn];
console.log(XLSX.utils.sheet_to_csv(s2));
开发者ID:CareerFairPlus,项目名称:js-xlsx,代码行数:28,代码来源:sheetjs.ts
注:本文中的xlsx.read函数示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论