Description Usage Arguments Details Value Author(s) References See Also Examples
Extract tables from a file
1 2 3 |
file |
A character string specifying the path or URL to a PDF file. |
pages |
An optional integer vector specifying pages to extract from. |
area |
An optional list, of length equal to the number of pages specified, where each entry contains a four-element numeric vector of coordinates (top,left,bottom,right) containing the table for the corresponding page. As a convenience, a list of length 1 can be used to extract the same area from all (specified) pages. Only specify |
columns |
An optional list, of length equal to the number of pages specified, where each entry contains a numeric vector of horizontal (x) coordinates separating columns of data for the corresponding page. As a convenience, a list of length 1 can be used to specify the same columns for all (specified) pages. Only specify |
guess |
A logical indicating whether to guess the locations of tables on each page. If |
spreadsheet |
A logical indicating whether to use Tabula's spreadsheet extraction algorithm. If |
method |
A function to coerce the Java response object (a Java ArrayList of Tabula Tables) to some output format. The default method, “matrices”, returns a list of character matrices. See Details for other options. |
password |
Optionally, a character string containing a user password to access a secured PDF. |
encoding |
Optionally, a character string specifying an encoding for the text, to be passed to the assignment method of |
... |
These are additional arguments passed to the internal functions dispatched by |
This function mimics the behavior of the Tabula command line utility. It returns a list of R character matrices containing tables extracted from a file by default. This response behavior can be changed by using the following options.
method = "character"
returns a list of single-element character vectors, where each vector is a tab-delimited, line-separate string of concatenated table cells.
method = "data.frame"
attempts to coerce the structure returned by method = "character"
into a list of data.frames and returns character strings where this fails.
method = "csv"
writes the tables to comma-separated (CSV) files using Tabula's CSVWriter method in the same directory as the original PDF. method = "tsv"
does the same but with tab-separated (TSV) files using Tabula's TSVWriter and method = "json"
does the same using Tabula's JSONWriter method. Any of these three methods return the path to the directory containing the extract table files.
method = "asis"
returns the Java object reference, which can be useful for debugging or for writing a custom parser.
extract_areas
implements this functionality in an interactive mode allowing the user to specify extraction areas for each page.
By default, a list of character matrices. This can be changed by specifying an alternative value of method
(see Details).
Thomas J. Leeper <thosjleeper@gmail.com>
extract_areas
, get_page_dims
, make_thumbnails
, split_pdf
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | ## Not run:
# simple demo file
f <- system.file("examples", "data.pdf", package = "tabulizer")
# extract all tables
extract_tables(f)
# extract tables from only second page
extract_tables(f, pages = 2)
# extract areas from a page
## full table
extract_tables(f, pages = 2, area = list(c(126, 149, 212, 462)))
## part of the table
extract_tables(f, pages = 2, area = list(c(126, 284, 174, 417)))
# return data.frames
extract_tables(f, pages = 2, method = "data.frame")
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.