EXCEL SHEETS

[upaliwije]

hI

I have in my  excel work book  several sheets to be loaded to QV documents and with following script it is loaded correctly

FOR EACH vsheet IN 'MV','CI','FF','OE','PM'

CrossTable(MONTH, AMOUNT, 5)

LOAD BCOD,

     CC,

     ITEM AS O_ITEM,

     [Description of Item] AS ITEM,

     TYPE,

    Jan,

     Feb,

     Mar

   FROM

[ALL CAPITAL.xlsx]

(ooxml, embedded labels, table is  $(vsheet));

NEXT

This workbook is from office 2007 (xlsx) but when I try do the same thing with office 2003 (xls) it is giving error message. IS it not possible to this with excel with extension .xls  pls hlep

[sunny_talwar]

May be this change might help:

From

(ooxml, embedded labels, table is  $(vsheet));

to

(biff, embedded labels, table is $(vsheet));

[settu_periasamy]

ooxml - for xlsx files.

biff - for xls files

Load

...

FROM

[Source..xls]

(biff, no labels, table is Sheet1$);

[settu_periasamy]

Informative discussion..

biff Vs. ooxml

[upaliwije]

Thanks

I tried that then I get this message

Cannot locate table in BIFF file

LOAD BCOD,

     [Branch Name],

     CC,

     ITEM,

     [Description of Item],

     TYPE,

     Value,

     Jan,

     Feb,

     Mar,

FROM

[ALL CAPITAL.xls]

(biff, embedded labels, table is MV)

[settu_periasamy]

Hi,

Just to make sure, Do you have the fields after 'Mar' or is just sample?

remove the comma before FROM field and end of the script with semicolon..

Load

...

Mar

FROM

[ALL CAPITAL.xls]

(biff, embedded labels, table is MV$);

Edit

forgot to mention. should use '$'  Like

table is MV$

[tamilarasu]

Hi Upali,

        Did you rename the file from xlsx to xls directly.? If so, open your original xlsx file and use save as optition to store it as .xls (Excel 97-2003).

[upaliwije]

YES

[tamilarasu]

See my above comment and try again. If you rename the file manually, you will get this error. After you save the file as I said, try the script again. Also don't forget to change it as biff.

[upaliwije]

Sorry . This is only a sample