Friday 16 September 2011

XQuery/MarkLogic: pulling data out of an Excel spreadsheet

Excel spreadsheets can be saved in an xml format - in such cases, it's simple to dump the xml into a CQ buffer (if you're using MarkLogic) and parse the information in adjacent column cells.

In this example, I'm taking a very simple spreadsheet structure to illustrate the procedure:

HEADER 1 HEADER 2
Val 1a Val 1b
Val 2a Val 2b
... ...

Below is an example of how to parse the XML, pull out the information from the relevant cells and strip white space for good measure:


You should end up with something like this:
Posted by at
Labels: , , ,

3 comments:

AKON said...

Thanks for taking the time to discuss that, I feel strongly about this and so really like getting to know more on this kind of field. Do you mind updating your blog post with additional insight? It should be really useful for all of us. Microsoft Excel Training Courses Malaysia

29 October 2017 at 04:38
GULO said...

Thanks for sharing the info, keep up the good work going.... I really enjoyed exploring your site. good resource... for grammarly trial click here

8 October 2018 at 17:29
IMF said...

Awesome article! I want people to know just how good this information is in your article. It’s interesting, compelling content. Your views are much like my own concerning this subject. grammar checking

24 August 2019 at 10:39

Post a Comment

Subscribe to: Post Comments (Atom)