Re: Bulk loading of data into a table
On Fri, 24 Aug 2018, Paul A. Rubin wrote: Seems to me that, in the past, I have created an empty table of the proper size in LyX, copied the contents of a table from a spreadsheet, and then just put the cursor in the top left table cell in LyX and pasted. Paul, The LyX wiki explains that a table can be linked to a spreadsheet and reflect spreadsheet changes (which I think was the case with some of the DOS office suites in the 1980s), which does not help when the data are in a text file. Riki's solution works as a two-step process. Using Insert -> Table specifying a 2-column x 20-row text file opened a new LyX tab with the data. At first I did not see the faint remnants of the table's turned off borders and thought it was a matrix without format. When I noticed that the new tab was actually a table I copied it to the tab with the target document, added appropriate horizontal headers, and closed the input tab. Works great. A new LyX capability made known to me. Regards, Rich
Re: Bulk loading of data into a table
On 08/21/2018 04:32 PM, Rich Shepard wrote: The wiki has a process for linking a table to a spreadsheet but I found no hints on how to load bulk data into a table. Now I have quartile summaries for each of 19 years of data. That's a table with 19 rows and 7 columns. I'll have more data like this to insert into tables and would welcome any hints on how to format the data so it can be inserted in one fell swoop. TIA, Rich Rich, Seems to me that, in the past, I have created an empty table of the proper size in LyX, copied the contents of a table from a spreadsheet, and then just put the cursor in the top left table cell in LyX and pasted. Paul
Re: Bulk loading of data into a table
On Wed, 22 Aug 2018, Rich Shepard wrote: Er, yes. It does import the data into a new tab (file), not into a table in an existing document. Darn! Wrote too soon. The data are imported as a table. By selecting the entire table it can be copied to the proper document. Thanks, Riki, Rich
Re: Bulk loading of data into a table
On Tue, 21 Aug 2018, Richard Kimberly Heck wrote: It is possible to import CSV data, at File> Import> CSV. Riki, Er, yes. It does import the data into a new tab (file), not into a table in an existing document. Darn! Rich
Re: Bulk loading of data into a table [RESOLVED]
On Tue, 21 Aug 2018, Richard Kimberly Heck wrote: It is possible to import CSV data, at File> Import> CSV. Riki, Thank you. I should have explored the menus and would have found that. Regards, Rich
Re: Bulk loading of data into a table
On 08/21/2018 04:32 PM, Rich Shepard wrote: > The wiki has a process for linking a table to a spreadsheet but I > found no > hints on how to load bulk data into a table. Now I have quartile > summaries > for each of 19 years of data. That's a table with 19 rows and 7 columns. > > I'll have more data like this to insert into tables and would > welcome any > hints on how to format the data so it can be inserted in one fell swoop. It is possible to import CSV data, at File> Import> CSV. Riki
Bulk loading of data into a table
The wiki has a process for linking a table to a spreadsheet but I found no hints on how to load bulk data into a table. Now I have quartile summaries for each of 19 years of data. That's a table with 19 rows and 7 columns. I'll have more data like this to insert into tables and would welcome any hints on how to format the data so it can be inserted in one fell swoop. TIA, Rich