tags:

views:

178

answers:

1
Q: 

how do i get a count of columns that contain data from excel

I'm wondering if there is a simple property in the Excel interop that returns the count of used columns--ones containing data--from a given worksheet.

In example: If myWorksheet.Columns.Count returns the total number of columns in a given worksheet, is there no equivalent along the lines of: myWorksheet.Columns.UsedCount?

I'm not sure if this question is too basic to even ask, but in searching google I can only seem to find rather arcane solutions to something that seems like a rather basic type of thing a person would want to do, when interacting with Excel.

I've tried to keep this brief by not posing up a bunch of unrelated code; but please let me know if I haven't been explicit enough.

+1  A: 

Using the interop you can get the range of used elements using

oXLSheet.UsedRange.Address

where oXLSheet is your Worksheet object

Mitchel Sellers  2008-12-10 15:29:52
I couldn't find 'Address'. but, you put me on the right path, kind sir.int usedCount = wsWorkOrders.UsedRange.Columns.Count; Worked like a charm. Thank you, greatly.
agentlame  2008-12-10 15:58:30

related questions

Displaying Flash content in a C# WinForms application
How to get the value of built, encoded ViewState?
Unhandled Exception Handler in .NET 1.1
How do I connect to a database and loop over a recordset in C#?
How do I most elegantly express left join with aggregate SQL as LINQ query
Get a new object instance from a Type in C#
.NET Testing Framework Advice
Automatically update version number
What is the difference between an int and an Integer in Java/C#?
How to write to Web.Config in Medium Trust ?
WinForms ComboBox data binding gotcha
How do you sort a C# dictionary by value?
Adding Scripting functionality to .NET applications
Floating Point Number parsing: Is there a Catch All algorithm?
How do I print an HTML document from a web service?
Decoding T-SQL CAST in C#/VB.net
Anatomy of a "Memory Leak"
How do I get a distinct, ordered list of names from a DataTable using Linq
Reliable Timer in a Console Application
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
What's the difference between Math.Floor() and Math.Truncate() in .NET?
How do I calculate relative time?
How do I calculate someone's age in C#?
Are there any conversion tools for porting Visual J# code to C#?
When setting a form's opacity should I use a decimal or double?