2017-05-09 18:07:57 +00:00
|
|
|
## Philosophy
|
|
|
|
|
|
|
|
<details>
|
2017-09-24 23:40:09 +00:00
|
|
|
<summary><b>Philosophy</b> (click to show)</summary>
|
2017-05-09 18:07:57 +00:00
|
|
|
|
|
|
|
Prior to SheetJS, APIs for processing spreadsheet files were format-specific.
|
|
|
|
Third-party libraries either supported one format, or they involved a separate
|
|
|
|
set of classes for each supported file type. Even though XLSB was introduced in
|
|
|
|
Excel 2007, nothing outside of SheetJS or Excel supported the format.
|
|
|
|
|
|
|
|
To promote a format-agnostic view, js-xlsx starts from a pure-JS representation
|
|
|
|
that we call the ["Common Spreadsheet Format"](#common-spreadsheet-format).
|
2017-08-01 05:50:53 +00:00
|
|
|
Emphasizing a uniform object representation enables new features like format
|
2017-09-24 23:40:09 +00:00
|
|
|
conversion (reading an XLSX template and saving as XLS) and circumvents the
|
2017-05-09 18:07:57 +00:00
|
|
|
"class trap". By abstracting the complexities of the various formats, tools
|
|
|
|
need not worry about the specific file type!
|
|
|
|
|
|
|
|
A simple object representation combined with careful coding practices enables
|
|
|
|
use cases in older browsers and in alternative environments like ExtendScript
|
|
|
|
and Web Workers. It is always tempting to use the latest and greatest features,
|
|
|
|
but they tend to require the latest versions of browsers, limiting usability.
|
|
|
|
|
|
|
|
Utility functions capture common use cases like generating JS objects or HTML.
|
|
|
|
Most simple operations should only require a few lines of code. More complex
|
|
|
|
operations generally should be straightforward to implement.
|
|
|
|
|
|
|
|
Excel pushes the XLSX format as default starting in Excel 2007. However, there
|
|
|
|
are other formats with more appealing properties. For example, the XLSB format
|
|
|
|
is spiritually similar to XLSX but files often tend up taking less than half the
|
|
|
|
space and open much faster! Even though an XLSX writer is available, other
|
|
|
|
format writers are available so users can take advantage of the unique
|
|
|
|
characteristics of each format.
|
|
|
|
|
2018-05-21 01:41:01 +00:00
|
|
|
The primary focus of the Community Edition is correct data interchange, focused
|
|
|
|
on extracting data from any compatible data representation and exporting data in
|
|
|
|
various formats suitable for any third party interface.
|
|
|
|
|
2017-05-09 18:07:57 +00:00
|
|
|
</details>
|
|
|
|
|