Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Roadmap #5

Open
5 tasks
acedward opened this issue May 10, 2016 · 4 comments
Open
5 tasks

Roadmap #5

acedward opened this issue May 10, 2016 · 4 comments

Comments

@acedward
Copy link
Contributor

acedward commented May 10, 2016

  • Parsing dates from an excel in returning invalida dates (internal excel model)
    temporal workaround:
var ms = ((numericExcelDate - (25567 - 1)) * 86400 * 1000);
var ms_offset = (new Date().getTimezoneOffset() * 60000);
var dt = new Date(ms + ms_offset);
  • Use underlying XLSX module directly. Will allow finer control over transformations.
  • Allow compressing arrays
    e.g.,
    now: { anArray : [ 1, 'a', 3 ] , aString : 'hey' }
    is converted to:
anArray[0] anArray[1] anArray[2] aString[0]
1 a 3 hey

it could be, optionally, converted to:

anArray[0] aString[0]
1, a, 3 hey

Allowing external systems/scripts to easily access information based on column position

  • Add Convert From XLSX tests
  • Convert to CSV
@acedward
Copy link
Contributor Author

acedward commented May 10, 2016

  • Fix performance issues. Perfomance was boosted by caching and smart iterating
  • Fix date objects (Fixed: test@ test_time.js but test are more lax)
  • Add Model examples and tests (more model examples needed!)
  • Add negative test so that we can check the custom-deep-comparators
  • Add Mongoose import/export test (Support for ObjectIDs was added)
  • Not using modelMap to convert from excel to json. Fixed
  • May not work well with mixed types for the same key. No more issues found related with
  • Nested objects "first" element element may not be a numeric or string-numeric:
    (ECMA-262 does not specify enumeration order. The de facto standard is to match insertion order.). But node implementation show to be stable, this will probably not changed as a new data type SET was added to es2015
  • Very Slow :'( Some Performance Issues @ JSON.parse(JSON.stringify(x)) to make a copy and not modify original data (error1_test.json). Fixed
  • nulls, empty cells, undefined hell. Test are needed to better understand transformations

@acedward
Copy link
Contributor Author

  • Replace write/read library
  • Issue with different length sub arrays objects. E.g., { dates : [ { start: Date, end: Date }] }
  • Multiple and Single page behave differently ( Array of Arrays vs Array )
  • Style: Allow to config colors, widths, etc
  • As the library name suggests - create functions to dump from mongodb

@acedward
Copy link
Contributor Author

[ ] Update to EC6 sintax, (node v6)

@BMLande
Copy link

BMLande commented Aug 21, 2017

  • i am trying to convert json to excel its done
  • i need the excel records which are not added data
  • for ex:

no A B C(header)

  1. a b
  2. a b c
  3. a

in above example i need the result as row 1 and 3 are incomplete.
can you please add one method to this package which will return the excel rows which are not having data.
thanks
regards
Bhagvat Lande

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants