Click here to Skip to main content
15,905,874 members
Home / Discussions / C#
   

C#

 
AnswerRe: Reading from Serial Port to a struct Pin
led mike11-Oct-06 6:12
led mike11-Oct-06 6:12 
GeneralRe: Reading from Serial Port to a struct Pin
NYTSX11-Oct-06 8:41
NYTSX11-Oct-06 8:41 
QuestionSending data Pin
The underdog11-Oct-06 2:43
The underdog11-Oct-06 2:43 
AnswerRe: Sending data Pin
User 665811-Oct-06 3:48
User 665811-Oct-06 3:48 
Questionascii 128-255 characters Pin
faladrim11-Oct-06 2:19
faladrim11-Oct-06 2:19 
AnswerRe: ascii 128-255 characters Pin
Bekjong11-Oct-06 4:55
Bekjong11-Oct-06 4:55 
QuestionMDI parent child interaction Pin
tim_gunning11-Oct-06 2:01
tim_gunning11-Oct-06 2:01 
AnswerRe: MDI parent child interaction Pin
mikone11-Oct-06 4:04
mikone11-Oct-06 4:04 
GeneralRe: MDI parent child interaction Pin
tim_gunning11-Oct-06 7:35
tim_gunning11-Oct-06 7:35 
GeneralRe: MDI parent child interaction Pin
mikone11-Oct-06 7:42
mikone11-Oct-06 7:42 
GeneralRe: MDI parent child interaction Pin
tim_gunning11-Oct-06 7:46
tim_gunning11-Oct-06 7:46 
QuestionNoob question regarding creating notepad Pin
Irfan Faruki11-Oct-06 1:56
Irfan Faruki11-Oct-06 1:56 
AnswerRe: Noob question regarding creating notepad Pin
Andrei Ungureanu11-Oct-06 3:02
Andrei Ungureanu11-Oct-06 3:02 
GeneralRe: Noob question regarding creating notepad Pin
Irfan Faruki11-Oct-06 4:47
Irfan Faruki11-Oct-06 4:47 
QuestionHow do I "embed" text into an image? Like what msn emoticon does Pin
dy1311-Oct-06 0:54
dy1311-Oct-06 0:54 
AnswerRe: How do I "embed" text into an image? Like what msn emoticon does Pin
eggsovereasy11-Oct-06 4:02
eggsovereasy11-Oct-06 4:02 
GeneralRe: How do I "embed" text into an image? Like what msn emoticon does Pin
dy1311-Oct-06 17:36
dy1311-Oct-06 17:36 
Questionpropertygrid validation of a field Pin
praveenqwe11-Oct-06 0:43
praveenqwe11-Oct-06 0:43 
AnswerRe: propertygrid validation of a field Pin
visualhint11-Oct-06 6:04
visualhint11-Oct-06 6:04 
Questionserial port Pin
dhanaid10-Oct-06 23:52
dhanaid10-Oct-06 23:52 
QuestionPopulate Table from excel sheet ? Pin
Gammaza10-Oct-06 23:15
Gammaza10-Oct-06 23:15 
AnswerRe: Populate Table from excel sheet ? Pin
mikone11-Oct-06 3:41
mikone11-Oct-06 3:41 
You're on the right way Wink | ;)

With this range you may fill a multidimensional array and put it into a table.
Just use the .get_Value() method of the range object to retrieve this array.

<br />
string [,] mydata = PrintQuoteRange.get_Value(System.Type.Missing);<br />


Now you have the whole Data in the array. A simple for loop will do the rest Wink | ;)
Tell me if you keep having trouble with getting the data into a table.

I had to do something similar just 2 weeks ago and found this article very useful:
How to automate Excel by using Visual C# to fill or to obtain data in a range by using arrays

ATTENTION: if you want to set a value of a cell to more than 911 characters, you will get a com exception. To work around this issue just use the querytable instead (have a look at the COM forumpost i made recently)

However, good luck with automating Excel Wink | ;)
(Let me know if you are not able to kill the excel process properly - i just found a nice article to get rid of this too Wink | ;) )
GeneralRe: Populate Table from excel sheet ? Pin
Gammaza11-Oct-06 20:43
Gammaza11-Oct-06 20:43 
Questionget clicked link Pin
m_mor10-Oct-06 23:00
m_mor10-Oct-06 23:00 
AnswerRe: get clicked link Pin
Niiiissssshhhhhuuuuu11-Oct-06 1:45
Niiiissssshhhhhuuuuu11-Oct-06 1:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.