|
Hello!
I'm trying to read some data in from Excel.
Now the spreadsheets that I'm accessing contain columns of data, and these columns may sometimes be blank, the main table might start a few columns in and so on.
A raggedy old spreadsheet!
In addition to this I don't know how many rows or columns there will be, so I need to be able to handle this.
All the examples I've seen in the searches I've made have hard-coded limits.
For example my table might look like this (can't quite format this right, but you'll get the idea):
DEPT.M LLD.OHMM MSFL.OHMM RHOB.G/CM3 NO SONIC IGLOO FISH#
1450 12.4303 2.279 2.3188
1450.25 12.4494 5.0599 2.3323
1450.5 14.7747 2.0675 2.2776
1450.75 14.768 1.2149 2.217 0.3974
1451 13.1767 0.4151
1451.25 16.8165 0.2921 0.3974
1451.5 29.4913 0.4151
1451.75 48.8114 0.2921
1452 44.7025
1452.25 28.3492
1452.5 19.2471 2.2749 2.1967 13.1371 0.3974
1452.75 13.4801 1.8502 2.232 13.3881 0.4151
1453 3.2926 2.3583 13.8325 0.2921
1453.25 3.6341 2.4099
1453.5 4.1754 2.356 102.0509 16.9615 10.3197
1453.75 16.9615 5.3556 2.3608 106.603 18.0078 10.7229
1454 18.0078 4.9902 2.3258 105.3982 17.1981 10.2939
1454.25 17.1981 4.6068 2.249 108.3167 16.2081 9.6294
1454.5 16.2081 3.389 2.2199
1454.75 15.7188 1.9904 2.1252
1455 18.0351 128.8776 1.7491
1455.25 28.9451 656.4312 1.4863
1455.5 43.2879 65.2774 1.6644
1455.75 31.8807 12.309 2.182
1456 18.3605 9.6465 2.3213
1456.25 19.039 7.1053 2.1123
1456.5 25.825 9.4629 1.6977
I have this kind of example below, but the limits are hard-coded. How can I get the correct limits so that I can read the whole sheet, regardless of it's size?
<br />
<br />
Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(1);<br />
<br />
for (int i = 1; i <= 10; i++)<br />
{<br />
Excel.Range range = worksheet.get_Range("A"+i.ToString(), "J" + i.ToString());<br />
System.Array myvalues = (System.Array)range.Cells.Value2;<br />
string[] strArray = ConvertToStringArray(myvalues);<br />
... etc<br />
}<br />
<br />
But what I really want is (pseudo-code in CAPS):
<br />
for (int i = 1; i <= worksheet.NUMBER_OF_ROWS; i++)<br />
{<br />
Excel.Range range = worksheet.get_Range(THE_WHOLE_ROW[i]);<br />
System.Array myvalues = (System.Array)range.Cells.Value2;<br />
string[] strArray = ConvertToStringArray(myvalues);<br />
.. etc <br />
}<br />
Or maybe there's a better way to get at all the data?
Thanks in advance for any help you can offer.
-- modified at 2:42 Monday 9th July, 2007
|
|
|
|
|
Hopefully this is still relevant to you . . .
to do worksheet.get_Range(THE_WHOLE_ROW[i])
we use this snippet:
int lastUsedColumn = worksheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell, Type.Missing).Column;
Range firstCell = (Range)worksheet.Cells[rowNumber, 1];
Range lastCell = (Range)worksheet.Cells[rowNumber, lastUsedColumn];
Range wholeRow = worksheet.get_Range(firstCell, lastCell);
|
|
|
|
|
|
Hi,
I was checking on of our dlls using Resourcer, and found that Switch case was converted to If - Else loop in the dll. Is this done by framework compiler or by Resourcer?
If this is done by the compiler, why don't we directly use If - Else instead if Switch case?
Could anyone throw some light on this?
Regards,
Blumen
|
|
|
|
|
Not sure. I'd suspect the compiler decides how to generate the IL code...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hi ,
How can I Set the Parent of Control On Any Form to Desktop?
ie. want to set controls parent as Desktop ,not the form which contains
the control.
Fly Like An Eagle With MIGHTY POWER.
|
|
|
|
|
I have written all the commands required to do live serach in a method.I am calling that method asynchronously using threads.Although I have created 20 threads and calling the search method from all these 20 threads.(It's Like If have a paragraph with 20 sentences, I want to call my search method 20 times asynchronously without waiting for first one to complete. )The problem is when I moniter my network traffic I can only see 2 connections to the server Instead of 20.Can anybody tell me what is the problem why I can't make 20 connections to MSN Live server.From my programs trace I can see that all 20 treads are being created and callback is also happening for all 20, but what I feel they all are using same 2 connections thus I can't see a boost in performance.
Note I am using synchronous version of MSN web Search method.
|
|
|
|
|
I have figured out the problem, firstly according http RFC we should not make more the two connection to a web server,hence .NET complies with it and by default allows us to make only two connections to the web server,it can be changed fairly easily by making changes to machine.config file.
But there are various other aspects which should be taken care while doing so,in order to get maximum out of your multi threaded application.Please refer to following links they will to remove all doubts.
http://codebetter.com/blogs/steve.hebert/archive/2006/07/14/147371.aspx
http://codebetter.com/blogs/steve.hebert/archive/2006/07/20/147565.aspx
http://blogs.msdn.com/tess/archive/2006/02/23/537681.aspx
|
|
|
|
|
Hello
I want to use multithreading in my application. But i have not more idea about this. So plz help me, if someone can.
Thanks
Devesh Mishra
|
|
|
|
|
you can search on net for threading details or read some book on it
anyhow see the following links
http://www.codeproject.com/csharp/threader.asp
http://www.albahari.com/threading/
with vs.net 2005 it's more easier to use threads. You just have to drag/drop the backgroundworker control and code on it's appropriate event
|
|
|
|
|
Thanks. I have done it..
Devesh Mishra
|
|
|
|
|
Google with this keyword "C# Multithreading".
|
|
|
|
|
search in msdn for Boolean Threading
|
|
|
|
|
hi all,
Can anyone help me with the code for getting the external ip of my machine using C# windows application?
Thanks in advance
Regards
Anuradha
|
|
|
|
|
|
hi michael,
i need to know the external ip given by the ISP provider when connected to the internet.i need the code to achieve this.
Hope i am clear now.
Thanks in advance.
Regards
Anuradha
|
|
|
|
|
Have to tried the link above?
I think it should work.
|
|
|
|
|
The first result here[^] looks promising.
Cheers,
Vıkram.
After all is said and done, much is said and little is done.
|
|
|
|
|
|
|
I just installed directX 9.0 and it sits in the directory DXSDK, how to do set my C# to talk to the directX components???
Thanks
samuel
|
|
|
|
|
You asked a mouthfull. And the SDK is more C++ oriented far as when i last checked it out.
In a C# App you can Add Reference..."Microsoft.DirectX" and "Microsoft.DirectX.Direct3DX" (for the version you want to work with)
of course DirectSound etc aswell if you need it.
However if you are wanting to make 3D games using DX then this might be a better starting point:
Microsoft XNA Studio
http://msdn.microsoft.com/xna/[^]
Comes with a space shooter game and all source code in C# all working. Could be eaiser for you if you are new to DX
Other options are less 'clean' for use with C#, but there is alow of code available on the net just google it.
Either way good luck
Always more to learn, and i wouldn't have it any other way.
|
|
|
|
|
Good day,
I want to justify the text in my listbox. I've try to insert items in which both have the same length however the amount area won't align considering both items have the same length. How can I make the listbox justify its items so that both amount are on the right edge?
Here is the code that i've tried but items arent justified:
<br />
private void Form1_Load(object sender, EventArgs e)<br />
{<br />
string stramount1 = "900.00";<br />
string stramount2 = "3400.00";<br />
string description1 = "Basic Salary......................"+stramount1; <br />
string description2 = "Basic Salary....................."+stramount2;<br />
<br />
listBox1.Items.Add(description1);<br />
listBox1.Items.Add(description2);<br />
}<br />
thanks.
|
|
|
|
|
Simple answer? You dont
You could try measuring the text width and calculate the remaining space and fill it with calulated amount of spaces however you wont be able to get exact alignment as spaces in each font have a set size more than one pixel.
Delete your listbox and add a listview control and use that
You can add columns (so each part has a header), change alignment of each column and its easy to add items:
<br />
ListViewItem MyItem = new ListViewItem(new string[] {"Bob Marley","$10,000"} );<br />
listView1.Items.Add(MyItem);<br />
or
<br />
string sDescription = "Bob Marley";<br />
string sSalary = "$10,000";<br />
<br />
ListViewItem MyItem = new ListViewItem(new string[] { sDescription, sSalary });<br />
listView1.Items.Add(MyItem);<br />
-- modified at 0:50 Monday 9th July, 2007
Just to be clear, this is all considering there is more than one column... if you just need the salary in there and nothing else and want it right aligned you set the RightToLeft property to Yes. Thought i should cover all bases
Always more to learn, and i wouldn't have it any other way.
|
|
|
|
|
Hi,
if you really want to do that with a ListBox there are two ways:
1.
select a "non-proportional" font (such as "Courier New") where all characters
have the same width; then adjust the spaces/dots/whatever in your strings so
they all have the same length.
or
2.
Choose to draw the ListBox items yourself, by setting DrawMode to OwnerDraw;
and provide a handler for the DrawItem event (similar to a paint handler when
drawing in say a Panel). You do know the items in a ListBox dont have to be
strings ? They can be instances of whatever class you come up with, and
your DrawItem handler could make use of that...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
