Click here to Skip to main content
15,878,871 members
Home / Discussions / C#
   

C#

 
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 
GeneralRe: How To Use Guid Filter in Select StateMent :( :( :( Pin
mhd.sbt28-Aug-14 7:54
mhd.sbt28-Aug-14 7:54 
GeneralRe: How To Use Guid Filter in Select StateMent :( :( :( Pin
V.28-Aug-14 19:18
professionalV.28-Aug-14 19:18 
AnswerRe: How To Use Guid Filter in Select StateMent :( :( :( Pin
Richard Deeming28-Aug-14 1:49
mveRichard Deeming28-Aug-14 1:49 
GeneralRe: How To Use Guid Filter in Select StateMent :( :( :( Pin
mhd.sbt30-Aug-14 4:37
mhd.sbt30-Aug-14 4:37 
QuestionProgress Bar makes copying painfully slow, a little help please? Pin
kiasta27-Aug-14 17:26
kiasta27-Aug-14 17:26 
AnswerRe: Progress Bar makes copying painfully slow, a little help please? Pin
Ravi Bhavnani27-Aug-14 17:44
professionalRavi Bhavnani27-Aug-14 17:44 
GeneralRe: Progress Bar makes copying painfully slow, a little help please? Pin
kiasta28-Aug-14 4:20
kiasta28-Aug-14 4:20 
AnswerRe: Progress Bar makes copying painfully slow, a little help please? Pin
Roger50027-Aug-14 18:04
Roger50027-Aug-14 18:04 
GeneralRe: Progress Bar makes copying painfully slow, a little help please? Pin
kiasta28-Aug-14 5:03
kiasta28-Aug-14 5:03 
GeneralRe: Progress Bar makes copying painfully slow, a little help please? Pin
Roger50028-Aug-14 11:51
Roger50028-Aug-14 11:51 
GeneralRe: Progress Bar makes copying painfully slow, a little help please? Pin
kiasta29-Aug-14 8:46
kiasta29-Aug-14 8:46 
AnswerRe: Progress Bar makes copying painfully slow, a little help please? Pin
OriginalGriff27-Aug-14 22:36
mveOriginalGriff27-Aug-14 22:36 

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.