Click here to Skip to main content
15,895,084 members
Home / Discussions / C#
   

C#

 
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 
QuestionChanging the default WindowClassName of a .NET Form? Pin
Yuval Naveh10-Oct-06 22:12
Yuval Naveh10-Oct-06 22:12 
AnswerRe: Changing the default WindowClassName of a .NET Form? Pin
Chris Buckett10-Oct-06 23:23
Chris Buckett10-Oct-06 23:23 
GeneralRe: Changing the default WindowClassName of a .NET Form? Pin
Yuval Naveh10-Oct-06 23:32
Yuval Naveh10-Oct-06 23:32 
QuestionRemoting and dynamic port allocation Pin
SkyTom10-Oct-06 22:04
SkyTom10-Oct-06 22:04 
QuestionDeployment Question Pin
wasife10-Oct-06 21:34
wasife10-Oct-06 21:34 
QuestionSize of COM objects Pin
drabiger10-Oct-06 21:33
drabiger10-Oct-06 21:33 
QuestionAdding custom property pages to Outlook 2003 using C# <-- Question Pin
SquallNaruto10-Oct-06 21:15
SquallNaruto10-Oct-06 21:15 
QuestionAssign shortcutkeys to combobox values in gridview Pin
WillemM10-Oct-06 21:04
WillemM10-Oct-06 21:04 
Questionhow to declare 2 dimensional arraylists in C# Pin
Keshav V. Kamat10-Oct-06 21:04
Keshav V. Kamat10-Oct-06 21:04 
AnswerRe: how to declare 2 dimensional arraylists in C# Pin
WillemM10-Oct-06 21:09
WillemM10-Oct-06 21:09 
GeneralRe: how to declare 2 dimensional arraylists in C# Pin
Keshav V. Kamat10-Oct-06 21:11
Keshav V. Kamat10-Oct-06 21:11 
AnswerRe: how to declare 2 dimensional arraylists in C# Pin
wheelerbarry10-Oct-06 22:39
wheelerbarry10-Oct-06 22:39 
AnswerRe: how to declare 2 dimensional arraylists in C# Pin
WillemM10-Oct-06 21:06
WillemM10-Oct-06 21:06 
GeneralRe: how to declare 2 dimensional arraylists in C# Pin
Keshav V. Kamat10-Oct-06 21:08
Keshav V. Kamat10-Oct-06 21:08 

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.