88 lines
3.2 KiB
C#
88 lines
3.2 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using ExcelRefer = Microsoft.Office.Interop.Excel;
|
|
|
|
namespace ReadFromExcel
|
|
{
|
|
class Excel
|
|
{
|
|
ExcelRefer.Range range;
|
|
ExcelRefer.Application excelApp;
|
|
ExcelRefer.Workbook excelWorkBook;
|
|
ExcelRefer.Worksheet excelWorkSheet;
|
|
|
|
public void InitExcelConnection(string excelFilePath)
|
|
{
|
|
try
|
|
{
|
|
excelApp = new ExcelRefer.Application();
|
|
excelWorkBook = excelApp.Workbooks.Open(excelFilePath, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
|
|
excelWorkSheet = (ExcelRefer.Worksheet)excelWorkBook.Worksheets.get_Item(1); // Zugriff auf erstes Tabellenblatt
|
|
range = excelWorkSheet.UsedRange;
|
|
}
|
|
catch (Exception)
|
|
{
|
|
}
|
|
}
|
|
|
|
public float[] ParseExcelData(float sheet_Metal_Material_Thickness)
|
|
{
|
|
float[] sheetMetalValues = new float[5];
|
|
try
|
|
{
|
|
// Gehe das ganze Zabellenblatt durch
|
|
for (int i = 1; i <= range.Rows.Count; i++)
|
|
{
|
|
// Zugriff auf jede Zeile
|
|
string name = ((range.Cells[i, 1] as ExcelRefer.Range).Value2).ToString();
|
|
|
|
if (name != null)
|
|
{
|
|
if (name.ToString() == sheet_Metal_Material_Thickness.ToString())
|
|
{
|
|
sheetMetalValues[0] = Convert.ToSingle(((range.Cells[i, 1] as ExcelRefer.Range).Value2));
|
|
sheetMetalValues[1] = Convert.ToSingle(((range.Cells[i, 2] as ExcelRefer.Range).Value2));
|
|
sheetMetalValues[2] = Convert.ToSingle(((range.Cells[i, 3] as ExcelRefer.Range).Value2));
|
|
sheetMetalValues[3] = Convert.ToSingle(((range.Cells[i, 4] as ExcelRefer.Range).Value2));
|
|
sheetMetalValues[4] = Convert.ToSingle(((range.Cells[i, 5] as ExcelRefer.Range).Value2));
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch (Exception)
|
|
{
|
|
}
|
|
excelWorkBook.Close(true, null, null);
|
|
excelApp.Quit();
|
|
|
|
return sheetMetalValues;
|
|
}
|
|
|
|
//public void ParseExcelData()
|
|
//{
|
|
// // Gehe das ganze Zabellenblatt durch
|
|
// for (int i = 1; i <= range.Rows.Count; i++)
|
|
// {
|
|
// // Zugriff auf jede Zeile
|
|
// if ((range.Cells[i, 1] as ExcelRefer.Range).Value2 != null)
|
|
// {
|
|
// try
|
|
// {
|
|
// string title = (string)(range.Cells[i, 1] as ExcelRefer.Range).Value2;
|
|
// string description = (string)(range.Cells[i, 2] as ExcelRefer.Range).Value2;
|
|
|
|
// }
|
|
// catch (Exception)
|
|
// {
|
|
// }
|
|
// }
|
|
// }
|
|
// excelWorkBook.Close(true, null, null);
|
|
// excelApp.Quit();
|
|
//}
|
|
}
|
|
}
|