LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 09-21-2002, 10:52 PM   #1
flaw
LQ Newbie
 
Registered: Jan 2002
Distribution: Mandrake 8.2
Posts: 7

Rep: Reputation: 0
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.
 
Old 09-21-2002, 11:00 PM   #2
DavidPhillips
Guru
 
Registered: Jun 2001
Location: South Alabama
Distribution: Fedora / RedHat / SuSE
Posts: 7,154

Rep: Reputation: 56
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.
 
Old 09-22-2002, 06:28 PM   #3
flaw
LQ Newbie
 
Registered: Jan 2002
Distribution: Mandrake 8.2
Posts: 7

Original Poster
Rep: Reputation: 0
Thanks for the excel tip, I'll look around some.

As for the other tip, for example . . . .?
 
Old 09-22-2002, 07:25 PM   #4
DavidPhillips
Guru
 
Registered: Jun 2001
Location: South Alabama
Distribution: Fedora / RedHat / SuSE
Posts: 7,154

Rep: Reputation: 56
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy pasting in emacs wogga Linux - Software 7 06-16-2004 03:12 PM
Spreadsheet iqbala Linux - Software 1 02-29-2004 12:25 PM
cutting and pasting lxandrthegr8 Linux - General 8 08-17-2003 02:04 PM
automatic code pasting verve Programming 3 10-07-2002 12:08 PM
GAIM - Pasting Sirrvs Linux - Software 2 09-08-2002 06:10 PM


All times are GMT -5. The time now is 11:51 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration