rshin2020
Last Activity: Feb 24 '10, 06:19 AM
Joined: Dec 22 '09
Location:
-
That's a good suggestion. Will consider it. But as for now, I was asked to do it in excel. I am unsure of where to put the code. Thanks a lot, Bassem. -
Any replies? What part do i have to change? From a logical aspect, i understand that i have to copy the array and paste it somewhere. I'm not sure where to paste it though. Please help. Thanks a lot in advance.Leave a comment:
-
Hi. With reference to the above topic, how do I get to display another table of data in the same sheet? I managed to display the first table with data but now i need to display a second table. Where do I change or add the codings?
here's the latest:
...Code:using System; using System.Collections.Generic; using System.Text; using Excel = Microsoft.Office.Interop.Excel; namespace UncFunc {Leave a comment:
-
I've already completed 3 quarter of what I am suppose to do. I dont know why he gave me this project. I just need to know why isnt that displying as it should in excel. I know its not that hard to mend it.Leave a comment:
-
The code was given by my boss, written specifically to call a spreadsheet. I wrote the codes to display the data and so on. The only thing now is that that code to eliminate the _ is not displaying on the spreadsheet.Leave a comment:
-
Thank you so much!! Really appreciate your time explaining it. The problem is that it doesnt display the results in excel but in the immediate window it does. Why is that so?Leave a comment:
-
I have typed the 2 lines in immediate window, and it seemed to work but it wont display as such in the excel file. Thats what i don't understand. Please help. Thanks.Leave a comment:
-
Yes, I am able to read the spreadsheet. All values can be displayed. Right now, i just need a way to replace the _ with a space. From X_2 to X2. Thats all. Any idea?. Thanks in advance.
Here's the full coding:
...Code:using System; using System.Collections.Generic; using System.Text; using Excel = Microsoft.Office.Interop.Excel; namespace UncFunc { class ReportLeave a comment:
-
I'm sorry. I should have made that clear. My mistake. So any solution?Leave a comment:
-
In these rows, there are values as I mentioned earlier, the X_2 and X_3. How do I assign the code to eliminate the underscores? That's all. The code you gave me didn't work. Because, why did you put 'string myValue = ("B3","B4"); '? The underscores contains in the rows of B3 and B4.Leave a comment:
-
So how else should I put it? I need to get the rows first right? The rows are B3 and B4, they already have values of X_2 and X_3 respectively. I need to eliminate the underscore. Please help. Thanks.Leave a comment:
-
I am still getting an error. I have replaced "X_2" with "B3,B4" as i have in the excel column. It says identifer expected at the "B4". Do I need to have a method written for it?
Here's what I have done:
Code:string myValue = ("B3","B4"); string newValue = myValue.Replace("_", "");Leave a comment:
-
Eliminate a hyphen/underscore for a subscript
Hi. I need to eliminate the underscore for X_2 where the 2 is a subscript. What is the code like? I have a sample here but can't figure out which is what and how to change it, as I did try to change but no changes took place at all. Please help. Thanks in advance.
p/s:I have a column called...Code:string Anthem = "Star Spangled Banner"; Anthem = Anthem.Replace(" ", ""); -
Its okay, trial and error i guess.... Line 33? I have tried customizing it too, but still no change. I have tried to customize many places as well, but still no change. :(Leave a comment:
-
Nope, my boss had this example and asked me to go through it. I have added some codes inside to customize it. Its just that i couldnt figure it out where the mistake is.
"line 54 looks pretty obvious since you only get through row 5 and the loop goes from 0 to 4 (that would be 5) " meaningi have to change the loop to 4? But is that line even used? since i commanded it with //.Leave a comment:
-
Displaying the rest of data in Excel
I have a script as below. I need to display the data in excel. This is in C#.net. Right now, the data only displays up till B5 and C5. How do I make it display till B8 and C8. The values for symbol and unit are null.
...Code:using System; using System.Collections.Generic; using System.Text; using Excel = Microsoft.Office.Interop.Excel; namespace UncFunc { class Report { -
Alright. Thank you very much for your explanation.Leave a comment:
-
So in other words, from what i understand, that it just sets a default if no other exact values are entered? Am I right?Leave a comment:
-
Code Definition
Hi. Below here i have a piece of code. I don't understand the exact meaning of the Type.Missing here. What's its use for?
Thanks in advance.Code:objBook.SaveAs("Report Uncertainty.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); -
the last one refers to the curly braces at the end. I dont know whats wrong there.Leave a comment:
No activity results to display
Leave a comment: