Click here to Skip to main content
15,888,351 members
Home / Discussions / C#
   

C#

 
QuestionAfter create setup Window form Application Following Error:- Pin
Nishant.Chauhan8029-Aug-14 2:17
Nishant.Chauhan8029-Aug-14 2:17 
AnswerRe: After create setup Window form Application Following Error:- Pin
Dave Kreskowiak29-Aug-14 2:32
mveDave Kreskowiak29-Aug-14 2:32 
AnswerRe: After create setup Window form Application Following Error:- Pin
Richard MacCutchan29-Aug-14 2:35
mveRichard MacCutchan29-Aug-14 2:35 
Questionhow to dropdownlist foreign keys? Pin
Member 1102146428-Aug-14 23:20
Member 1102146428-Aug-14 23:20 
AnswerRe: how to dropdownlist foreign keys? Pin
Pete O'Hanlon28-Aug-14 23:35
mvePete O'Hanlon28-Aug-14 23:35 
QuestionJSON Parsing Data Pin
Alex.bordei28-Aug-14 22:15
Alex.bordei28-Aug-14 22:15 
AnswerRe: JSON Parsing Data Pin
Freak3028-Aug-14 23:00
Freak3028-Aug-14 23:00 
GeneralRe: JSON Parsing Data Pin
Alex.bordei29-Aug-14 2:43
Alex.bordei29-Aug-14 2:43 
QuestionC# connection between two SQLExpress servers on one machine Pin
Member 1103943928-Aug-14 18:44
Member 1103943928-Aug-14 18:44 
AnswerRe: C# connection between two SQLExpress servers on one machine Pin
Kornfeld Eliyahu Peter28-Aug-14 20:16
professionalKornfeld Eliyahu Peter28-Aug-14 20:16 
GeneralRe: C# connection between two SQLExpress servers on one machine Pin
Member 1103943928-Aug-14 20:28
Member 1103943928-Aug-14 20:28 
GeneralRe: C# connection between two SQLExpress servers on one machine Pin
Paul Conrad29-Aug-14 18:47
professionalPaul Conrad29-Aug-14 18:47 
AnswerRe: C# connection between two SQLExpress servers on one machine Pin
PIEBALDconsult2-Sep-14 8:24
mvePIEBALDconsult2-Sep-14 8:24 
QuestionUsing Process.Start on Excel Pin
mjackson1128-Aug-14 8:35
mjackson1128-Aug-14 8:35 
AnswerRe: Using Process.Start on Excel Pin
Richard Deeming28-Aug-14 9:59
mveRichard Deeming28-Aug-14 9:59 
GeneralRe: Using Process.Start on Excel Pin
mjackson1128-Aug-14 10:15
mjackson1128-Aug-14 10:15 
GeneralRe: Using Process.Start on Excel Pin
Richard Deeming29-Aug-14 1:41
mveRichard Deeming29-Aug-14 1:41 
GeneralRe: Using Process.Start on Excel Pin
mjackson1129-Aug-14 1:55
mjackson1129-Aug-14 1:55 
AnswerRe: Using Process.Start on Excel Pin
Bernhard Hiller28-Aug-14 21:15
Bernhard Hiller28-Aug-14 21:15 
QuestionInterop.Excel.Range query Pin
Dini Ngewu28-Aug-14 0:55
Dini Ngewu28-Aug-14 0:55 
Hi guys.
I'm working on a creating an application that will read from and write to Excel spreadsheets here at work (personally I'd prefer that we migrate to using databases but I ain't the boss... yetCool | :cool: ). Here's the problem, when reading a particular value from a cell in the spreadsheet, it should be empty but it seems like when I get the range from the spreadsheet programmaticlly, it creates and assigns a value even to the empty cells in the range. Am I perhaps calling the range the wrong way? If so, how can I do this the right so that the values in the range (on the program match the values on the actual spreadsheet?

Here's the code of how I got the ranges from the spreadsheet (I commented as much as possible):

Excel.Workbook source;
Excel.Workbook file;
Excel.Workbook submit;
Excel.Range currentRange;
string fileIMDR = ConfigurationManager.AppSettings["IMDR"].ToString();
string controlSource = ConfigurationManager.AppSettings["Source"].ToString();
string submitted = ConfigurationManager.AppSettings["Submitted"].ToString();
string imdrNo = "";
application = new Excel.Application();

//Get the control source and get the next IMDRNumber
source = application.Workbooks.Open(controlSource, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
workSheet = source.Sheets["Sheet1"];
workSheet = source.ActiveSheet;

//Selecting the range
currentRange = workSheet.Range["A:B"];
AnswerRe: Interop.Excel.Range query Pin
Dini Ngewu28-Aug-14 0:59
Dini Ngewu28-Aug-14 0:59 
QuestionUnable to connect to the remote server when calling web services from code in 4.5 framework. Pin
Member 1101964328-Aug-14 0:48
Member 1101964328-Aug-14 0:48 
AnswerRe: Unable to connect to the remote server when calling web services from code in 4.5 framework. Pin
Gerry Schmitz28-Aug-14 5:28
mveGerry Schmitz28-Aug-14 5:28 
QuestionHow To Use Guid Filter in Select StateMent :( :( :( Pin
mhd.sbt27-Aug-14 19:42
mhd.sbt27-Aug-14 19:42 
AnswerRe: How To Use Guid Filter in Select StateMent :( :( :( Pin
V.28-Aug-14 1:48
professionalV.28-Aug-14 1:48 

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.