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

[settu_periasamy]

Did you check my edited comment.. (Above)

[upaliwije]

Yes I did all you suggested. I attach h/w my sample data and pls have a look and advise me

[settu_periasamy · Accepted solution]

As i already told.. you should give '$' in the table name like..

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

[sunny_talwar]

Yup either that or this:

FOR EACH vsheet IN 'MV$','CI$','FF$'

CrossTable(MONTH, AMOUNT, 3)

LOAD BCOD,

    [Description of Item],

    TYPE,

    Jan,

    Feb,

    Mar,

    Apr,

    May,

    Jun,

    Jul,

    Aug,

    Sep,

    Oct,

    Nov,

    Dec

FROM

test.xls

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

NEXT