Parse Word document to upload data to database

anandhkumar · #1 June 11th, 2009, 12:18 PM

hi dudes

can anyone there guide me in parsing word document to upload the data from word doc to d/b using ruby on rails... It would be helpful if i get a sample description of that code...

acoder · #2 June 14th, 2009, 02:41 PM

I've moved your post to the correct place, so that the experts can have a look at it and perhaps provide some clues. Oh, and welcome to Bytes!

-Moderator

improvcornartist · #3 June 15th, 2009, 06:04 PM

You can use win32ole to parse the Word documents, then just grab the text and save it in the database. Here's an example for getting text out of a Word document:

Expand|Select|Wrap|Line Numbers

 require 'win32ole'

word = WIN32OLE.new('word.application')

word.documents.open(path_to_file)
 
# select whole text

word.selection.wholestory
 
# read the selection

puts word.selection.text.chomp
 
# close document

word.activedocument.close( false ) # no save dialog, just close it
 
# quit word

word.quit

Parse Word document to upload data to database

re: Parse Word document to upload data to database

re: Parse Word document to upload data to database

/bytes/development

/bytes/it

/bytes/about