Anand wrote:
> Greetings,
>
> How can I find the number of active columns and rows used in an excel work
> sheet?
> What I mean is how can i find the last column and row or cell position,
> where the data is stored in an excel sheet?
>
> A code snippet would be of great help.
>
> Thanks for your cooperation and help.
>
> Best regards,
> Anand
Anand,
A worksheet has a UsedRange property that may be what you need.
Gerard
using Excel = Microsoft.Office.Interop.Excel;
private Excel.Workbook thisWorkbook = null;
protected void ThisWorkbook_Open()
{
Excel.Worksheet sheet;
Excel.Range usedrange;
Excel.Range lastcell;
sheet = (Excel.Worksheet) thisWorkbook.Sheets[1];
usedrange = sheet.UsedRange;
lastcell = sheet.Cells[ usedrange.Rows.Count, usedrange.Columns.Count
];
}
If you have access to the Spreadsheet in question you can name ranges
of cells:
Insert -> Names -> Define
Then
usedrange = sheet.get_Range( "DATA", Type.Missing );
for example. (Don't worry about Type.Missing).
--
http://mail.python.org/mailman/listinfo/python-list
