Import File .xls: more sheets

[fmazzarelli]

hi,

a xls file is composed of more sheets.

Could I append data  into a single table?

[#2]

Hi Fabio,

Yes you can

FOR EACH vTab IN GENERO, FEBRERO, MARZO  ....

T:

load * from table (...... , $(vTab));

NEXT

best regards

Chris

[fmazzarelli]

HI

could you suggest me the correct form?

FOR EACH vTab IN GENNAIO, FEBBRAIO, MARZO, APRILE, MAGGIO GIUGNO, LUGLIO

CrossTable(Prodotto, Quantità, 4)

LOAD *

FROM

(ooxml, embedded labels, table is GENNAIO, filters(

Remove(Row, Pos(Top, 2)),

Remove(Row, Pos(Top, 531)),

Remove(Row, Pos(Top, 530)),

Remove(Row, Pos(Top, 529)),

Remove(Row, Pos(Top, 528)),

Remove(Row, Pos(Top, 527)),

Remove(Row, Pos(Top, 525)),

Remove(Row, Pos(Top, 523)),

Remove(Row, Pos(Top, 522)),

Remove(Row, Pos(Top, 523)),

Remove(Row, Pos(Top, 522)),

),  $(vTab));

NEXT

[#4]

i would suggest you load first raw data in one tmp table and then do your transformation into a final table

Chris

[fmazzarelli]

hi,

could I have an example?

[#6 · Accepted solution]

here is a FOR EACH example

FOR EACH vSheet IN 'GENNAIO', 'FEBBRAIO', 'MARZO', 'APRILE', 'MAGGIO', 'GIUGNO', 'LUGLIO'

Table:

LOAD

....

FROM [<FileName>]    (ooxml, embedded labels, table is [$(vSheet)])

;

NEXT

Chris

[fmazzarelli]

Houston Houston we have a problem...

Sheets have the same name of column.

------------------------------------

gennaio

column: Name

------------------------------------

febbraio

column: Name

------------------------------------

marzo

column: Name

------------------------------------

using crosstable I must have unambiguous name.

Any suggest?

[#8]

hi Fabio,

Give to the table the name of $(vSheet):

use "noconcatenate"

and at the end of the 1st FOR EACH...NEXT,  do a second to concatenate all table into a single one

enjoy it

Chris