{"repo":"Claviz/xlstream","free":true,"listed":false,"github":"https://github.com/Claviz/xlstream","clone":"git clone https://github.com/Claviz/xlstream.git","description":"Turns XLSX into a readable stream.","language":"TypeScript","stars":176,"topics":["xlsx","node","stream-processing","excel"],"license":"MIT","category":"data-pipelines","readme_excerpt":"xlstream Memory-efficiently turns XLSX file into a transform stream with all its benefits. - Stream is pausable . - Emits all default events ( data , end , etc.) - Returns header , raw and formatted row data, as well as totalSheetSize and processedSheetSize (in bytes) in just one data event. - Maintains desirable behavior of merged cells . - Supports files created by OpenXML . - Supports standard , Excel and custom number formats . Installation Example source.xlsx contents: A B ----- --- hello 123 Where 123 is a 123.123 number formatted to be rounded to integer. Script: Result: getXlsxStream Returns transform stream of the sheet. Options option type description --------------- --------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- filePath string Path to the XLSX file sheet string or number If string is passed, finds sheet by it's name. If number , finds sheet by it's index. withHeader boolean or number If true , column names will be taken from the first sheet row. If duplicated header name is found, column name will be prepended with column letter to maintain uniqueness. 0-based row location can be passed to this option if header is","default_branch":null,"files":null,"tree":[],"storefront":"/r/Claviz","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Claviz/xlstream/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}