Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
As i already told.. you should give '$' in the table name like..
(biff, embedded labels, table is $(vsheet)$);
May be this change might help:
From
(ooxml, embedded labels, table is $(vsheet));
to
(biff, embedded labels, table is $(vsheet));
ooxml - for xlsx files.
biff - for xls files
Load
...
FROM
[Source..xls]
(biff, no labels, table is Sheet1$);
Informative discussion..
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)
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$
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).
YES
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.
Sorry . This is only a sample