sheetjs / j Goto Github PK

it would be cool if you could pipe XLS data into j via process.stdin

Hi, I'm trying to convert my xlsx to csv from command line. But when I do, it only grabs first sheet. I know I can set the sheet with -s operator, but I'd like to automate this as much as possible. How do I grab all sheets? Not knowing what they may be called, since they are not labeled 0, 1, 2, etc... and sheet operator only works by naming sheet, i.e. j file.xlsx -s "My Sheet"

See SheetJS/sheetjs#35 (comment)

@nox0311 I agree that there should be a parser that can handle any valid Excel format, but the JS-XLSX repo should focus on OPC formats like XLSX and XLSM and XLSB.

Is there a way to take an excel file and copy to clipboard so that I can paste into google spreadsheet?

Can this read password-protected files?

OpenDocument Spreadsheet (.ods) format is supported in Excel 2013

EDIT: this is a bug in node v0.10.31 (nodejs/node-v0.x-archive#8208). If you find repeated segmentation faults, try rolling back to node 0.10.30. On linux and OSX, n on npm (https://www.npmjs.org/package/n) removes most of the hassle of switching between node versions.

Hi,

I'm trying to extract a sheet from a xlsb file. However when I open the file, I get the message "Segmentation Fault".
Same error occurred when I ran "j -l file.xlsb"
I'm just wondering how do I resolve that.

Hi,

When I am reading date from dbf file suppose 18/01/1974 which is in date format, J parser returning date as 17/01/1974. I am unable to understand why this is happening. Please help

This discussion has come up various times, and every time I've been hesitant due to size constraints, but it's becoming clear that the separate projects are slowing development.

Even worse, much of the code is duplicated in both projects, so merging would slim down the total size in a clean way (as opposed to various ad-hoc solutions). FYI The proverbial straw that broke the camel's back involved style parsing in XLS, which requires a stripped down version of the XLSX style parsing code (brilliant design on Microsoft's part to embed a ZIP file within the container).

Since github has no way to indicate that we are merging the projects, we will have to do it manually.

Questions:

1. The XLS, XLSX and HARB objects have the same interface, so we can fold all of the logic into one of the projects or create a new project. Which makes more sense?

2. Should the build process create separate scripts for the individual formats (an xls.js for the XLS format, xlsx.js etc)?

3. What should happen to the node modules and the other repos?

Pulling @elad @nathanathan @notatestuser

I am importing an excel file. By default Excel Internally handles decimals to the 15th place or something, but display these numbers as to a precision of 2 places behind the floating point.

When importing with J and xlsx.js it takes "what the human eye sees" out of the cells, but not the underlying values, internally held by excel.

Is there a method to define decimal precision when importing / exporting excel files?

If not, consider this is a feature request.

Currently all rows returned by to_json have a __rowNum__ property on their prototype. However, this property is enumerable, which causes it fail chai's deepEqual test.

If the property was non-enumerable this would make life much easier.

This affects both js-xls and js-xlsx. It does also affect CSV parsing with j, but did not find any __rowNum__ references in js-harb so I expect this is to due with the shared json output.

Thanks.

Can I build a standalone command that doesn't require nodejs?

Hi,

It seems that to_json uses undefined for empty cells. This makes it rather difficult to validate sheets with optional columns, or to ensure that there are no extra columns or extraneous data in unnamed columns.

In the same way, get_cols also omits any column with an empty header cell.

Could this be changed to use empty string or null?

Thanks.