2

I have a Microsoft Excel file which gets generated from various database servers on the fly by executing SQL. A separate sheet gets generated for each server. I want to combine data of all sheets.

Each sheet has same number of columns and headings. In combined sheet heading should appear at top only once. For example:

North sheet

Sales Person Item Quantity Sales
James Ball 100 2000
Jack Bat 50 100
James Bat 25 50

South sheet

Sales Person Item Quantity Sales
Sara Racket 100 2000
Lucy Ball 50 100
Sara Racket 25 50

Combined sheet

Sales Person Item Quantity Sales
James Ball 100 2000
Jack Bat 50 100
James Bat 25 50
Sara Racket 100 2000
Lucy Ball 50 100
Sara Racket 25 50

How can I accomplish this in OpenOffice Calc?

Robotnik
  • 2,645
Prajakta
  • 21
  • 1
  • 2

1 Answers1

1

The How can I merge hundreds of Excel spreadsheet files? post describes how you can do this in Excel. You can probably use this in Calc as well.

Community
  • 1
lenin kumar
  • 11