Click here to Skip to main content
15,886,362 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# Desktop Apps Pin
Pete O'Hanlon10-Aug-09 1:35
mvePete O'Hanlon10-Aug-09 1:35 
GeneralRe: C# Desktop Apps Pin
Marc Firth10-Aug-09 1:39
Marc Firth10-Aug-09 1:39 
GeneralRe: C# Desktop Apps Pin
harold aptroot10-Aug-09 2:02
harold aptroot10-Aug-09 2:02 
GeneralRe: C# Desktop Apps Pin
Marc Firth10-Aug-09 1:42
Marc Firth10-Aug-09 1:42 
GeneralRe: C# Desktop Apps Pin
Pete O'Hanlon10-Aug-09 1:57
mvePete O'Hanlon10-Aug-09 1:57 
GeneralRe: C# Desktop Apps Pin
Marc Firth10-Aug-09 2:08
Marc Firth10-Aug-09 2:08 
GeneralRe: C# Desktop Apps Pin
Marc Firth14-Aug-09 0:23
Marc Firth14-Aug-09 0:23 
QuestionExcel Cells are not readable if hidden Pin
Harry6669-Aug-09 22:22
Harry6669-Aug-09 22:22 
Hello all you C# and Excel programming people,

some days ago I discovered something that I have to tell...
I wrote a programm writing/reading to and from an MSSQL-db to and from Excel-sheets.
In one of my Excel-sheets I have to read the column "A" in order to get the right row to insert some values.
inside a ...
for(int row=0;...){ // I do like...
Excel.Range range = (Excel.Range)mySheet.Cells[row, "A"];
string val = range.Text.ToString();
...
}

The problem is: when one of the rows is hidden I do not get the row and for that reason I don't get a value.
When the whole column "A" is just not as wide as it has to be you can only see "####" and this is exactly what I get, what my string val looks like.
So the data in the Excel sheet is some number, but what I get is only what I see.

IF someone knows how to get rid of such a problem, I'd like to know.
Else I just wanted to mention.

Greets
Harry

no plan,
no signature

AnswerRe: Excel Cells are not readable if hidden Pin
Luc Pattyn9-Aug-09 22:49
sitebuilderLuc Pattyn9-Aug-09 22:49 
GeneralRe: Excel Cells are not readable if hidden Pin
Harry66610-Aug-09 4:48
Harry66610-Aug-09 4:48 
AnswerRe: Excel Cells are not readable if hidden Pin
Moreno Airoldi10-Aug-09 0:53
Moreno Airoldi10-Aug-09 0:53 
GeneralRe: Excel Cells are not readable if hidden Pin
Harry66610-Aug-09 5:34
Harry66610-Aug-09 5:34 
GeneralRe: Excel Cells are not readable if hidden Pin
Moreno Airoldi10-Aug-09 7:05
Moreno Airoldi10-Aug-09 7:05 
GeneralRe: Excel Cells are not readable if hidden Pin
Harry66610-Aug-09 22:53
Harry66610-Aug-09 22:53 
GeneralRe: Excel Cells are not readable if hidden Pin
Moreno Airoldi10-Aug-09 23:06
Moreno Airoldi10-Aug-09 23:06 
QuestionControl Listner Pin
satsumatable9-Aug-09 20:39
satsumatable9-Aug-09 20:39 
AnswerRe: Control Listner Pin
Pete O'Hanlon10-Aug-09 1:42
mvePete O'Hanlon10-Aug-09 1:42 
QuestionLogic I use.......?? Pin
Hum Dum9-Aug-09 20:35
Hum Dum9-Aug-09 20:35 
AnswerRe: Logic I use.......?? Pin
PIEBALDconsult9-Aug-09 20:42
mvePIEBALDconsult9-Aug-09 20:42 
GeneralRe: Logic I use.......?? Pin
Hum Dum9-Aug-09 21:01
Hum Dum9-Aug-09 21:01 
GeneralRe: Logic I use.......?? Pin
PIEBALDconsult9-Aug-09 21:19
mvePIEBALDconsult9-Aug-09 21:19 
GeneralRe: Logic I use.......?? Pin
Hum Dum9-Aug-09 21:59
Hum Dum9-Aug-09 21:59 
GeneralRe: Logic I use.......?? Pin
Pete O'Hanlon9-Aug-09 22:24
mvePete O'Hanlon9-Aug-09 22:24 
GeneralRe: Logic I use.......?? Pin
PIEBALDconsult10-Aug-09 5:59
mvePIEBALDconsult10-Aug-09 5:59 
GeneralRe: Logic I use.......?? Pin
Hum Dum11-Aug-09 20:35
Hum Dum11-Aug-09 20:35 

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.