LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Pasting webpage into spreadsheet (https://www.linuxquestions.org/questions/linux-newbie-8/pasting-webpage-into-spreadsheet-30930/)

flaw 09-21-2002 10:52 PM

Pasting webpage into spreadsheet
 
Running windows, I can call up a webpage with data on it in essentially rows and columns format, copy that data directly off the page using edit,copy, and paste the data into excel. Once pasted, the data shows up in the same rows and columns format within excel (with some minor errors that are easy to fix).

I tried to do this same thing in Linux with Galeon & Konqueror and Gnumeric, KSpread, & StarOffice Calc.

Under Galeon, both Gnumeric and KSpread paste the page all in one cell.

With Konqueror, KSpread pastes the page in one cell. Gnumeric tries to read it as delimited data but it can't see anything delimiting the columns, so it pastes it all into one column.

StarOffice Calc just says it can't past the clipboard contents with both browsers.

Any advice? I am trying to migrate something I do completely to Linux and this is a bit of a sticking point.

Thanks for your help.

DavidPhillips 09-21-2002 11:00 PM

Some versions of excel work in linux, you could probably do it like that

or there are various ways to format text in linux that could achieve the same thing that may be easier than copying and pasting, once it's setup.

flaw 09-22-2002 06:28 PM

Thanks for the excel tip, I'll look around some.

As for the other tip, for example . . . .?

DavidPhillips 09-22-2002 07:25 PM

well it depends on what you are doing, but there are several text formating tools and programing languages in linux, probably already installed on your machine.

Like I said "once it's setup"

which may require some scripting work, but if it's a table then it should fit in a database, and databases are the most powerful tool available for any type of data munipulation

you probably have mysql or postgres already installed, likely both.

So you could make a database and create tables in it and store data that way.

Of course this is not what you were asking so I'm sure you have a good reason for using a spreadsheet program.

The new office products want windows installer to run, but I think office 95 works ok in wine, however if you use a lot of macros I am not sure that visual basic will run.


All times are GMT -5. The time now is 02:23 PM.