Ubuntu
openoffice.org package

report generation from .xls table

Asked by Laxman

Hello to all,
 I have a table in spreadsheet. I need to generate a report from this table but not able to dot that. I tried Sun Report Builder but that does not appear in spread sheet. Also in openOffice.org Database .xls table is not opening. I don't find a way to link .xls table to openOffice.org Database so that report based on table can be generated. I want to have a database table that can be updated and that is reflected in report too. In MS ACCESS excel tables can be imported but here I am not able to this.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Tony Pursell
Solved:
Last query:
Last reply:
Revision history for this message
Best Tony Pursell (ajpursell) said : 		#1

Hi

You need to register your spreadsheet as a data base, this way

1. File > New > Database

2. In the Database Wizard, choose 'Connect to an existing database' and select Spreadsheet from the drop down list.

3. Click Next and Browse for you Spreadsheet file.

4. Click Next and Finish to Save the database. You can save the database with the same name as the spreadsheet, but it will be given a .odb extension.

That will allow you to access the spreadsheet in Report Builder as if it were a database, but you will still have to use the spreadsheet itself to edit the data.

Alternatively, you could create a new empty data base then copy and paste the spreadsheet table into it. It will take you through a series of steps to create a database table. Ask if you need help with this.

Hope this helps.

Tony

PS If this answers your question, please mark it as Solved.

Revision history for this message
Laxman (laxman6781) said : 		#2

Thanks Tony Pursell, that solved my question.