Create a table that is 5 columns and 84 rows (assuming you want a header).
Copy from excel into the table. You can specify rows and columns of your
table.

Next comes orientation. From the table, select properties and I would chose
fancy table options, long table, and then orient the page as landscape.

Thanks,
~Ben

On Tue, Oct 30, 2018 at 1:37 PM Rich Shepard <rshep...@appl-ecosys.com>
wrote:

>    I have an 82-line text file which has 5 columns separated by pipes. '|',
> and a wide column with location names. Text file format examples:
>
>   10775    | Santiam R. at Jefferson Bridge
>   | 1979-11-06 | 2011-01-06 |    67
>   10386    | Middle Fork Willamette R. at asper Bridge
>    | 1979-11-06 | 2011-01-05 |    66
>   29043    | Willamette R. at Willamette Park boat ramp/Corvallis
>   | 2002-10-02 | 2011-01-06 |    60
>   26339    | Willamette R. upstream of Newberg Bridge at Rogers Landing
>   | 2002-10-01 | 2011-01-13 |    59
>   10344    | Willamette R. at Wheatland Ferry
>   | 1980-02-07 | 2011-01-10 |    58
>   29044    | Willamette R. at Greenway bike bridge/Eugene
>   | 2002-10-02 | 2011-01-04 |    52
>   10379    | Coast Fork Willamette R. at Hwy 58
>   | 1979-11-06 | 2011-01-05 |    50
>   10821    | Willamette R. at St. Johns Bridge
>    | 2004-08-04 | 2011-01-11 |    48
>   10355    | Willamette R. at Hwy 99E (Harrisburg)
>    | 1980-02-06 | 2011-01-04 |    46
>   31731    | Willamette R. at Wallace Marine Park boat ramp
>   | 2005-05-31 | 2011-01-10 |    44
>   27986    | Middle Fork Willamette R above Hills Crk at USGS Gage
> 14144800  | 2002-10-03 | 2011-01-05 |    44
>
> (N.B. Line length is 110 characters so it likely will be wrapped at
> different lengths, depending on which MUA you use.)
>
>    In LyX this will be a long table in landscape orientation among pages in
> portrait orientation.
>
>    What is the most efficient procedure to import this to a 5-column,
> 83-row
> table? And, can I define the table size without dragging the table icon off
> the bottom of the monitor?
>
> TIA,
>
> Rich
>

Reply via email to