Hi,
Is there any way that we can read one Excel sheet with multiple pages.
Reading an Excel Sheet with multiple pages
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Subject to two very specific conditions, yes.
The first condition is that you have an ODBC driver for Excel. If not, stop reading now - you will need to export each sheet as a separate CSV (or TXT) file, FTP them to your UNIX server, and process each file separately.
The second condition is that the worksheets are well-formed for ODBC. That is, they are purely in tabular format with column headings. If this condition is met, then you should be able to import the "table definitions". You must check the "system tables" check box; Excel's ODBC driver reports each worksheet as a system table.
If both conditions are met, then you can access each worksheet as a separate ODBC table.
Should you want to process the totality of data, you can join the CSV files together (for example using the cat command), or you can form the UNION of the tables (worksheets) via the ODBC stage - provided the data on every worksheet are sufficiently compatible.
The first condition is that you have an ODBC driver for Excel. If not, stop reading now - you will need to export each sheet as a separate CSV (or TXT) file, FTP them to your UNIX server, and process each file separately.
The second condition is that the worksheets are well-formed for ODBC. That is, they are purely in tabular format with column headings. If this condition is met, then you should be able to import the "table definitions". You must check the "system tables" check box; Excel's ODBC driver reports each worksheet as a system table.
If both conditions are met, then you can access each worksheet as a separate ODBC table.
Should you want to process the totality of data, you can join the CSV files together (for example using the cat command), or you can form the UNION of the tables (worksheets) via the ODBC stage - provided the data on every worksheet are sufficiently compatible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ray,
Thanks a lot. It worked. It really worked as we wanted it to be. Thanks a lot again.
bapajju
Thanks a lot. It worked. It really worked as we wanted it to be. Thanks a lot again.
bapajju
ray.wurlod wrote:Subject to two very specific conditions, yes.
The first condition is that you have an ODBC driver for Excel. If not, stop reading now - you will need to export each sheet as a separate CSV (or TXT) file, FTP them to your UNIX server, and process each file separately.
The second condition is that the worksheets are well-formed for ODBC. That is, they are purely in tabular format with column headings. If this condition is met, then you should be able to import the "table definitions". You must check the "system tables" check box; Excel's ODBC driver reports each worksheet as a system table.
If both conditions are met, then you can access each worksheet as a separate ODBC table.
Should you want to process the totality of data, you can join the CSV files together (for example using the cat command), or you can form the UNION of the tables (worksheets) via the ODBC stage - provided the data on every worksheet are sufficiently compatible.