Reading an Excel (xlsx) file
Moderators: chulett, rschirm, roy
Ok, I gave up the idea of loading data from multiple sheets.
kashyap, the link you gave has the same steps as the ones in the "Guide to Extracting Unstructured Data". Anyway, I set up the job to load from a single sheet spreadsheet. I followed the steps given in the document. Job runs fine but does not load any data.
Just curious, has anyone been able to load data using the unstructured data stage from Excel?
kashyap, the link you gave has the same steps as the ones in the "Guide to Extracting Unstructured Data". Anyway, I set up the job to load from a single sheet spreadsheet. I followed the steps given in the document. Job runs fine but does not load any data.
Just curious, has anyone been able to load data using the unstructured data stage from Excel?
We have several jobs which read both single and multiple tab Excel spreadsheets using Unstructured data stage and load Oracle tables.
In our experience, design time error messages from Unstructured data stage are handled/meaningful, so I was surprised to see the raw messages from your system. Did you contact support for these issues?
In our experience, design time error messages from Unstructured data stage are handled/meaningful, so I was surprised to see the raw messages from your system. Did you contact support for these issues?
So far we have not encountered any NLS/Unicode character issue while importing from excel spreadsheets. Output tab of Unstructured data stage has following system generated values:
- SQL type: VarChar for all columns imported from "Excel Column" and most of the columns imported from "Property". Few columns imported from "Property" have value Integer (RowNumber, FileSize, RowIsHidden) and Date (LastModifiedDate, ContentCreationDate).
Extended: (not populated)
Length: (not populated)
Scale: (not populated)
Nullable: Yes for all columns imported from "Excel column" and most of the columns imported from "Property". No for some of the columns imported from "property" e.g. SheetName, LastModifiedDate, RowNumber, RowIsHidden, FileName etc).