Reload Cross Table from Excel

[christian77]

Hi people:

I need to reload a cross table from Excel. Since in the report to make, expressions are in columns and rows, my intention is having expressions loaded as fields and work with that.

My problem: I can´t load the table crossed as QV provides cause I don´t know how to use it properly.

Can somebody help me? Here is it. Script screen, plane files... In the middle of the process appears 'cross table'.

Thanks in advance.

[kuba_michalik]

It's hard to say about what you should do without knowing the data you are trying to load. Could you perhaps tell us what columns are there in the Excel file?

[christian77]

Hi again:

Expresiones:

CrossTable([MES ACTUAL], Datos) // The field MES ACTUAL was not quoted or between brackeets

LOAD [PARAMETROS ESTADISTICOS],

[MES ACTUAL],

[MES AÑO ANTERIOR],

[DESVIACION %],

[ACUMULADO AÑO ACTUAL],

[ACUMULADO AÑO ANTERIOR],

[DESVIACION %1],

INTERANUAL,

OBJETIVO

FROM

[Expresiones.xls]

(biff, embedded labels, header is 2 lines, table is Enero$, filters(

Remove(Row, Pos(Top, 2))

));