I did parsing of xlsx from scratch. In our project we have to be able to 
import-export data from predefined templates. Result documents contained 
just a text (though with arbitrary formatting applied)

I didn't attempt to mirror native Excel API, but had an collection of 
functions manipulating the plain raw DOM of content parts. For example, 
there were functions:

  setTags(data) // Place in your excel document tags like &DATE&, &PRICE& 
and get them replaced with data
  exportRange() // paste data to the named range
  importRange() // Import data from the named range

all above with respect of original formatting and other content.
 
It took me about 1 - 2 weeks to implement this. Note that it was in SAP 
ABAP environment and I am not a very productive programmer.
Probably implementing this 100% correctly is a hard task but if you have a 
control on your templates it's not something terrible.

In our project there where thoughts about forcing users to use CSV, Office 
XML format (which is simpler but not size scalable and also uses terrible 
.xml extension), about various kinds of interop. But it's all crap. I don't 
recommend to move in this direction. 


On Saturday, April 9, 2011 12:17:41 AM UTC+4, busticated wrote:
>
> Hi all - 
>      I'm wondering if anyone has attempted to read / write MS Excel 
> files using Node? And if so, are there any tips / tricks you are 
> willing to share? A quick scan of GitHub yielded zero. 
>
> -matt

-- 
Job Board: http://jobs.nodejs.org/
Posting guidelines: 
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
You received this message because you are subscribed to the Google
Groups "nodejs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en

Reply via email to