Hi,
I've got a pb in using an Excel metadata.
I don't understand because :
- I can make the metadata
- I can use its data structure when I work on an extract of the sheet
- I can't use the metadata directly in job (the way I look for)
- I can't use the tInputExcel targeting these particular sheet.
I use Excel 2003, the document contains many sheet and I can work with another lighter. The sheet is auto-generated with macro, when I extract the sheet it makes 4.7Mo, and the metadata generation takes 2-3 minutes, maybe it's a buffer limitation?
As example, I take the excel metada and try to write in tlogrow.
Here, the error report :
Démarrage du job sgsd a 16:49 17/03/2010. connecting to socket on port 3942 connected Warning: Cannot read name ... Warning: Usage of a local non-builtin name .. Debug: format string is 0.0 Warning: Shared template formula is null - trying most recent formula template Warning: Shared template formula is null - trying most recent formula template Warning: Shared template formula is null - trying most recent formula template Warning: Shared template formula is null - trying most recent formula template Warning: Shared template formula is null - trying most recent formula template Warning: Shared template formula is null - trying most recent formula template Warning: Shared template formula is null - trying most recent formula template Warning: Shared template formula is null - trying most recent formula template Warning: Shared template formula is null - trying most recent formula template common.AssertionFailed at common.Assert.verify(Assert.java:37) at jxl.read.biff.WorkbookParser.getName(WorkbookParser.java:1117) at jxl.biff.formula.NameRange.read(NameRange.java:88) at jxl.biff.formula.TokenFormulaParser.parseSubExpression(TokenFormulaParser.java:214) at jxl.biff.formula.TokenFormulaParser.parse(TokenFormulaParser.java:111) at jxl.biff.formula.FormulaParser.parse(FormulaParser.java:110) at jxl.biff.DVParser.<init>(DVParser.java:428) at jxl.biff.DataValiditySettingsRecord.initialize(DataValiditySettingsRecord.java:140) at jxl.biff.DataValiditySettingsRecord.getFirstColumn(DataValiditySettingsRecord.java:234) at jxl.read.biff.SheetReader.read(SheetReader.java:994) at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:676) at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:252) at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:285) at recoupement_board_ess.sgsd_0_1.sgsd$1RegexUtil_tFileInputExcel_1.getSheets(sgsd.java:1032) at recoupement_board_ess.sgsd_0_1.sgsd.tFileInputExcel_1Process(sgsd.java:1082) at recoupement_board_ess.sgsd_0_1.sgsd.runJobInTOS(sgsd.java:1747) at recoupement_board_ess.sgsd_0_1.sgsd.main(sgsd.java:1623) Exception in component tFileInputExcel_1 common.AssertionFailed at common.Assert.verify(Assert.java:37) at jxl.read.biff.WorkbookParser.getName(WorkbookParser.java:1117) at jxl.biff.formula.NameRange.read(NameRange.java:88) at jxl.biff.formula.TokenFormulaParser.parseSubExpression(TokenFormulaParser.java:214) at jxl.biff.formula.TokenFormulaParser.parse(TokenFormulaParser.java:111) at jxl.biff.formula.FormulaParser.parse(FormulaParser.java:110) at jxl.biff.DVParser.<init>(DVParser.java:428) at jxl.biff.DataValiditySettingsRecord.initialize(DataValiditySettingsRecord.java:140) at jxl.biff.DataValiditySettingsRecord.getFirstColumn(DataValiditySettingsRecord.java:234) at jxl.read.biff.SheetReader.read(SheetReader.java:994) at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:676) at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:252) at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:285) at recoupement_board_ess.sgsd_0_1.sgsd$1RegexUtil_tFileInputExcel_1.getSheets(sgsd.java:1032) at recoupement_board_ess.sgsd_0_1.sgsd.tFileInputExcel_1Process(sgsd.java:1082) at recoupement_board_ess.sgsd_0_1.sgsd.runJobInTOS(sgsd.java:1747) at recoupement_board_ess.sgsd_0_1.sgsd.main(sgsd.java:1623) disconnected
I've got the 1st warning on another usage of Excel metadata and I see it's linked with Excel but the other warnings are particular with this job.
I'm french, so I use ISO-8859-1 because of the data but my columns don't use typical characters.
Best regard.
Hi everybody! I try to extract some information from an excel file but i have this message : connecting to socket on port 3596 connected Debug: format string is 0.0% disconnected Job testAccess terminé à 14:58 06/08/2010. can any one help me please?
