Excel to string with quantity

[nielsh]

Hello, I have a Excel document with multiple colums.
I want to use te data from 2 colums (filename & quantity).
First i want to know the quantity, because when the quantity is '3' i
want to make a string value with three times the same filename from the
same row.

### Examle, a row with the values for the colum filename: 'MyFile.XXX'
and the colum quantity: '3'
The string that i need to get for that row is:
'MyFile.XXX MyFile.XXX MyFile.XXX'

If someone knows a better/more easy way if i convert the Excel source
into a other format, please tell me, it is possible for me to convert
the Excel file.

I hope someone can help me.

 

[Terry Burns]

You know what, I'm not being funny but your post makes no sense to me
whatsoever. Firstly this is a VB.NET Group, not an exel or VBA group.
Secondly, your description is so abstract and incomplete, I really don't
know what you are trying to achieve. Try reformatting your question so we
can understand it, then you might get a coherent response.

 

[Niels Hubregtse]

I am sorry that i made no sense...

I want to make an application in VB.net that gets his information out of
an Excel file (or an other file format if that would be better).
The information is then converted into a string for use in a commandline
(prompt).

The 2 culoms i mentioned before ('Filename' & 'Quantity') have the
information i need for creating the string.

the value 'Quantity' is a Integer and it only say how many times the
value "Filename" will repeat in the string.

### Examle,
When 'Filename' has the value 'MyFile.XXX'
and 'Quantity' has the value '3'.
Then the string that i need to get for that row is:
'MyFile.XXX MyFile.XXX MyFile.XXX'

I hope i am more clear now for what my intensions are.....

Either way thaks for you answer