|
If the rows are at the end, you can find the row of the last cell that contains any data. In VBA it looks like this
Dim lastCell As Range
Set lastCell = Range("A1").SpecialCells(xlCellTypeLastCell)
From that you can work your way up deleting the blank rows. It still uses iteration but there are fewer.
The FoZ
|
|
|
|
|
around 60,000 rows are blank, this means it will create performance issue
|
|
|
|
|
Are they just the normal blank rows you get in any Excel spreadsheet? Or do they actual contain something and is making your workbook file size huge?
The FoZ
|
|
|
|
|
normal.
Suppose i send 9 rows to excel through datatable class.
and the remaining 65000 are blank, i wanted to hide these blank rows
|
|
|
|
|
If you now where the data ends, you will be able to create a range object that starts from the last row and finishes at the end of the spreadsheet then set the hidden property to true. Something like rangeToHide.EntireRow.Hidden = true;
The FoZ
|
|
|
|
|
|
Hi,
I am working on Human Resources software and i want to include face and finger print recognition in it,
i have no idea how to go about it in c#.
pls I need help on what to do.
Thanks.
|
|
|
|
|
Unfortunately, .NET is unlikely to include Face Recognition until at least V17.4, when the tecnology is mature. For the moment, that means you must join the growing band of highly-skilled teams working on getting it working reliably in the first place. Start here[^], but be aware that a lot of this technology is still under development, so what you find will not be the latest cutting edge developments. (Companies seem to have an aversion to publishing promising development until they can get the patents in place, for some reason)
You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
this link is not connecting to the server.
|
|
|
|
|
here's my code but its not functioning plz help how to fix this....
i set my masktextbox to filled up telephone number only
<br />
<br />
private void button1save_Click(object sender, EventArgs e)<br />
{<br />
if (maskedTextBox2tel.text == string.Empty)<br />
{<br />
MessageBox.Show("Plz fill up tel No");<br />
maskedTextBox2tel.Focus();<br />
<br />
}<br />
}<br />
<br />
<br />
|
|
|
|
|
crisjala wrote: here's my code but its not functioning
What is happening, do you see the message box? What are the contents of your variables, have you traced it through with the debugger?
txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
Change it to the static method:
String.IsNullOrEmpty(maskedTextBox2tel.text) == true
|
|
|
|
|
how to do Zoom to previous and next extent on map control using C#?
|
|
|
|
|
We don't know what framework you are using, you haven't supplied any code. Please supply your code. If you are using an external API (Such as Virtual Earth) you will be much better off contacting a forum dedicated to that API.
Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.
|
|
|
|
|
|
We don't know what framework you are using, you haven't supplied any code. Please supply your code. If you are using an external API (Such as Virtual Earth) you will be much better off contacting a forum dedicated to that API.
Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.
|
|
|
|
|
where can i find standard naming Conrols in C#.
I mean Prefix/like Hungarian notation.
for example:
Control Type Prefix Example
<code> Button btn btnName
GroupBox gb gbName</code>
|
|
|
|
|
You can find Microsoft standard naming guidelines here.
According to these guidelines, Hungarian Notation must not be used.
Still, nothing is said about private fields, so it's up to you to define your coding standards.
|
|
|
|
|
just check this article .
Its for VB !
and used Hungarian Notation.
http:
I wanna something like this article for C# .
So Plz Help !
|
|
|
|
|
The guidlines for C# development are NOT to use hungarion notation at all. Hence you wont find a (microsoft) article defining it.
|
|
|
|
|
If you're coding for yourself, make up your own. If you're coding at work, and if there's no policy in place, stick with the format used in the file you're editing.
If you're coding at work and there is no naming policy, suggest that they implement one, and provide examples and WHY the example is valid. If there is existing code that follows a consistent formatting/naming pattern, use it as a basis to avoid having to go back and "fix" existing code. If you're on a team of programmers, and if those programmers are worth their salt, they won't dispute the need for a formatting/naming policy. Getting them to agree with your version, though, may be a problem.
For what it's worth, I've been on six different teams in the last 10 years, and NONE of them had an established formatting/naming policy.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
Just create a bunch and see what Visual Studio names them.
|
|
|
|
|
hello and have good time !
Q1.
How can change the color of #region Text ?
for example :
#region <code> txtName Textchanged</code>
.......
........
.........
..........
#endregion
Q2.
How can I change the particular code text color?
for example :
private void Reminder_Load(object sender, EventArgs e)
{
<code>ModeForm = clsGlobal.FormMode.Ready;</code>
if (ModeForm == clsGlobal.FormMode.Ready)
{
tsmiMain1.btnSaveEnable = true;
tsmiMain1.btnCancelEnable = true;
tsmiMain1.btnEditVisible = false;
tsmiMain1.btnDeleteVisible = false;
tsmiMain1.tss2Visible = false;
}
<code>cmbDaysWeek.Items.Add("1.شنبه");
cmbDaysWeek.Items.Add("2.یکشنبه");
cmbDaysWeek.Items.Add("3.دوشنبه");
cmbDaysWeek.Items.Add("4.سه شنبه");
cmbDaysWeek.Items.Add("5.چهارشنبه");
cmbDaysWeek.Items.Add("6.پنچشنبه");
cmbDaysWeek.Items.Add("7.جمعه");</code>
}
|
|
|
|
|
Goto Tools - Options..
Expand the environment node and select fonts and colors.
Have fun, there are loads to go through!
The FoZ
|
|
|
|
|
Not Clear!
Plz give more Info !
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
