I want to copy the numbers in a column from Excel to the datagrdiview column. It just copies the first number. What should I do to copy all numbers?
Loading
I want to copy the numbers in a column from Excel to the datagrdiview column. It just copies the first number. What should I do to copy all numbers?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Mehmet FatihPosted Mar 18, 2024, 12:58 PM
Thank you for your intrest Tuhin. I am choosing the entire column in Excel and copying the numbers in the colun. But when I paste to the datagrdiview, it is pasting only one number to the first row. When I use the right click, speacial paste doesn't appear.
Tuhin PaulPosted Mar 18, 2024, 10:43 AM
If the copied data contains separators like commas, you might need to adjust the parsing logic in your application (if applicable) to handle them during data import.
Tuhin PaulPosted Mar 18, 2024, 10:42 AM
Excel might be copying only the formatted cell value instead of the actual number. This can happen if you directly copy the cell or use a simple copy shortcut.
Solution
Ctrl+C.