Read data from separate CSV file in OpenOffice Calc

Posted by Thomi on Super User See other posts from Super User or by Thomi
Published on 2010-02-24T09:49:21Z Indexed on 2010/04/19 9:03 UTC
Read the original article Hit count: 355

Filed under:

openoffice.org

|

spreadsheet

|

csv

|

database

Hi,

I have a very large CSV file (many thousands of rows) that I want to work with. Due to the size of the file, I don't want to import it into openoffice. Rather, I want to create a spreadsheet that contains formulas & graphs that read from this (or any other) CSV file I point it it.

Ideally the spreadsheet will ask me what CSV file I want to use, allowing me to change the data source dynamically.

Any ideas?

© Super User or respective owner

Related posts about openoffice.org

apt-get is broken

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I Cannot install any package in the server, As I am newbie in Server. In Morning I found that some, I am not able to install any package from command line in the server,Now every package is now manually downloaded packages and then installed in the server. Can any one Please tell me what is the issue… >>> More
Install OpenOffice for headless use

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The question very simple and short. I am following this article to install OpenOffice headless: sudo apt-get install openoffice.org-headless openoffice.org-writer openoffice.org-draw And I get the following error : Reading package lists... Done Building dependency tree Reading state information… >>> More
Install OOo for headless use

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The question very simple and short. I am following this article to install OpenOfficle headless: sudo apt-get install openoffice.org-headless openoffice.org-writer openoffice.org-draw And I get the following error : Reading package lists... Done Building dependency tree Reading state information… >>> More
How to recover dpkg from corrupted downloads?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I just upgraded to the 10.10 RC earlier and had a few problems with graphic drivers (x didnt start) But i have remedied that now. When i run 'sudo apt-get install -f' i get this: will@UbuntuBox:/mnt/slax$ sudo apt-get install -f [sudo] password for will: Reading package lists... Done Building dependency… >>> More
Programmatically convert *.odt file to MS Word *.doc file using an OpenOffice.org basic macro

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to build a reStructuredText to MS Word document tool-chain, so I will be able to save only the rst sources in version control. So far I -- Have rst2odt.py to convert reStructuredText to OpenOffice.org Writer format. Next I want to use the most recent OpenOffice.org (currently 3.1) that… >>> More

Related posts about spreadsheet

Error while reading from spreadsheet in Ruby

as seen on Stack Overflow - Search for 'Stack Overflow'
I am getting following error while reading from a spreadsheet file. I have searched alot on Google. I have seen posts with similar problems but no reply to the problems. Does anyone know how to resolve this error? C:/Ruby/lib/ruby/gems/1.8/gems/ruby-ole-1.2.8.2/lib/ole/storage/file_system.rb:125:in… >>> More
Copy and paste the data one Excel spreadsheet to another spreadsheet based on column name

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to copy and paste the data from one Excel spreadsheet to another based on column name. For example, one shreadsheet has columns named like Asset, Asset owner. Another spreadsheet has column named like Application, Application Owner. Now I want "Asset" column data to copy and paste into the… >>> More
search & replace on 3000 row, 25 column spreadsheet

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm attempting to clean up data in this (old) spreadsheet and need to remove things like single and double quotes, HTML tags and so on. Trouble is, it's a 3000 row file with 25 columns and every spreadsheet app I've tried (NeoOffice, MS Excel, Apple Numbers) chokes on it. Hard. Any ideas on how else… >>> More
Translate report data export from RUEI into HTML for import into OpenOffice Calc Spreadsheets

as seen on Oracle Blogs - Search for 'Oracle Blogs'
A common question of users is, How to import the data from the automated data export of Real User Experience Insight (RUEI) into tools for archiving, dashboarding or combination with other sets of data.XML is well-suited for such a translation via the companion Extensible Stylesheet Language Transformations… >>> More
What is spreadsheet useful for?

as seen on Programmers - Search for 'Programmers'
I have been in computer business for 15 years in various roles (sysadmin, developer, researcher), and I have never encountered someone using excel for something more advanced than for formatting tables, or as an ad-hoc database that could have been maintained in a text-file. I had to do heavy data-processing… >>> More