Exemplos de _range em C# (CSharp)

Exemplo n.º 1

Arquivo: ExcelManagerProgram.cs Projeto: jobseeker333/Csharp

 public ExcelManager(string filePath, string sheetName = "Data")
 {
     _filePath = filePath;
     excelApp = new Application();
     if (excelApp == null)
         throw new Exception("Excel could not be started.  Check your Office installation.");
     //excelApp.Visible = true; //uncomment to see it being created
     _wb = excelApp.Workbooks.Add(Xl_wbATemplate.xl_wbATWorksheet);
     _ws = (Worksheet)_wb.Worksheets[1];
     if (_ws == null)
         throw new Exception("The workbook could not be created.  Check your Office installation.");
     _ws.Name = sheetName;
     _range = _ws.Used_range;
 }

Exemplo n.º 2

 public ExcelManager(string filePath, string sheetName = "Data")
 {
     _filePath = filePath;
     excelApp  = new Application();
     if (excelApp == null)
     {
         throw new Exception("Excel could not be started.  Check your Office installation.");
     }
     //excelApp.Visible = true; //uncomment to see it being created
     _wb = excelApp.Workbooks.Add(Xl_wbATemplate.xl_wbATWorksheet);
     _ws = (Worksheet)_wb.Worksheets[1];
     if (_ws == null)
     {
         throw new Exception("The workbook could not be created.  Check your Office installation.");
     }
     _ws.Name = sheetName;
     _range   = _ws.Used_range;
 }

Exemplo n.º 3

 set => SetProperty(ref _range, value);