/*
par poznamek - do Referenci si pridejte Microsoft.Office.Core
*/

Excel.Application xApp; 
// Excel je namespace...

Excel.Workbook xBook = 
null
;
Excel.Worksheet xSheet;        
Excel.Range xRange = 
null
;

try
{
  xApp = 
new
 Excel.Application();
  
//xApp.Visible = true; // jestli ma byt videt sheet excelu


  
// Missing je z namespace System.Reflection

  xBook = xApp.Workbooks.Open(tbFileName.Text, 
false
, 
true
,
    Missing.Value, Missing.Value, Missing.Value, Missing.Value,
    Missing.Value, Missing.Value, Missing.Value, Missing.Value,
    Missing.Value, Missing.Value, Missing.Value, Missing.Value);
  xSheet = (Excel.Worksheet) xBook.Worksheets[
1
];        
  xRange = xSheet.UsedRange;          
}
catch
(Exception e){
  Dialogs.error(e.Message+
"\n"
+e.StackTrace);
}      

// nacteni dat z excelu

object
[,] xData;
xData = (System.Object[,]) xRange.get_Value( Missing.Value );
/*
v xData jsou nyni data ze sesitu, pred pouzitim protrepat.. totiz pretypovat
*/


// zjisteni rozmeru oblasti (platnych hodnot radku a sloupcu) ...

int
 
  rowStart = data.data.GetLowerBound(
0
),
  rowEnd = data.data.GetUpperBound(
0
),
  colStart = data.data.GetLowerBound(
1
),
  colEnd = data.data.GetUpperBound(
1
);

Syntax higlighted by Syntax highlighter, available at www.4ITDevelopers.net and www.JakNaWin.com

public
 
static
 DialogResult error(
string
 title,
string
 message){
      
return
 MessageBox.Show(message,title,MessageBoxButtons.OK,MessageBoxIcon.Stop);
    }

Syntax higlighted by Syntax highlighter, available at www.4ITDevelopers.net and www.JakNaWin.com