ref: c0a7fbea1f61b1d77a09d612b85c74fd6c673b7c
dir: /sys/man/1/doc2txt/
.TH DOC2TXT 1 .SH NAME doc2txt, doc2ps, wdoc2txt, xls2txt, olefs, mswordstrings, msexceltables \- extract printable text from Microsoft documents .SH SYNOPSIS .B doc2txt [ .I file.doc ] .br .B doc2ps [ .I file.doc ] .br .B wdoc2txt [ .I file.doc ] .br .B xls2txt [ .I file.xls ] .br .B aux/olefs [ .B -m .I mtpt ] .I file.doc .br .B aux/mswordstrings .IB mtpt /WordDocument .br .B aux/msexceltables [ .B -qaDnt ] [ .B -d .I delim ] [ .B -c .I column-range ] [ .B -w .I worksheet-range ] .IB mtpt /Workbook .SH DESCRIPTION .I Doc2txt is an .IR rc (1) script that uses .I olefs and .I mswordstrings to extract the printable text from the body of a Microsoft Word document and write it on the standard output. .I Doc2ps is similar, but emits PostScript corresponding to the document. .I Wdoc2txt is similar to .IR doc2txt , but uses .IR plumb (1) to send the output to a new .IR acme (1) window instead. .I Xls2txt performs a similar function for Microsoft Excel documents. .PP Microsoft Office documents are stored in OLE (Object Linking and Embedding) format, which is a scaled down version of Microsoft's FAT file system. .I Olefs presents the contents of an MS Office document as a file system on .IR mtpt , which defaults to .BR /mnt/doc . .I Mswordstrings or .I msexceltables may then be used to parse the files inside, extracting a text stream. .I Msexceltables may be given options to control the formatting of its output. .TF "\fL-d \fIdelim" .TP .B -a Attempt conversion of non-tabular sheets in the workbook (charts). .TP .BI -d " delim Sets the inter-field delimiter to the string .IR delim , by default a single space. .TP .B -D Enables debugging output. .TP .BI -c " range .I Range is a comma-separated list of column numbers and ranges. Ranges are separated by dashes. Limit processing to just those columns named; by default all columns are output. .TP .B -n Disables field padding to column width. .TP .B -q Disable quoting of textural fields (see .IR quote (2).) .TP .B -t Truncate fields to the column width. .TP .BI -w " range .I Range is a comma-separated list of worksheet numbers and ranges, this limits the sheets output using the same syntax as the .B -c option above. Suppressed chart pages are always included in the sheet count. .SH EXAMPLE Extract pieces of an MS Excel spreadsheet. .PD 0 .IP .EX .SM aux/olefs report.xls msexceltables -q -w 1,7,9-14 -c 3-5 -n -d '@' /mnt/doc/Workbook > rpt.txt unmount /mnt/doc .EE .PD .SH SOURCE .TF "\fL/sys/src/cmd/aux " .TP .B /rc/bin .BR doc2txt , .BR doc2ps , .BR wdoc2txt, and .BR xls2txt .TP .B /sys/src/cmd/aux the others .fi .PD .SH SEE ALSO .IR strings (1) .br ``Microsoft Word 97 Binary File Format'', at Microsoft's developer (MSDN) home page. .br ``LAOLA Binary Structures'', .B http://user.cs.tu-berlin.de/~schwartz/pmh .br ``OpenOffice.Org's Excel Documentation'', .br .B http://sc.openoffice.org/excelfileformat.pdf