469,908 Members | 2,219 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,908 developers. It's quick & easy.

Excel to string with quantity

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.

Nov 21 '05 #1
2 1014
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.

--
Terry Burns
http://TrainingOn.net

"nielsh" <ni****@hollandridderkerk.nl> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
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.

Nov 21 '05 #2
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

*** Sent via Developersdex http://www.developersdex.com ***
Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by v_verno | last post: by
13 posts views Thread by archuleta37 | last post: by
4 posts views Thread by DeanL | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.