Import from Excel to QVW specific range

[Black_Hole]

Hello all,

I try to import a table from Excel to QVW but I don't want to export all the first sheet.

Indeed, I would like to know how I can specify the range of my table which is defined by four columns (from I7 to L7). 

Below my current script:

TAB_PRODUCT:
LOAD * FROM
[C:\Users\Desktop\Product.xlsm]
(ooxml, embedded labels, table is Sheet1);

Thank you in advance for your help.

[mrtinsjoao]

Great Day,

Change de * for Column names

TAB_PRODUCT:
LOAD

[I],

[J],

[K],

[L]

FROM
[C:\Users\Desktop\Product.xlsm]
(ooxml, embedded labels, table is Sheet1);

[m_woolf]

If you use the File Wizard, it is easy to select which columns should load:

[Black_Hole]

Hello @mrtinsjoao , @m_woolf ,

Thank you very for your replies.

@mrtinsjoao : I try it, but I receive an error message saying:

"System error: Filesystem::FindEx non existing dir: Incorrect function: "I,J,K,L

Please could you help me to understand why I have this error.

@m_woolf : Yes, thank you. In my case, I prefer to have a script to import data. That's why I don't use the file Wizard.

Thank you in advance for your help.

[Black_Hole]

Re @mrtinsjoao ,

I'm not sure, but maybe I need to specify the start row next to the column label ([I], [J],[K],[L]).

Because my table begins at the 7th row (the header of my table has for range I7:L7).

If it's the reason of the previous error message. Please could you tell me how I can specify the start row of my table.

Thank you for your help.

[m_woolf]

The File Wizard generates script.

[Black_Hole]

Re @m_woolf ,

That's true, I forgot about that. Thank you for this reminder.

So, I try to export using the Wizar File. But I don't see where I can specify the range of my table and in particular to precise that the header of my table is from I7 to L7.

Please could you help me.

Thank you in advance for your support.

[m_woolf · Accepted solution]

1) Use the Tables dropdown to select the desired sheet.
2) Click the Header dropdown, select lines, and choose the number of lines.
3) Click the Labels dropdown and choose Embedded Labels (if your data has labels.
4) Click to delete any columns you don't want to load. You can always deleted these from the load script after it is generated.

Read the section of the manual dedicated to the File Wizard for detailed information.

[mrtinsjoao]

The Correct Answer
TAB_PRODUCT:
LOAD

[@9],

[@10],

[@11],

[@12]

FROM
[C:\Users\Desktop\Product.xlsm]
(ooxml, embedded labels, table is Sheet1, header is 7 lines);

[Black_Hole]

Re @m_woolf , @mrtinsjoao,

Thank both of you for your help.

I tried the two solutions and it worked successfully.

@m_woolf : Thank you to have detailed step by step the import from Excel. Your solution is a good alternative for the newbie with QVW (like me ^^).