Comments (3)
The raw value should be stored as the .v
field of the cell object (the displayed value is stored in the .w
field). Do you have an example where it's not exposed?
from j.
workbook = J.readFile(filename)
workbookJSON = J.utils.to_json(workbook)
sheetArray = []
for k,v of workbookJSON
sheetArray.push k
sheetone = sheetArray[0]
sheetoneJSON = workbookJSON[sheetone]
async.eachLimit sheetoneJSON, 100, ((item, callback) ->
console.log item.v # undefined
console.log item # works, but only gives formated number of Excel
callback null
), (err) ->
# done
Sorry for the long wait, but I was busy with other parts of the software, now after the first couple of releases this problem popped up again.
from j.
This is managed in the xlsx
dependency now
from j.
Related Issues (13)
- Support CSV and TSV HOT 6
- standalone HOT 2
- How to default all sheets HOT 2
- Reading Wrong date from DBF HOT 1
- password protected files HOT 2
- read from stdin on the command line HOT 4
- Segmentation fault when accessing a xlsb file HOT 6
- ODS support HOT 3
- Clipboard support HOT 3
- to_json omits empty cells HOT 2
- Make __rowNum__ non-enumerable HOT 2
- Merging various projects (js-xls, js-xlsx, js-harb) HOT 5
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from j.